Error creating cursor handle, in a Local SQL statement

Renzo Contarini

Delphi Developer

Sun, 28 May 2000 03:00:00 GMT

Error creating cursor handle, in a Local SQL statement

Hi, I use D3 with Local SQL. I tried the following statement, but D3
return an error "Error creating cursor handle".

---------------------------------------------------------
UPDATE 'C:\WORK\MYTABLE.db'
SET Price1=10000
WHERE Tipo=3
---------------------------------------------------------
What have I wrong?

Thanks in advance.
Renzo Contarini

--
SIERRA INFORMATICA
P.TTA OTTOBONI, 9
33170 PORDENONE - ITALY
Mr. Renzo Contarini

WEB: http://www.sierrasoft.com
E-Mail: rco...@sierrasoft.com

Brad Mille

Delphi Developer

Sun, 28 May 2000 03:00:00 GMT

Re:Error creating cursor handle, in a Local SQL statement

use Query.ExecSQL instead of Query.Open or Query.Active. You will get the
error anytime you have a query that doesn't return a result set and you try
to open it.

Other Threads

1. Multi-statement query (error creating cursor handle)

2. Error creating cursor handle with an INSERT SQL query

3. SQL: "Error creating cursor handle"

4. SQL problem (error creating cursor handle)

5. error creating cursor handling for TQuery component with Insert SQL command

6. ENoResultSet error message with error creating cursor handle

7. ERROR : 'error creating cursor handle'

8. Error Creating Cursor Handle Error!

9. SQL 6.5, TStoredProc - cannot create cursor handle

10. General SQL Error -- The cursor or statement is not available