Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Preventing new records from being added to a table
Message
From
06/12/2006 03:12:24
 
 
To
05/12/2006 12:54:44
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01174981
Message ID:
01175126
Views:
8
>Hi all,
>
>Please excuse what's surely a very basic question, but I've been reading about buffering, tableupdate(), tablerevert(), etc., but am not finding an answer to this one.
>
>Using VFP 9, I have a simple data entry form with BufferMode=2 (Optimistic). In the properties for the table that I'm editing with the form, I've got BufferModeOverride=1 (Use Form Setting).
>
>Two of the buttons on my form are ADD and EDIT. If my user choses EDIT, I can easily use TABLEUPDATE or TABLEREVERT to either save or ignore the changes. No problems there. But when my user chooses ADD, I'm doing an APPEND BLANK to give them a blank record to work with. If they wanna save those changes, again, no problem with TABLEUPDATE if they click my SAVE button. But what if they change their mind about adding that record? How do I prevent that blank record from being added to the table if they click my IGNORE button? I don't want my table to have blank records in it.
>
>Thanks very much!
>
>John

John,
You should read A Guide to Buffering and Transactions in VFP by Andy Kramek. You could find that article here:
http://www.tightlinecomputers.com/Downloads.htm

BTW there are many great articles there.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform