Subject | IB_Query problems |
---|---|
Author | Daniel Jimenez |
Post date | 2004-11-17T23:08:39Z |
Hi,
I have written an application which works perfectly, except in very
particular instance.
The problems is as follows.
I have a IB_Query which uses a Select Procedure to populate a IB_Grid. It
works perfectly (with approximately 21 select procedures), except when I
call a particular Select Procedure (see below the Select procedure in
question).
I have run the procedure from Database Workbench, and I get no errors. Thus,
I am assuming that the Select procedure is error free.
The error given by IBObjects is:
CODE:335544569
ISC ERROR MESSAGE
Dynamic SQL Error
SQL error code = -206
Column unknown
LP_PROCESSNAME
At line, Column 24.
The procedure is:
SET TERM ^^ ;
CREATE PROCEDURE P_LP_SELECT_ALL returns (
LP_PR0CESSNAME VarChar(16),
LP_LOGMASK SmallInt,
LP_LOGPATH VarChar(256),
LP_DAYLIMIT SmallInt)
AS
BEGIN
FOR SELECT
LP_PR0CESSNAME,
LP_LOGMASK,
LP_LOGPATH,
LP_DAYLIMIT
FROM
LOGPARAMS
INTO
:LP_PR0CESSNAME,
:LP_LOGMASK,
:LP_LOGPATH,
:LP_DAYLIMIT
DO
BEGIN
SUSPEND;
END
END
^^
SET TERM ; ^^
The Code is as follows:
....
CheckDBConnection();
AQuery->SQL->Add("SELECT * FROM P_LP_SELECT_ALL");
if( !AQuery->Prepared )
AQuery->Prepare();
AQuery->Execute();
Any help, suggestions, criticism, humour would be welcome at this stage
Thank you
danieL.
____________________________
Comvision Pty. Ltd.
www.comvision.net.au
I have written an application which works perfectly, except in very
particular instance.
The problems is as follows.
I have a IB_Query which uses a Select Procedure to populate a IB_Grid. It
works perfectly (with approximately 21 select procedures), except when I
call a particular Select Procedure (see below the Select procedure in
question).
I have run the procedure from Database Workbench, and I get no errors. Thus,
I am assuming that the Select procedure is error free.
The error given by IBObjects is:
CODE:335544569
ISC ERROR MESSAGE
Dynamic SQL Error
SQL error code = -206
Column unknown
LP_PROCESSNAME
At line, Column 24.
The procedure is:
SET TERM ^^ ;
CREATE PROCEDURE P_LP_SELECT_ALL returns (
LP_PR0CESSNAME VarChar(16),
LP_LOGMASK SmallInt,
LP_LOGPATH VarChar(256),
LP_DAYLIMIT SmallInt)
AS
BEGIN
FOR SELECT
LP_PR0CESSNAME,
LP_LOGMASK,
LP_LOGPATH,
LP_DAYLIMIT
FROM
LOGPARAMS
INTO
:LP_PR0CESSNAME,
:LP_LOGMASK,
:LP_LOGPATH,
:LP_DAYLIMIT
DO
BEGIN
SUSPEND;
END
END
^^
SET TERM ; ^^
The Code is as follows:
....
CheckDBConnection();
AQuery->SQL->Add("SELECT * FROM P_LP_SELECT_ALL");
if( !AQuery->Prepared )
AQuery->Prepare();
AQuery->Execute();
Any help, suggestions, criticism, humour would be welcome at this stage
Thank you
danieL.
____________________________
Comvision Pty. Ltd.
www.comvision.net.au