General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
What does SQLEXEC() return after an UPDATE... command?
I do an UPDATE command using SQLEXEC.
I *know* that the conditions specified (WHERE clause) cannot be matching, yet I seem to be getting a "1" back (updating only 1 record each call). The record is *NOT* being updated, which is what I want, but the return code is telling me to update a list that is shown to the user to indicate records updated.
The Help says:
"Numeric data type.
SQLEXEC( ) returns the number of result sets if there is more than one. SQLEXEC( ) returns 0 if it is still executing and returns 1 when it has finished executing. SQLEXEC( ) returns –1 if a connection level error occurs.
SO what does it return after an UPDATE command? I had guessed that it would return the number of records updated but that is obviously wrong.
Thanks
Jim
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only