Topic: [MSSQL 2005 Express Edition] Passing away record.
|
|
prokicki
User
Fresh Boarder
| Posts: 3 |   |
Karma: 0
|
|
[MSSQL 2005 Express Edition] Passing away record.
|
|
Posted: 2007/07/04 05:42 |
|
|
|
|
Hi
I have changed version AnyDAc on new. I own setups:
AdConnection:
LockMode: Relly
LockPoint: Deffered
LockWait: false
Records are written down. Unfortunately, does not have blockade.
When i changes setups on
LockMode: Pessimistic
LockPoint: Deffered
LockWait: false
Records are blocked. But they do not write down.
I do not use cached updates. (false)
It acted before change of library well. A teraz dupa 
P.
ps
I apologize for my english, but I use translator translate.pl
|
|
Diman
Admin
Admin
| Posts: 1496 | |
Karma: 19
|
|
Re:[MSSQL 2005 Express Edition] Passing away record.
|
|
Posted: 2007/07/04 23:23 |
|
|
|
|
Hello
What means:
But they do not write down.
1) Changes are not posted to DB ?
2) Changes posted to DB are not visible for other sessions ?
3) what else ?
Regards,
Dmitry
|
|
prokicki
User
Fresh Boarder
| Posts: 3 | |
Karma: 0
|
|
Re:[MSSQL 2005 Express Edition] Passing away recor
|
|
Posted: 2007/07/05 04:01 |
|
|
|
|
2) Changes posted to DB are not visible for other sessions
Record does not write down to database physically. It is visible only during session, which it has been written down.
Post edited by: prokicki, at: 2007/07/05 05:14
|
|
Diman
Admin
Admin
| Posts: 1496 | |
Karma: 19
|
|
Re:[MSSQL 2005 Express Edition] Passing away recor
|
|
Posted: 2007/07/05 05:19 |
|
|
|
|
Hello
That means, that your application has constantly active transaction. Check ADConnection.InTransaction before editing and after posting changes to DB. That can give you idea, what is going wrong.
Regards,
Dmitry
|
|
prokicki
User
Fresh Boarder
| Posts: 3 | |
Karma: 0
|
|
Re:[MSSQL 2005 Express Edition] Passing away recor
|
|
Posted: 2007/07/05 06:15 |
|
|
|
|
yes yes yes , problem solved.
If Lock mode = ImRelly then
before insert and after post connection is not in transaction,
if Lock mode = ImPessimistic then
after post connection is in transaction.
When i write afer post
if ADConnection1.InTransaction then
AdConnection1.Commit;
then is ok.
P.
ps
Where is AnyDAc for Kylix? I am next person, who asks about it.
|
|
|
