Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RollBack transaction doesn't work
Message
From
24/11/2009 13:01:38
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01436291
Message ID:
01436406
Views:
41
>I don't know if the changes in the other application are necessary. The main question is - from your application are you able to send all your commands at once as one batch or you need to use separate commands?
>
>If that's the case, how can we guarantee that the transaction would persist and apply to only our commands and not the commands send by other applications? I'm not sure about it.
>
>Using one batch will guarantee that all the commands will execute together.

My application insert one record that have type and value
When I insert this record a report to the other application that I make it.
Then, acording the type and value, the other application have to determine the destination of this data. Can send to the company A, B or C.
The company A, B or C have to stay with equivalent type and value.

If my application have:
- 3 records of type "1" and value R$ 100,00 then
- the company A have 1 record of type "1" and value R$ 100,00
- the company B have 1 record of type "1" and value R$ 100,00
- the company C have 1 record of type "1" and value R$ 100,00
the tree company have equivalent type and value

To determine what company have to receive the data, the other application execute many instructions to consult the last situation and save the new situation - this instructions my application don't know, than I do not can use a batch command.

I just say to the other application: "I inserted one record of the type '1' and value R$ 100,00"

something like
objDefiner.define("1", 100.00)

Then I need
myApplication.beginTransaction()
otherApplication.beginTransaction()
insert into my table...
objDefiner.define("1", 100.00) && of other application
if error
  myApplication.rollbackTransaction()
  otherApplication.rollbackTransaction()
else
  myApplication.commitTransaction()
  otherApplication.commitTransaction()
endif
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform