Subject | SQLDA error not in a Stored Proc |
---|---|
Author | Roger Webb |
Post date | 2001-01-08T18:49:53Z |
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
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