General information
Category:
Forms & Form designer
Title:
Preventing new records from being added to a table
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only