Use of SQLSTATE

[mud2]

Can someone give me a "Concrete" example of the use of SQLSTATE? It looks like this is a way of checking if a query has/hasn't worked.
Thanks!

Also, which ADO is necessary?

[SydneyGeek]

SQLSTATE lets you determine which error has happened. In ADO, the SQLSTATE property is a 5-character string.
This article shows an ASP example -- http://www.w3schools.com/ado/prop_err_sqlstate.asp

Denis

[mud2]

Thanks...The reference, excuse me, is a typical Microsift answer....Telling the user nothing!
I've tried, but do not want to wade through all the background necessary.
All I wanted was a way of indicating if a QUERY had run successfully, and had returned a value.
I'll go back to my messy work around: Insert the results of the query into an empty table and then look at the number of records in that table.
Oh well, what can one expect when diddling with SQL?

[mud2]

The use of SQLSTATE requires ADO. This opens a whole new universe which pain-lovers will delight in!

[SydneyGeek]

If you want to ensure that a query has run (presumably an action query like APPEND, UPDATE, or DELETE) you can wrap the call to the query in BeginTrans and CommitTrans statements.
It won't commit unless all records can be modified. Presumably you could trap for that, or write code to let you know that it committed successfully.

Denis