Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Clipper Visual-Objects > AdoServer - Opt...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 11298 of 11512
Post > Topic >>

AdoServer - Optimistic concurrency ckeck failed

by Paulo Oliveira <paulo@[EMAIL PROTECTED] > Apr 9, 2008 at 04:07 AM

Hil all,

How can i solve this problem:

2 users updating a record in Sqlserver at same time:

Adoserver generate the error:
Error code: Optimistic concurrency check failed. The row was modified
outside of this cursor.....

I use adLockOptimistic.

the error is on oSrv:Commit()

this is my Init() code:
METHOD INIT(oClasse) CLASS ClipAdoServer
	LOCAL cTxtQuery AS STRING

	cTxtQuery:="select * from "+AllTrim(oClasse:cTabela);
		+" where "+
SELF:ListaCondicoes(oClasse:GetChaves(),oClasse:GetValChaves())

	SUPER:INit(cTxtQuery,POGetAppObject():oConexaoAdo,adOpenKeyset,
adLockOptimistic,adCmdText)

TIA
Paulo Oliveira
 




 2 Posts in Topic:
AdoServer - Optimistic concurrency ckeck failed
Paulo Oliveira <paulo@  2008-04-09 04:07:01 
Re: AdoServer - Optimistic concurrency ckeck failed
"Geoff Schaller"  2008-04-09 22:17:05 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Jul 9 2:00:42 CDT 2008.