- Steve Mason
- PowerServer Mobile (Obsolete)
- Friday, 10 August 2018 12:58 AM UTC
I am using PB 2017 R2 and SQL Server 2017. The following test code works when running on a desktop. When running on a mobile device (iPad) I get error "The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION."
---------------------------------
string ls_sql
ls_sql = 'begin transaction'
execute immediate :ls_sql using sqlca;
if sqlca.SQLCode 0 then
messagebox('Begin Error', sqlca.sqlerrtext)
end if
update test1 set fmt = 3 where id = 1 using sqlca;
if sqlca.SQLCode 0 then
messagebox('Update Error', sqlca.sqlerrtext)
end if
ls_sql = 'commit transaction'
execute immediate :ls_sql using sqlca;
if sqlca.SQLCode 0 then
messagebox('Commit Error', sqlca.sqlerrtext)
end if
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.