Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A NICE message when Primary Key is violated
Message
 
 
À
07/05/2001 02:26:35
Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00503380
Message ID:
00504189
Vues:
26
>Hi nadya,
>
>>I thing you're wrong. We use TableBuffering, yet we can't issue APPEND BLANK, if one blank record is already in a table. The error message appears immediatelly, before TableUpdate.
>
>When using either table or recordbuffering you can append a blank record as long as you do not move from this record. Try this:
>
>USE MyTableWithBlankRecord
>cursorsetprop("Buffering",3)
>APPEND BLANK
>
Ok, but when I typed BROWSE, it immediatelly gave me an error. All our tables have table buffering (5), I'm not sure about moving back and forth, because AFAIK our framework does form.freshen() all the time, and in this method where are skip/skip-1. May be this causes the problem. I'll try to investigate it.

>It won't error you. Only Until you're trying to leave the record with LOCATE, APPEND BLANK, SKIP, etc or you want to commit the record with TABLEUPDATE() it will generate the errormessage
>
>Walter,
>
>
>>>
>>>In my personal framework, the changes people make in a form are (record or table) buffered. The users can commit or rollback the changes anytime.
>>>
>>>Walter,
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform