I have a code where i need to update the main table using on.main.table.
The code is working for the fact that sometimes on finding a record, i get a bshell message saying undefined sql id. Baan doesn't have pertinent documentation for the same. I think this is a problem with sql parsing or something. Can somebody enlighten me further? (I am working on Baan IV c4)

I doubt that documantation exists that would pin-point this problem. By the sound of it there is a problem with starting/restarting the query.

Are errors being reported in log.ora or log.oracle

Suggest you post some of the code to provide more clues.

Terry

Hi Akshay,

Do u use db.bind function to bind the main table and then update the table with bound table pointer.

Also check if the variable used in parsing the query is modified in some include/function/dll by any chance.