From: Byron Nikolaidis <byronn@insightdist.com>
To: Bruce Tong <zztong@laxmi.ev.net>
Cc: PostgreSQL General <pgsql-general@postgreSQL.org>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC Driver
Date: Thu, 23 Jul 1998 11:57:16 -0400
Message-ID: <35B75D5C.63B6219A@insightdist.com> (raw)
References: <Pine.LNX.3.95.980723111306.22241A-100000@laxmi.ev.net>
Bruce Tong wrote:
>
> Installed, threw away the old data link, created a new data link, same
> problem occurred.
>
OK, could you try this before we resort to more drastic things. When
you are looking at the design view of your query, right click and call
up "properties" or call it up under the "View" menu. For the "RecordSet
type" property, try changing it to "Snapshot". See if this causes
Access to not throw the "order by" clause in the query.
Of course having the recordset type as a snapshot means you can't update
the query resultset. Let me know if it works.
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, zztong@laxmi.ev.net, pgsql-general@postgreSQL.org
Subject: Re: [INTERFACES] ODBC Driver
In-Reply-To: <35B75D5C.63B6219A@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox