When using SSQL, does Rbase continue processing the next line immediately or does it wait for a returned status from ODBC driver?

SSQL Update tableX set ColX = 'P' where ColX = 'A'

Insert into tableB ... select * from tableX where ColX = 'P'

It appears that the second line executes and finishes before the first line completes. I.E. Not all lines of data are inserted that I expect.

If I count the number of records of ColX = A, I get 200. But only 180 might get inserted.

I need to know how SSQL works in this type of scenario.

Thanks,

Bob

Sent from my IPOD

Reply via email to