You cannot Open an Update statement because it merely carries out an update
operation, not return records.
You should call ExecSQL to execute the statement.

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

----- Original Message -----
From: "Bob Jones" <bjones@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, September 17, 2001 5:58 AM
Subject: [IBO] 'Error creating cursor handle'


> I'm trying to execute an update query as follows, but get an error: 'Error
> creating cursor handle'. What am I missing?
>
> with IB_Cursor1 do
> begin
> SQL.Clear;
> SQL.Add('Update Immuniz set IM_Name = ''Test'' Where Immuniz_Id = 10');
> Open;
> end;