Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record in Tables missing after closing the program
Message
From
19/01/2005 03:06:20
 
 
To
19/01/2005 02:48:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00978426
Message ID:
00978432
Views:
12
>Hii,
>I'm working with Sales Order Application which are using Free Tables SO.dbf in multy user environment. The problem occurs when more than 2 user append the table. At First all the records appended are visible to the program, but after the program closed some of them are dissapeare.
>
>This is my save procedure.
>
>
>Sele SO
>FLock()
>if MNew  && Flag for New Data
>   Appe Blank
>   Repl NSO with Thisform.TxtNSO.Value
>endif
>TableUpdate(.T.)
>Flush
>Unlock All
>
>
>Thanks

for the second FLOCK() can fail .
SELEC SO
IF FLOCK()
...
ELSE
   ** retry, wait, message, something
ENDIF
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform