General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Well for that amount of data you may not see any performance benefits at all. So it will be back to security and integrity benefits for you.
>
>You don't need to lock data rows in SQL as such, because it is geared towards set-based updates. In other words, you don't really pull a server-side cursor very often, and then loop through it. Some purists would say you never do that, but in reality you do have to sometimes, especially when you want to execute a remote stored procedure on each row or a few data items from it.
>
>Can you give us any examples of code that you're trying to write then we can try and move you forward.
>
>Regards
>Simon
Many thanks Simon,
my biggest problem is ;
if a client edits an invoice and an other client trys to delete the same invoice at the same time?
At the bottom ; this code sample writes my invoice.Harview is the remote view with buffermode 5.
llhata = .F.
Begin Transaction
llUpdate = Tableupdate(.T., .F., "HARVIEW" )
If !llUpdate
Messagebox("Dont Saved")
llhata = .T.
Endif
If llhata
Rollback
=Tablerevert(.T., "HARVIEW")
Else
End Transaction
Endif
Previous
Next
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