Runtime Err while fetching records based on Cursor.

[Former Member]

Hi,

I have used cursor to fetch records. It is working fine if used alone but if i do other operations, it is giving me a dump.

Issue:

Open Cursor is defined.

Fetch Cursor is used to fetch data - 500 records in a go.

Additional Ops.

Create Variants using RS_CREATE_VARIANT.

Use BP_JOB_CREATE to create jobs and close it using JOB_CLOSE.

When i have to do this additional ops., something happens to the cursor and i get this error - DBIF_RSQL_INVALID_CURSOR.

Is there anything that I'm missing in the process.

Thank you.

[former_member182670]

What are you doing in the 'Additional Ops.'?

Any commits or rollbacks there?

Cursor is closed on database commit or a database rollback an these happen implicitly eg. when completing dialog step, calling function module , ....