Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to trap connection errors
Message
 
 
To
01/09/1998 15:53:32
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00132046
Message ID:
00132295
Views:
13
>I would like to trap connection errors myself instead of presenting users with the system dialog box that quotes the error message and provides OK, Revert, and Help buttons. But I can't seem to get rid of it. Here's the setup:
>
>SQL Server table has a unique index on one field. VFP app uses a remote updateable view of this table (created in code, not in a .dbc). dispWarnings for the connection is set to false. If user enters a duplicate value in the grid and changes rows, the system dialog box fires. I would think that I could use tableupdate() and aerror() in the beforeRowColChange event to handle the error myself, but the dialog box beats me to the punch every time.
>
>Is there any way to suppress that dialog box?

There is a parameter in the SQLSetProp() function to turn off the display of connection errors. Then use aErrors() to see what the last error, if any, was.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform