begintrans, commit and rollback
-
hi, im doing a app on vb6 and i have a doubt about the transaction. how can i know if the transaction is "open" or not. thanks, Marcus
mabrahao wrote:
app on vb6
VB6 is dead.
mabrahao wrote:
how can i know if the transaction is "open" or not.
As much as i can remember (asuming that you are using ADODB) the only way to use a variable. After opening the transaction make it true and after commit or rollback make it false.
-
hi, im doing a app on vb6 and i have a doubt about the transaction. how can i know if the transaction is "open" or not. thanks, Marcus
If you opened one, it's open (until commit or rollback is called). If you didn't open it, you probably won't be able to close it anyway. If I need a transaction, I tend to start it when the connection opens, and commit or rollback just before I close the connection again.
I are Troll :suss:
-
mabrahao wrote:
app on vb6
VB6 is dead.
mabrahao wrote:
how can i know if the transaction is "open" or not.
As much as i can remember (asuming that you are using ADODB) the only way to use a variable. After opening the transaction make it true and after commit or rollback make it false.
-
hi, im doing a app on vb6 and i have a doubt about the transaction. how can i know if the transaction is "open" or not. thanks, Marcus
If you are using MS-SQL, this might help you determine how many transactions are running ... select @@TranCount AS TransactionCount
-
mabrahao wrote:
app on vb6
VB6 is dead.
mabrahao wrote:
how can i know if the transaction is "open" or not.
As much as i can remember (asuming that you are using ADODB) the only way to use a variable. After opening the transaction make it true and after commit or rollback make it false.
Goutam Patra wrote:
VB6 is dead.
More accurate to say that it is undead: Microsoft hasn't supported it in years, but many companies are too (censored) cheap to buy upgraded software, or have solutions developed in-house that "work fine, so why bother going through the cost and hassle of rewriting it in a new language?" Like COBOL and RPG, VB6 (and earlier) will be around until the last corporate manager is mouldering in his grave.
-
Goutam Patra wrote:
VB6 is dead
Is that your answer if a customer asks whether you can change his/her code? :)
I are Troll :suss:
Well that was not my intention. Yes, some of my clients are still using good old VB6 application. And I told them I will not be able to give any more functionality in this application platform, I can give you support up to some minor changes. I think there is no point of doing any further development on VB6. And that’s why I said so. And I also I gave OP the some solution also. I just didn’t reply OP to say that.
-
Well that was not my intention. Yes, some of my clients are still using good old VB6 application. And I told them I will not be able to give any more functionality in this application platform, I can give you support up to some minor changes. I think there is no point of doing any further development on VB6. And that’s why I said so. And I also I gave OP the some solution also. I just didn’t reply OP to say that.
Goutam Patra wrote:
I think there is no point of doing any further development on VB6.
They can't not do .., because of client requirement., some client are still using windows98 with low and configuration systems which are not supported by .Net environment., they don't want to invest/upgrade their systems. In this case there is no chance for Programmers :( :( :(
Rajesh B --> A Simple Programmer <--
-
Goutam Patra wrote:
I think there is no point of doing any further development on VB6.
They can't not do .., because of client requirement., some client are still using windows98 with low and configuration systems which are not supported by .Net environment., they don't want to invest/upgrade their systems. In this case there is no chance for Programmers :( :( :(
Rajesh B --> A Simple Programmer <--
Rajesh Puli wrote:
In this case there is no chance for Programmers
I agree
-
hi, im doing a app on vb6 and i have a doubt about the transaction. how can i know if the transaction is "open" or not. thanks, Marcus
You can check if <>.State equals 'adStateOpen' constant.