Error creating cursor handler

[jbpelletier]

What can cause that :

Error Message Showing "Error Creating cursor handler"
when trying to activate (active = true) my Tquery
(Query1).

My SQL statement is
UPDATE TbKeys SET qte = qte -1
WHERE qte >0

and correctlty working if i execute it passing by Access
.. All others Query (Select, Insert) are working and if
i replace the sql statement of a working query by my
update query, it dont work and give me the create cursor
error again.


jb

 

[LucieLastic]

Could it be that you have RequestLive set to true and it (maybe) should be false? I'm guessing here, sorry.

 

[jbpelletier]

na.. thats because i was using Query1.Active:=true; instead of Query1.execsql;

in fact for: delete, insert and update queries u need to use execsql; and for queries that return a result as a SELECT u need to use active:=true;

jb