🚀 go-pugleaf

>I tried putting in a delay loop (with a Sleep() call in the middle) that
waited for the field count to not be equal to 0, but it runs forever.

Do you have Application->ProcessMessages() in loop?

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server and MS Jet (MS Access) databases.


"Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> ???????/???????? ?
???????? ?????????:
news:gunaalqrneguyvaxarg.h56o2w1.pminews@207.105.83.65...
> I'm attempting to make result counting optional in my program, so that the
> initial results of a search are accessible to be examined while the query
> completes in the background (by ADO, not on a separate thread of my app).
>
> The program already lets the user choose a server or client cursor, with a
> cancel box with the latter so long searches can be aborted (even though
ADO
> will block on the Recordset->Cancel() call if the search involves a sorted
> result set).
>
> After the search, I have a routine which goes through the result set and
sets
> field format information, as well as a few OnGetText handlers to display
some
> fields in human-readable format.
>
> With a server cursor, this routine works fine.  With a client cursor, it
does
> nothing, because the reported field count is 0, and it has no fields to
loop
> through.
>
> I tried putting in a delay loop (with a Sleep() call in the middle) that
> waited for the field count to not be equal to 0, but it runs forever.
>
> With a check of the RecordCount property, however, everything works with a
> client cursor.
>
> So, what can I do to get a field count without checking the record count
with
> a client cursor?
>
>
> --
>  - Mike
>
> Remove 'spambegone.net' and reverse to send e-mail.
>
>