Re: "Query cannot be closed in the current state"- A strange run time error while using OPENapi

#1

P.S

The above occurs at the following configuration - as propted by Ingres:

INGRES TERMINAL MONITOR Copyright (c) 1981, 2000 Computer Associates Intl,
Inc.
Ingres SPARC SOLARIS Version II 2.5/0011 (su4.us5/00) login

Hillel.

"Hillel Eilat" <hillel (AT) attunity (DOT) co.il> wrote

Quote:

Hello Everybody

My application uses OPENapi interface to interact with OpenIngres.

First it does some internal settings and connects, involving following
calls:

IIapi_initialize: initParm=FCB85250
IIapi_connect: connectParm=FCB93B58
.
.
and some

IIapi_query: query=FCB7FF0C
IIapi_setDescriptor: setDescrParm=FCB7FF0C
IIapi_putParms: putParmParm=FCB7FF0C
IIapi_getDescriptor: getDescrParm=FCB7FF0C
IIapi_wait: waitParm=FCB7FF0C
.
.
Followed by some:

IIapi_getColumns: getColParm=FCB7FF0C
IIapi_wait: waitParm=FCB7FF0C
IIapi_close: closeParm=FCB7FF0C
.
.
Now it attempts to do a simple query: SELECT * FROM
INGRES.HS_TRANSACTION_LOG

IIapi_query: query=FCB7FF0C
IIapi_getDescriptor: getDescrParm=FCB7FF0C
IIapi_wait: waitParm=FCB7FF0C
IIapi_close: closeParm=FCB7FF0C
IIapi_getErrorInfo: getEInfoParm=5D2898
.
.
and fails due to the following error:

XXXXXX>> : ERROR '5000R' 13172743: Query cannot be closed in the current
state, it may only be cancelled.

Does anybody have any idea what is this message and where does it come
from?

Thanx + Regards

Hillel.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: "Query cannot be closed in the current state"- A strange run time error while using OPENapi

comp.databases.ingres comp.databases.ingres

Re: "Query cannot be closed in the current state"- A strange run time error while using OPENapi - 03-10-2005 , 11:35 AM