Connection is busy with results for another hstmt

[Johan L. Botha]

This problem is haunting me, unidrectional is false, and Im not sure what
else it could be ? This happens when I open a query on a keydown event.

[Michael Rodriguez]

This is an odd BDE problem that can be avoided by creating another TSession
and opening the query in question on that new session. The problem occurs
when a query on one session has results open/pending for a table and another
query on the same session tries to query the same table.

--
Michael Rodriguez
Compeat Restaurant Accounting Systems
http://www.compeat.com
mi...@compeat.com

"Johan L. Botha" <johan...@reyrey.com> wrote in message
news:3b37931b$1_2@dnews...

[Johan L. Botha]

Hi Michael

Our design preogative was to get rid of extra database connections, which I
assume is what caused this problem. I have found a low cost workaround for
our situation though. I changed the rowset size to 200, and one can set it
to whatever one needs, which will make it fetch all rows, since with 600,000
lines, I wasnt looking forward to putting fetchall s after each open. :-)
Thank you for you comment, it and a few others I found helped me come up
with the Rowset idea, which I am posting here in the unlikely event that
someone else can use it..

Regards
Johan

"Michael Rodriguez" <mike@yada_yada_yada.compeat.com> wrote in message
news:3b38efe8_1@dnews...