Using VB 2008 Express with Compact SQL .sdf database.
I have a form that at form load fills the form with a single record as selected by double clicking row header on a datagrid. This works fine. But when I change a field and hit the save data button error I get an error that there must be a valid update statement.
So I figured, I'll just put a button on the form and on button click run a query statement like
UPDATE Names SET name = @p1, Address = @p2
This works, but it updates every record in the file, so I changed it to
UPDATE Names SET name = @p1, Address = @p2
WHERE Name = @p3, Address = @p4
But It won't compile. I get a build error.
How do I update a single record using the query builder in the table adapter. I have tried a number of things and am getting nowhere.
Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.
This thread is more than three months old
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Marked 
