jkennlaw
Member
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.