This is a discussion on Can not open resultset within the MySQL forums, part of the Database Server Software category; --> Dear all, could someone help me in such problem: in a loop a make a lot of (ca.1500) inserts ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| ||||
| 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... |