I'd advice to not use the "in" operator with a user-defined varchar, but to name the values individually. SELECT * FROM tableName WHERE ColumnId = 1 OR ColumnId = 2 You can simply concatenate "OR ColumnId = @value" to the query and set the parameters. Bastard Programmer from Hell :suss:

For adding a CRecordset derived in VS2008 you should do as follows. 1. In the Solution Explorer or Class View, right mouse click on the root node and choose Add --> Class. 2. From the Add Class dialog choose "MFC ODBC Consumer" and press Add. 3. Press the "Data Source" button to choose a data source and the required table (just follow the wizard). 4. Press "Finish". 5. Two files will be created CPP and H files. Enjoy, Dudi.

Ok man, i've found the solution in VC6++ i've went to the class view of the class Frame im using. right-click -> Add Windows Message Handler.. then on the bottom under: "Filter for messages available for class" i selected "Window" and added the WM_SYSCOMMAND to my class wizard. now it work's i think that the problam was that even if i added it manualy, there was no trigger to the event. now since the message is in the wizard, and known by the compailer it triggers the event. Thank's anyway.. Good day

Are the records in the set truly deleted? Try: while (! rsSpeGraphs.IsEOF()) { if (rsSpeGraphs.IsDeleted()) TRACE(_T("Recod is deleted.\n")); rsSpeGraphs.MoveNext(); } "One man's wage rise is another man's price increase." - Harold Wilson "Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons "Man who follows car will be exhausted." - Confucius

Nishad S wrote: A list of colors is available here[^] Great! "Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow Never mind - my own stupidity is the source of every "problem" - Mixture cheers, Alok Gupta VC Forum Q&A :- I/IV Support CRY- Child Relief and You

Hi, DataGridViewDataErrorContexts is an enum and has the FlagsAttribute, which means all members are really bit-oriented flags, so try this: if ((e.Context & DataGridViewDataErrorContexts.Parsing)!=0) { MessageBox.Show("parsing error"); } PS: please use PRE tags to show code, as I did (see the difference?) :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

Got'ya.. anyway, your solution isnt working. i'll tell you what i found out maybe you'll know in my code where i do originNode.Remove(); the targetNode.Nodes.Count doesnt change.. for Example, if i had 2 nodes under the targetNode, after the Remove function, still staying with 2..

The reason is following property is set to true. colLink.UseColumnTextForLinkValue = true; Set it to false. Then it will resolve your problem.

Hi Eyalle, Happy Hanukkah ! eyalle wrote: it will be great if you will have the time to post that code, im sure it will help lot's of programmers.. It will be a few months before I get to this, probably. Consider the many benefits built into "native" drag-and-drop including (with effort) drag-dropping stuff from one application into another, interacting with the clipboard, the whole DataObject functionality built-in, dropping files or whatever to the desktop, etc. best, Bill "Many : not conversant with mathematical studies, imagine that because it [the Analytical Engine] is to give results in numerical notation, its processes must consequently be arithmetical, numerical, rather than algebraical and analytical. This is an error. The engine can arrange and combine numerical quantities as if they were letters or any other general symbols; and it fact it might bring out its results in algebraical notation, were provisions made accordingly." Ada, Countess Lovelace, 1844

I'm sorry, I got your question wrong. In your case, instead of using the Leave event, use the Validating event and if the user chooses cancel, set e.Cancel = true (e is the ValidatingEventArgs passed to the method).

You could build an instance of TreeViewEventArgs using tvwProjects.SelectedNode and pass it to the factored method.

Try this link. I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison. Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. Thanks Md. Marufuzzaman