Connection is busy with results for another hstmt - borland.public.delphi.database.sqlservers

Message from discussion Connection is busy with results for another hstmt

Johan L. Botha

View profile

More options Jun 27 2001, 11:17 pm

Newsgroups: borland.public.delphi.database.sqlservers

From: "Johan L. Botha" <johan_bo...@reyrey.com>

Date: Wed, 27 Jun 2001 07:14:54 -0400

Local: Wed, Jun 27 2001 11:14 pm

Subject: Re: Connection is busy with results for another hstmt

  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

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

> 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
> m...@compeat.com

> "Johan L. Botha" <johan_bo...@reyrey.com> wrote in message
> news:3b37931b$1_2@dnews...
> > 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.

Forward