Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Preventing new records from being added to a table
Message
From
05/12/2006 17:19:23
Mike Yearwood
Toronto, Ontario, Canada
 
 
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:
01175050
Views:
9
Hi 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.

Very simple. Use a single powerful approach instead of a limited one. IOW use Table Buffering instead of Row Buffering.

Row Buffering saves the changes as soon as the record pointer moves. Everything you can do with Row Buffering you can do with Table Buffering.

If the user clicks ADD, use append blank, that way the added record is in the buffer. To undo it tablerevert. To edit, simple start editing. To undo it table revert. Simple, effective.

BTW, I always set the form's buffermode to 0 - None. When I used tables/views in the data environment, I set the tables I wanted to edit to optimistic table buffering - 5. As a result, I didn't have to do anything to picklists or other non-editable tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform