Mjoyner24's Q&A profile

• SQL Server Strange Issue in T-Sql

  Hi, I have bumped into a strange problem. The below select query does not return back any results : select skuid, itemnum, rmsskuid from sku where rmsskuid is not null However, the same query with a top clause returns results: select top 500 skuid, itemnum, rmsskuid from sku where rmsskuid is not null I started to investigate(with queries below) in more than one ways..however the problem remains un resolved. The below query returned the count correctly select count(*) from ( select skuid, itemnum, rmsskuid from sku where rmsskuid is not null) a The below select query does not return back any results : select a.* from ( select skuid, itemnum, rmsskuid from sku where rmsskuid is not null ) a The Table Create Scr ...Show All

• Visual C++ C++ Generics issue

  Hi. I'm having a problem converting some C# to C++/CLI, which involves generics: //// C# code (compiles and runs): ///////////////////////// // The constraint requires the generic parameter T // to be convertable to the type of the derived class: public abstract class MyBaseT<T> where T : MyBaseT<T> { public MyBaseT() { } } public class MyDerived : MyBaseT<MyDerived> { } //// (equivalent ) C++/CLI code: //////////////////// generic<typename T> where T : MyBaseT<T> public ref class MyBaseT abstract { public: MyBaseT() { } }; public ref class MyDerived : MyBaseT<MyDerived> { }; /// Compiler error: Error 1 error C3393: syntax error in constraint cla ...Show All

• Windows Forms How do I make an "Enter" event?

  I am making a Web Browser using the "Microsoft web browser" control. I have a combo box and a "go" button, but I want to do two things with them. FIRST, I want the home page to load in the browser when the program opens, and SECOND I want the courser to automatically go to the combo box for them to type in a URL, then I want them to be able to press "Enter" and it will take them to there website, without having to mouse over to the "go" button and click it. I looked around on the net for help with these questions, but can't find it anywhere. This might be really basic stuff, but I'm new to this whole programming thing, so I don't know much about it. HERE is code I have now: ======================= ...Show All

• SQL Server RDA with Identity column.

  Hi Everyone: I am new to Mobile programming. I am now working on a mobile project. I encounter an issue when I sync the data: cause I can't modify the schema, so I have to use RDA instead of Merge replication on sql server 2005. However, There is an identiy column on each table I will pull them down to local mobile database. And I will use those identity columns to connect tables. Even worse, the photo's new name will combine the photoID which is an identity column. There would an issue, if i sync data, the photoID would be same on different local mobile databases. And there would be generate same identity value when users sync data. How can I avoid those issues If you have any good ideas, please help me out so that I can meet ...Show All

• Windows Live Developer Forums can't add the "updated spaces" world map to my space

  hello ! if you take a look on the space site http://erzengel0682.spaces.live.com/ you can see in the bottom right corner a world map with yellow stars, which refers to different (updated) space sites, the topic is "updated spaces". so i click on the "+" and choose "add to my space", then my own space will be opened but nothing has changed and i can't see the world map. i have the "updated spaces" rubric, but a list, no map, and i can't change it. i can't find the map in the gadget galleria. does anybody know what to do cheers, 4sh ...Show All

• SQL Server programs!!!!

  i repaired my problem with the SQLserver Express.....now i know how to use....but nowadays i have some problems with my DataBase....i would like you people share your DataBase to see what is my problem......mi msn is jmontes32@hotmail.com .......if you give some programs....i will learn more about SQL server.. sorry if you find some grammmathical mistakes....i'm learnig english see you jamie You most likely will not have many folks 'sharing' their databases with you. However, you can download and install sample databases that Microsoft makes available. Here are three. Databases -AdventureWorks http://msdn2.microsoft.com/en-us/library/ms124659.aspx Databases -Northwind and Pubs http://www.microsoft.com/dow ...Show All

• SQL Server SQL Server 7 seems to hibernate

  I am running SQL Server v8.00.194 on Windows Server 2003, Standard Ed. v5.2.3790 on a 3 GHz P4(Hyper-Threaded) with 1GB of RAM. I have a table with 325,000 rows with 60 columns averaging length=50. When I stop running queries for more than 15 minutes the server seems to hang or hibernate. Any ASP pages accessing the table will timeout, even with a timeout setting of 20 minutes. When I run a query directly from Query Analyzer on the server it takes about 3-5 minute and then the results are returned. Then I am able to run Query Analyzer or ASP pages and results are returned in a few seconds. After 15-20 minutes it has the same issue and stops returning until Query Analyzer is run on that table. Thank you for any assistance, Stev ...Show All

• SQL Server Aggregation Processing Use of All Processors Issue

  In 2000 when MSAS wanted to create aggs it did a great job without me doing anything of using all available processors pretty darn near or at 100%. In SSAS 2005 I have an 8-processor box (4 dual cores actually) and its only using 1 of the 8. Anyone know how to unlock that Some property perhaps Based on 8 processors I used 8 partitions and it did better, but not much. Then I tried 16 partitions (many programs use 4X threads per processor to maximize parellelization, but if something is well written 1x should be sufficient) and I think it helped - utilization is up to 30 or 40 percent during the cube process part, but the aggregation part is still pretty low - 20-30% overall. How many procs do you have ...Show All

• Visual C++ Bitmap on TabPage

  Hello all, I have a test.bmp file and I added it in resources by importing..I see it as  app.rc\bitmap\test On Tabpage I created a picturebox and try to add as this->pictureBox1->Image=gcnew Bitmap(this->GetType(),"test.bmp"); It says resource cannot be found in the class.. How to access it and display it on  tabpage Thanks in advance   You've embedded the bitmap as a native Windows resource, not a .NET resource. Afaik, the C++ IDE doesn't yet support .NET resource editing. I'll move your thread to the C++ General forum for a better answer. ...Show All

• Windows Forms Data entry box and site navigation

  hello, I'm wondering if it is possible to have a dialog box that allows data entry when you open the document; the data entered would populate parts of the form... also, would like to have navigation for the form but I understand this doesn't work in Word forms (Word 2003). Is there any way around this (such as having this available with the above mentioned entry dialog), short of having to do a digital software certificate I Just guess your requirement and I think maybe working with office core using InterOP can help you. follow an easy example for you: http://www.codeproject.com/useritems/C__Word_2003_Mailmerg.asp ...Show All

• Visual C# Urgent help

  i have created a windows form as main form. I also created another form as close confirmation dialog. So when i click on the close button which locates on the top right corner of my main form, it should display the close confirmation dialog. And there are two buttons on the confirmation dialog, "yes" and "no". Then click "yes", exit the whole application, or click"no", only close the confirmation dialog and focus back to the main form. However, when i click "no", it close (or may just hide) both of the forms, but not exit the whole application, which means the application is still running, but i couldn't see it. why's that I also created a menuitem called "exit", when click o ...Show All

• Windows Forms ToolStrip doesn't scale buttons in the overflow menu

  Hi there I use several ToolStrips in my application. They are placed in MDI-forms, which are created dynamically at runtime. The application has to adjust to the users DPI-setting. The AutoScaleMode property is fine, but as i see it, it doesn't work for the dynamically created MDIs. Because of this i scale them by myself with the Scale method. This works quite good for everything but the ToolStrip. I have several buttons inside the toolstrip, added with the ToolStripControlHost. When the form is scaled, everything resizes fine, but the toolstrip scales only the buttons that are visible (not in overflow). This is really annoying, and till now, i couldn't find a workaround. Hope someone can help me here. PS: sry, englis ...Show All

• Visual C++ Error Message

  I have just loaded BTBroadband Help. When I boot up I get the following message: SmartBridge Alert: BT Helpnotifier.exe entry point not found The procedure entry point GetProcessImageFileName W could not be located in dynamic link library PSAPI.DLL I close the message and carry on. The only effect appears to be that I cannot have instant messages in my BTBroadband Help program. Can anyone help My OS is XPSP2 Professional. Strange, that function should be available on XP. Is psapi.dll loaded from windows\system32 What is its version number -- SvenC ...Show All

• Visual Studio Unable to create SourceSafe Object

  I'm currently using VSS2005. I did register ssapi.dll by "regsvr32 ssapi.dll"; however, I got error: "could not create object named "SourceSafe" from vbscript below. Please help. Set oVSSDatabase = WScript.CreateObject( "SourceSafe" ) oVSSDatabase.Open ( "C:\VSSData\srcsafe.ini" ) Set oVSSItem = oVSSDatabase.VSSItem( "$/Test/testingfile.cs" ) oVSSItem.Parent.LocalSpec = "C:\Projects" oVSSItem.Get Do you get any other error code that may help pinpoint the problem You may need to look in registry at the following key HKEY_CLASSES_ROOT\SourceSafe. If you're working with VSS 2005, it should look like this: [HKEY_CLASSES_ROOT\SourceSafe] @="Microsoft Visual SourceSafe Automatio ...Show All

• SQL Server ::FN_VIRTUALFILESTATS doesn't work in Sql2k critical

  Hi everyone, I perfectly know that this post is bad allocated but it's a critical one. We've a cluster and there it don't get rows. I'm trying this sentence: SELECT * FROM ::FN_VIRTUALFILESTATS and from our production server doesn't return results. Why the hell not However from other servers it returns data. Thanks for your time, ...Show All