Unix Technical Forum

Can not open resultset

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 ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 08:34 AM
Rob
 
Posts: n/a
Default Can not open resultset

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


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 08:34 AM
onedbguru@firstdbasource.com
 
Posts: n/a
Default Re: Can not open resultset

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...

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:45 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com