Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data not being written to the table
Message
 
To
14/09/2006 13:54:53
Jeff Mckay
Utah Department of Health
Salt Lake City, Utah, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Novell 5.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153779
Message ID:
01153801
Views:
15
I don't recommend using file lock flock() as this will prevent others from modifying the table while one user is adding a record. Additionally, if one user has a single record locked for modification the file lock will fail.

Instead use a header lock:
LOCK('0','mytable')

Secondly, I personally have had intermittent problems with append blank then replace. I think its much better practice to use SQL - Insert:
insert into mytable (pk,field1,field2) values (lnNewPK,lcField1,lcField2)

Just my 2cents.
Brandon Harker
Sebae Data Solutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform