I'm setting up an application that uses a VFP7 front-end and an MS SQL Server backend. I've worked out most of the details in how to update, insert, delete, and select data from tables in the MS SQL tables and I'm happy with the results. However, I want to be able to set up an alternate VFP data source that mirrors the MS SQL data source and be able to run the same application against VFP data using SPT. When I try it I get results I'd not counted on. When I went under the hood and started checking things out I was surprised to find that my SQL UPDATE command would execute but not return a valid error code even if no records were found matching the WHERE clause's values. The SQLEXEC() command would return a 1 and the AERROR() function returned nothing. The _TALLY variable was 1, even though no rows were updated. My question is this: How do you detect data exceptions using SPT going against VFP tables? MS SQL Server returns error messages that I can test for and trap. VFP doesn't seem to do the same thing. What gives?
Any help would be greatly appreciated.
Jim White
Time is a wonderful teacher. Unfortunately it kills all of its students.