IScript, SQLExec, CommitWork and RemoteCall
I am using IScript (FieldFormula) for executing the logic to calculate payment details before connecting to 3rd party payment center and display the details.
For each time before connecting to 3rd party payment center, IScript (FieldFormula) logic is using delivered application package and methods to delete and insert variables into Staging record using SQLExec then other method will use the parameters from staging record and execute RemoteCall a COBOL program.
However I stuck with message "Think-time PeopleCode event (RemoteCall), but a SQL update has occurred in the commit interval. (2,148)" or "Think-time PepleCode event () invoked while a cursor is busy is illegal (2,149)" and unable to proceed further. I do understand it is because of uncommitted data so I've tried CommitWork() and SQLExec("COMMIT") before calling execute method for RemoteCall but it didn't helped.