Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
About delete
Message
From
19/09/2002 20:35:03
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
19/09/2002 20:05:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00702470
Message ID:
00702559
Views:
18
>Thanks for your answer.
>I think I didn't come across properly, what I meant was what kind of errors
>I might run into by issueing this command underm the circumstances I exposed.
>Perhaps I misunderstood you.
>TIA

DELETE can fail for several reasons - the most obvious one being referential integrity.

You should use buffering. Then, the DELETE command, just like any other change to the table, requires a TableUpdate() to confirm the action. This will usually not throw an error message immediately - instead, TableUpdate() may return .T. or .F., depending on whether the change could be confirmed, or not.

If TableUpdate() returns .F., use function aerror() to get the message number and description.

Saludos, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform