Trapping ODBC Errors

[finsys]

I'm struggling with error handling on a VFP7/SQL2k project. I've managed to trap errors with AERROR(), e.g. if the primary key uniqueness is violated, return a readable message for the user, but after my custom message appears and is cleared, the VFP ODBC 1526 message still pops up. How do I stop it appearing??

 

[jjgraf]

SQLsetprop(ConnectionHandle,'DISPWARNINGS', .f.)

this should take care of that problem

 

[finsys]

Yup, that looks like it should work.. but it doesn't!! I set it is the default for all connections (using nHandle as 0), but it's not having any effect