Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transaction Question
Message
From
10/01/2002 12:41:45
Joel Leach
Memorial Business Systems, Inc.
Tennessee, United States
 
 
To
10/01/2002 11:48:48
Calvin Smith
Wayne Reaves Computer Systems
Macon, Georgia, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00603026
Message ID:
00603070
Views:
22
>if I have code in the form below
>local lsuccess
>Begin Transaction
>select a table
>lsuccess=tableupdate(.t.,.t.)
>if lsuccess
>lsuccess=tableupdate(.t.,.t.)
>...
>if lsuccess
>End Transaction
>flush
>return 1
>else
>rollback
>flush
>return -1
>endif
>
>Note the -1 return code will generate and error and certain paperwork does not get printed. However, one customer on a peer to peer network working on a workstation printed the paperwork and later found that for a certain period of time about 20 transactions disappeared ( or were never posted) from several tables. Question: what is the VFP mechanism for a return code from tableupdate on a peer to peer network? Thanks.

Hi Calvin,

The network does not have an effect on the return code from TableUpdate. Perhaps index/data corruption is the culprit.
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform