General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Holden,
What OS on the workstations?
What OS for the file serving machine?
How many workstations active at one time?
What else runs at the same time on the machine serving the files?
What about the network itself... cabling?... collisions?
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only