ERR 91 Object variable or With block variable not set with RPG2SQL - Support

ERR 91 Object variable or With block variable not set with RPG2SQL

From Support

Jump to: navigation, search
If you have a question or seek clarification, please call Technical Support.

Problem:

User is trying to do a SQL_MoveFirsBuf(SQL_Socket) after running an SQL SELECT query but gets the following error in the debug window on the RPG2SQL Integrator PC component:

ERR 91 Object variable or With block variable not set

Solution:

Make sure they are using the SQL_RunSQLSel command with the SQL SELECT statement and not the SQL_RunSQLExec command. The SQL_RunSQLExec does not return a recordset. If the SQL_RunSQLExec is used with a SELECT statement, when you try to move to the first record in the recordset you will get the error 91.

Personal tools