Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange behavior with CA...
Message
From
26/03/2003 16:17:41
Peter Wagner
Point Informática Ltda.
Limeira, Brazil
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00770066
Message ID:
00770451
Views:
14
Mark,
Sorry but I dont agree with this at all.

In fact I see this is necessary if VFP generates the code and when we use DML code.
The VFP generated code and most DML code doesnt provide us with a way to know if the
code executed in the server afected an record, those codes are generaly simple Insert/Update/Delete
statements and I like some kind of control about this situation.
If we use SP in the server, the problem can be solved if we test @@Rowcount = 0 in the Stored Procedure, to return an error.
I like to know if the record was afected and if not, I give the user an information about.

Reading the url provide by Jim Nelson, it shows how to handle it when VFP generates the code.

Peter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform