I'm not quite sure what more to give ya with out sending ya the whole
program.. hehe (which I'll do if you really want to.. its not to big yet...
hehe.

Anyway.. I'm on 3.4.Ch and the program is running on a WinNT box as a CGIExe
app with IB6. I have noticed today howeve, that it is only on queries that
set parameters prior to the OPEN. As well, it happens on the Open... not on
the Parambyname Line.. I alos have a query that does an insert and It does
it on the post after setting the fields. The queries that do not require a
parameter open just fine and work just fine.

What other kind of information do you need?

-----Original Message-----
From: Jason Wharton [mailto:jwharton@...]
Sent: Monday, January 08, 2001 14:58
To: IBObjects@egroups.com
Subject: Re: [IBO] SQLDA error not in a Stored Proc


Need more informations.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Roger Webb" <RWebb@...>
To: "Ibo-List (E-mail)" <ibobjects@egroups.com>
Sent: Monday, January 08, 2001 11:49 AM
Subject: [IBO] SQLDA error not in a Stored Proc


> I've got an IB_Query that looks like this...
>
> The SQL is 'Select * from Items where Item_ID = :ItemId'
>
> The Code :
>
> try
> ibqList.ParamByName( 'ItemID' ).AsInteger := 7;
> ibqList.Open;
> ibqList.Close;
> Except
> on E:Exception do
> BuildString := E.Message;
> end;
>
> Buildstring ends up containing this info :
> Dynamic SQL Error SQL error code = -804 Incorrect values within SQLDA
> structure
>
> Any ideas... am I missing any info that would help?
>
> - Roger