hi bob,

try execSQL instead of open. open is for cursor that return result sets but
your query does not.

HTH

Rob

----- 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;
>
> Thanks.
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>