Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tableupdate() question.
Message
From
06/12/2002 23:00:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Tableupdate() question.
Miscellaneous
Thread ID:
00730577
Message ID:
00730577
Views:
53
Hi to all!

i am using table buffering enabled with my free tables. the following
are my basic code :

*Form Load() event
set multilocks on
=cursorsetprop("buffering",5,"salesHdr")
=cursorsetprop("buffering",5,"salesDtl")

*Save Button-Click()
SELECT SalesHdr
DO WHILE .T.
IF TABLEUPDATE(.T.)
EXIT
ELSE
messagebox("Error in updating table" , MSGOK_LOC)
ENDIF
ENDDO
WAIT CLEAR
SELECT SalesDtl
DO WHILE .T.
IF TABLEUPDATE(.T.)
EXIT
ELSE
messagebox("Error in updating table" , MSGOK_LOC)
ENDIF
ENDDO
WAIT CLEAR
**

My question :
Why sometimes tableupdate could not commit successfully? especially in the network environment?i already did all the possibility to make the network in safe. like i issue RLOCK and UNLOCK before issuing REPLACE or any other command that need to lock a record when it issued.What are the lists of the possibility why the tableupdate(.T.) could not commit successfully?


Hope someone can help my greatest problem.

holden
Next
Reply
Map
View

Click here to load this message in the networking platform