Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RollBack transaction doesn't work
Message
De
24/11/2009 13:01:38
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01436291
Message ID:
01436406
Vues:
49
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform