>Does anyone have a quick method to test a connection handle? I have looked thru the help for SQLGETPROP() and that feature is significantly missing.
>
>The only thing that comes to mind is to test for the error message in an error-handler, but if you have a better suggestion, I'd be much obliged if you'd share it.
>
>Cheers -

What do mean by test? See if it actually retrieves data? If you are still connected?

There are several SQLGetProp() parameters you can test for. One of which is DispWarnings where you could use SQLSetProp to turn off the display of error messages. You can use AErrors() function to test if an ODBC error was returned.

See the VFP help for parameters on these functions. SQLSetProp has the parameters list for the SQLGetProp function.