pOopOo's Q&A profile

• SQL Server Merging a database into another

  Hi everyone. I am working on an application that will use SQL Server Express locally installed on the client machines. We want to be able to deploy MDF files and merge those files into the clients existing database. For example, their databases will have a Produce table which will contain prices and varieties of products we give to the clients to sell. The clients will also have some records of their own in this table for their own produce that they sell, and we will not know about those records at all. If we update our prices and add more produce, we want to simply merge in our records (update existing and insert non-existing) without touching theirs. (scenario is fake BTW, so don't take too literally) My question is does SQL Server Expr ...Show All

• Visual Basic OleDBException Overflow

  Im getting the following error : System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217833 Message="Overflow" Source="Microsoft JET Database Engine" StackTrace: at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Home_Party_Solutions.PartyDBaseAccess.getCustomer ...Show All

• Visual Studio Viewing created instances of classes/objects?

  This may be an easy one, but since I'm rather new to the VS2003 and 2005 (in general), I'm not sure how exactly to refer to it, so it makes searching for it difficult. Anyways, while debugging a solution, I'd like to pause (breakpoint) the code at some point, and obtain a list and structure detail of any created classes or objects. (Or, a specific one at some point in the code.) You know, to verify that it was built correctly and contains proper initialization data and such. Using VS2005, mostly in VB, the app is a standard Windows Application (Form), with custom class files for such. Many thanks! Cheers, Mike. ...Show All

• Software Development for Windows Vista MSDN Online doesn't return Platform SDK documentation anymore

  I've grown quite accustomed to using the search function on MSDN to get my platform SDK / Win32 answers. However, lately, it seems that all I get are .NET hits, and no PSDK documentation anymore. And if I go to the search page on live.com, and search for something like "site:msdn.microsoft.com psdk enumerate registry keys" I get only two hits, neither of which is Platform SDK documentation. The Platform SDK documentation is BROWSABLE online, but SEARCHING doesn't seem to work. And when you're looking for some specific bit of information you vaguely remember from before, searching is what you do, not browsing. I understand that managed languages and the .NET framework is all the rage, but there are many developers who are still de ...Show All

• Visual Basic Newbi Question..

  As much as I don't care for that word, newbi.... In my IDE when writing code, I have green squckly lines under some of the code. the tool tip says "Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated. But my code still runs without error. What does this mean Brian It is only a warning saying that you are using an instance of an object to use a shared method...for example Dim myfile As System . IO . File myfile . Copy ( "Source" , "Dest" ) will produce the same warning because MyFIle is an instance of System.IO.File and all that is needed in the code is System . IO . Fi ...Show All

• Visual Studio Express Editions HELP Needed in retrieving the ORACLE_HOME location-VC++

  hello all, How to retrieve the ORACLE_HOME location from Registry Editor through VC++ i am having both Oracle 9i and Oracle 10G in my desktop,ORACLE_HOME key resides in different folders under Software folder of HKEY_LOCAL_MACHINE. How would i retrieve the ORACLE_HOME Location from Registry Editor according to the Oracle version selected in the Home Selector through VC++ Is there any MFC functions to do this kindly advise   thanks Athish hello Hopefully one of these APIs: http://msdn2.microsoft.com/en-us/library/ms724875.aspx regards, rico ...Show All

• Visual C++ Question about debugging

  Dear All, I am going to debug an application with the scenarios described below. The application will crash if it idles for certain period of time. For example, 10 - 15 minutes. I have used the log file from Dr.Watson to investigate the problem but really no idea on the following information in the log file. FramePtr ReturnAd Param#1 Param#2 Param#3 Param#4 Function Name 0241fc64 77f57546 00130548 77f5475c 00130548 6c44b8cc ntdll!NtWaitForSingleObject 0241fd30 77ed28c8 00130000 00040008 00000118 6c44b8cc ntdll!RtlEnterCriticalSection 0241fd7c 6c3e152d 00000040 00000118 00000000 6c3e0b7c kernel32!LocalAlloc 0241fda8 6c3e19d7 00000000 00000003 6c3e13de 6c3e0b67 !Ordinal824 0241fdec 6c3e64e4 00000000 00000000 0000 ...Show All

• Visual Studio Express Editions Capture a picturebox

  I am trying to capture the contents of a picturebox. The picturebox's location property is 0, 0 Only the upper left corner of the picturebox and part of whatever is in the background, is captured. Dim b As Bitmap Private Sub CapturePictureBox1() Dim myGraphics As Graphics = PictureBox1.CreateGraphics() Dim s As Size = PictureBox1.Size b = New Bitmap(s.Width, s.Height, myGraphics) Dim capturedGraphics As Graphics = Graphics.FromImage(b) capturedGraphics.CopyFromScreen(PictureBox1.Location.X, PictureBox1.Location.Y, 0, 0, s) End Sub Private Sub Button1_Click(ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click CapturePictureBox1() End Sub ...Show All

• SQL Server Attribute Relationship ?

  I think understand how and why we need to setup attribute relationship but I'm probably missing one important thing here... If I have the following hierarchies in my dimension: Circulaire > Segment > Promotion Circulaire > Promotion Logically I should have defined my attribute relationship like this: Circulaire Segment - Circulaire Promotion - Segment - Circulaire Promotion Key - Promotion This result in the following error: This dimension contains one or more redundant attribute relationships. These relationships may prevent data from being aggregated when a non-key attribute is used as a granularity attribute in a cube. Verify the following relation ...Show All

• SQL Server Union all does not union all rows

  Hi all, I have a Union All transformation with 4 inputs and one output when I debug the package the sum of the different inputs rows does not match the row count in output. I don't understand, I've used the Union All transform many times and I've never seen this. Any idea why this could happen Are you talking about the arrow on the SCREEN or the output table saying 350 records Is it REALLY outputing 500 rows, or 350 in the next step It might just be a screen display issue. For example it is displaying the first record set to reach the union or the last or something. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. ... VB.net 3D Level editor for XNA .. Tridex .... Beta 1

  Hi, I have good news for VB.NET developers any ways, I have used XNA 1.0 extensively and have converted a 3D lever editor tool I am calling Leveler 3D to XNA , here is the demo of the old direct x version: http://www.tridexconsultants.co.uk/pages/DirectxLevler3D.htm Details: 1. Drag drop Xna files (Textures and Meshes) 2 Extensive Maths classes, trigonometry, Vector, Matrix, Planes, Spheres, Bounding etc. (Many More) 3. Extensive animation tools 4. Fast load save levels (XNA is brilliant at compressing X files!!!! 5 Fully Serialized scenes 6.Mouse click selection of games objects 7. Animation (Curves, Circle, Path, Waypoints, Interpolators etc... 8. Lighting (Curr ...Show All

• SQL Server Update Statistics, Auto_Update_Statistics - please clarify

  Test Qn I seem to be having trouble posting a reply, so I'm trying this and will edit in a moment... Hi Smitha. Basically, what the "If you instruct the database engine not to automatically maintain statisics, you must manually update the statistical information." statement is syaing is that you have told the engine not to auto track/update stats info, so you are responsible for updating them yourself manually, via a method like the one you mention above. As for if it is frequent enough, or best for your application, it always depends. Well, I can't seem to post the rest of my response...I'll keep trying... I can't see to write anything else about this...everytime I try putting in a paragragh ...Show All

• Visual C++ Smart Bridge up-date

  Hi, Smart Bridge up-date start each time I open my PC and can install the up-dates in the program. It's run without end and I can't use my PC. Can you help me someone ...Show All

• Windows Forms How can I change a child control bounds when dropped onto a ParentControlDesigner

  I am developing a windows forms ContainerControl and ParentControlDesigner and I need to alter the location and size of child controls as they are dropped onto the contained in design mode. I am trying to do something similar to a FlowLayoutPanel control. When controls are dropped onto a FlowLayoutPanel their location is automatically adjusted. I have tried caching the control being dragged in the CanParent method and I can alter the control's bounds in the OnDragComplete method but the control's original rectangle and associated adornments get left behind: Public Overrides Function CanParent( ByVal control As System.Windows.Forms.Control) As Boolean Me ._dragDropControl = control Return TypeOf control Is Scrolla ...Show All

• Visual C# how to get every element of a string?

  For example, string s = "12"; then, how can I get the last element "2" of s For array, we can access each element by the index, however, I do not know how to deal with a string.. Any suggestion Thanks! I don't really understand what you're trying to do...just remove the last character from a string Then you can just do: if (s.Length > 0) s = s.Substring(0, s.Length - 1); ...Show All