Hello,
So my program needs a part that will pull the data from a specific row in the database. The data from the database is then changed and sent back to be updated using the Update and Execute Sql command.
So i pulled the Demo Example of the Update.Vee file
Everything seems to work great. However if you change the numbers that are being updated to lets say a name and try to updated it you will realize that a nice error "ExecuteNonQuery" will not allow you to do it.
So thank you for making a demo that will show me how to use the only function available and also for not putting the limitation information anywhere in the help file.
In the end thank you Agilent for making me pay over $3k for a half made software. Some updated to make this and the other limitations work would be appreciated. If anybody know how to updated an entire row in mdb please let me know. The update row example updated all the rows, but I am having hard time figuring out the code that will allow me to only update the fields in row 2 for example.
So my program needs a part that will pull the data from a specific row in the database. The data from the database is then changed and sent back to be updated using the Update and Execute Sql command.
So i pulled the Demo Example of the Update.Vee file
Everything seems to work great. However if you change the numbers that are being updated to lets say a name and try to updated it you will realize that a nice error "ExecuteNonQuery" will not allow you to do it.
So thank you for making a demo that will show me how to use the only function available and also for not putting the limitation information anywhere in the help file.
In the end thank you Agilent for making me pay over $3k for a half made software. Some updated to make this and the other limitations work would be appreciated. If anybody know how to updated an entire row in mdb please let me know. The update row example updated all the rows, but I am having hard time figuring out the code that will allow me to only update the fields in row 2 for example.
Let's use Update.vee as example. In NorthwindForModify.mdb Table1, row 2 is with ID 2. So to update row 2 which its ID is 2, I will need to change the VEE code to below, then it will works.
In short, to update a specific row, you need to know the primary key ID, then put it in the WHERE clause.