WonderWare SQLErrorMsg function question

[jkennlaw]

Need help trying to resolve a problem with using the SQLErrorMsg function. I use SQLSelect to query a MSAccess list to search for a product code and the data associated with it. I want to generate an alarm if no code is found. When trying to use Error message function I only get a 0 (no errors occurred) result code. I would think that I should be getting a -5 (no more rows to fetch) result code. All data comes thru correctly when a product code is found and nothing comes thru when a product code is not found. This should generate an error, but does not. Have to tried to rewrite script in several different ways without success.

 

[jshiepe]

Please post your script. It may be something as simple as adding the following statement after your select:

ResultCode = SQLFirst(ConnectionID);

Can't tell for sure until I see your script.

 

[jkennlaw]

Thanks for the tip.
It was as simple as that.
Why does WW not show that in any of their help files on the subject? Been driving me crazy. Thanks again!

 

[jshiepe]

I know it's not very intuitive. The result code for the SQLSelect has nothing to do with how many rows were returned, only if the select was successful, i.e. if it was able to query based on the bind list, criteria, etc.. Results are returned to a "pivot table" in memory, and you have to use the SQLFirst statement to move the pointer to the top of the list. If there is nothing in the list, you will get your desired return value.

Glad it was a simple fix. I like those.