Mensaje
De
05/12/2006 13:01:44
a
05/12/2006 12:54:44
General information
Foro:
Visual FoxPro
Category:
Formularios & Diseñador de formularios
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
ID de la conversación:
01174981
ID del mensaje:
01174984
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
>
>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
TableRevert(.f.,[ALIAS])That way you will revert only the current record.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
The only thing normal about database guys is their tables.