Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append Blank vs. Insert - SQL
Message
From
14/01/2000 13:21:39
 
 
To
14/01/2000 09:53:40
Dave Emerson
Dc Emerson Consult8Ng, Inc
Destin, Florida, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00318136
Message ID:
00318230
Views:
37
>I am trying to avoid the "deadly embrace" syndrome with a shared network table. The documentation states that both APPEND BLANK and INSERT - SQL lock the table header and recommends using APPEND BLANK to avoid conflict, but I have thought that INSERT was the better method, however yesterday we had that dreaded conflict.
>

Deadly embrace? This is when two processes are waiting for one another two finish before continuing- how could you do this with VFP?

SET REPROCESS TO AUTOMATIC has always done it for me- I have never had a problem. I use both INSERT INTO and APPEND BLANK depending on the situation, and have not been bitten with either one.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform