Subject Re: [IBO] 'Error creating cursor handle'
Author Jason Wharton
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

----- Original Message -----
From: "Bob Jones" <bjones@...>
To: <>
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;