Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Preventing new records from being added to a table
Message
De
05/12/2006 17:19:23
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
05/12/2006 12:54:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01174981
Message ID:
01175050
Vues:
10
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform