Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checking some field for uniqueness
Message
From
12/06/2001 16:23:00
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00518556
Message ID:
00518589
Views:
10
This message has been marked as a message which has helped to the initial question of the thread.
>We have the similar code in our classes, but I realized, it is not sufficient, since it doesn't check for buffered changes.

Nadya,

If you do a seek() or COUNT in the same table (i.e., without re-opening it), you run the risk of getting error messages, caused by the fact that validation is carried out before you actually want to save the record.

The philosophy I apply is to check for changes only when the user tries to save changes. This has several advantages, specifically, you wouldn't need to worry about buffered changes.

However, I realize that if you want to check for changes earlier this solution may not be perfect.

Regards, 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
Next
Reply
Map
View

Click here to load this message in the networking platform