Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A NICE message when Primary Key is violated
Message
From
07/05/2001 02:26:35
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00503380
Message ID:
00504078
Views:
23
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

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,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform