Server failed to resume the transaction, desc: 3300000003.
Posted: Mon 13 Jun 2016 13:30
Hi Guys
Im getting an error "Server failed to resume the transaction, desc: 3300000003." on the ANDROID app (firemonkey; delphi seattle; sdac 7.3.12) when posting a transaction in a method for sql server 2012 and 2014
(no error for msde2000 and no error in win32 firemonkey however.)
btnSaveClick:
TRY
conn.starttransaction //conn is a TMSConnection connection with Tmsquery datasets
for i = 1 to x do
begin
if dataset.locate(??) then : dataset.edit; ... populate fields .... dataset.post; else Message;
conn.execsql('some update statement')
end
conn.commit
EXCEPT
conn.rollback
END
Im getting an error "Server failed to resume the transaction, desc: 3300000003." on the ANDROID app (firemonkey; delphi seattle; sdac 7.3.12) when posting a transaction in a method for sql server 2012 and 2014
(no error for msde2000 and no error in win32 firemonkey however.)
btnSaveClick:
TRY
conn.starttransaction //conn is a TMSConnection connection with Tmsquery datasets
for i = 1 to x do
begin
if dataset.locate(??) then : dataset.edit; ... populate fields .... dataset.post; else Message;
conn.execsql('some update statement')
end
conn.commit
EXCEPT
conn.rollback
END