Can not open resultset

[Rob]

Dear all,
could someone help me in such problem:
in a loop a make a lot of (ca.1500) inserts to table1. I the some time I
make select query on another table and sometimes (not allways) during this
query I get an error: " Can not open resultset". How it is possible ? This
program is written in Delphi with components Zeos.
best regards
Rob

[onedbguru@firstdbasource.com]

what language are you using - SQL or PHP or ... or ...

Your system apparently does not have the memory resources or the table
you are querying is locked at the time of the query...

commit often.

It is possible because you are using brain-dead wysiwyg tools...

[ramiro]

This is an old post but could be usefull for others,
if you have acces to the source code, compile once again, but first check it:

Probable a SQL query is done but the query (TzQuery )used for it is disabled at design time. But at runtime is enabled, the component tries to get a result, here the error appeards.

Comment it and try again

datos.DataModule1.radios.SQL.Text:='INSERT INTO transacciones( dni_receptor) values(''ABC'')';
//Tzquery1.Active:=true;
datos.DataModule1.sql_gen.ExecSQL;
for doing the query is not required that query is active.

www.cromosoft.com