Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to verrify an Insert into using Sqlexec
Message
From
26/04/2000 15:52:28
 
 
To
26/04/2000 13:49:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00363680
Message ID:
00363754
Views:
27
>I would like to know the best way to verify if data inserted into a client/server table was committed. I establish a connection and verify the connection. Then, I intert data into the table. This all work fine, I just need to verify the insert.
>
>Thanks, Chris

Select @@ROWCOUNT on the same connection you did your insert. If it returns a number equal to the rows you expected your insert worked.

SQLExec just returning an OK, doesn't mean the Update actually modified any rows, it just means there were no syntax or comunication errors.

BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform