Expert: Sorting a DBGrid from an Access Db via ADO

From: Pontus Berg (pontus_at_berg.to)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 00:44:23 +0200

Howdy!

I'm not managing to get a sorted GBGrid view of a Access 2003 database, via
ADO.

The DB connection is an ADOConnection with a client side cursor. I use a
ADODataSet, with the command text "SELECET * from <my table in the DB
file>". Again, static client cursor. A fully normal DBGrid connects to the
ADODataSet via a DataSource.

I have trapped the click of the column headers and placethe relevant field
names in the ADODataSet.IndexFieldNames but the field is a lookup field, so
this operation won't work. (Placing some other field works nicely, but not
the lookup field).

Is there any EASY way around this to actually sort a DBGrid based on a field
which is of the Lookup kind?

/Pontus

Relevant Pages

  • Re: ... after Opening a record set
    ... I will point out that as long as one can live with a client cursor (all records retrieved to the client machine during the ... it is better to loop based on EOF unless there is a compelling reason to do otherwise. ... >> It is not a reliable method of retrieving records from a recordset. ...
    (microsoft.public.vb.database.ado)
  • Re: ORATCL help needed!
    ... set cursor ... Wow, An Oratcl 3.3. ... It is coded with the the OCI layer released with Oracle ... Oracle instant client is available for many many platforms, ...
    (comp.lang.tcl)
  • Re: cancel ADO2.8 asynchron queries over WAN, takes long time
    ... >> the .open method first creates the recordset at the server. ... I use clientside cursor to minimalize the traffic... ... You do not want to be managing any types of cursors on the client ... > doing so over a slow link is a bad choice. ...
    (microsoft.public.data.ado)
  • Re: cancel ADO2.8 asynchron queries over WAN, takes long time
    ... >> the .open method first creates the recordset at the server. ... I use clientside cursor to minimalize the traffic... ... You do not want to be managing any types of cursors on the client ... > doing so over a slow link is a bad choice. ...
    (microsoft.public.sqlserver.programming)
  • Re: VB connection to SQL server
    ... > the client machine begins to lose its relevance and accuracy as soon as it ... > aware that the data is probably out of date, a client sided cursor might ... > design minimises the possibility that records will have changed in the ... >> The Database server is in the office, and people use the Vb program from ...
    (microsoft.public.vb.database)