Question about VB and Cursor Location

From: "Corey W(dot) Gibbs" <cgibbs(at)westmarkproducts(dot)com>
To: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Question about VB and Cursor Location
Date: 2002-05-09 14:47:24
Message-ID: 01C1F72D.C2E23C40.cgibbs@westmarkproducts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Good Morning Everyone (or evening as the case may be),

Just a quick question about the cursor location property of an ADO
recordset object.

adUseServer is the default, has anyone ever switched it to adUseClient to
use the .Sort and .Filter methods of the ADO recordset? I am helping
another programmer convert an application that uses Access datafile to PG.
I've always just left it adUseServer and wrote various SQL statements to
fill my recordsets, but he has extensive use of .Sort and .Filter in his
code.

I've checked out some websites and they all say that adUseServer is a real
resource hog on the server, but that's fine with me because the DB is on a
slick machine. Can anyone offer any advice?

thanks in advance
Corey W. Gibbs

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Kristis Makris 2002-05-09 16:07:06 Individual subsystems' CVS tags?
Previous Message Hiroshi Inoue 2002-05-09 01:36:42 Re: mylog() + qlog() implementation