From: lynch@lscorp.com
To: 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: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!
Date: Fri, 24 Jul 1998 14:14:45 -0500
Message-ID: <v02140b18b1de419dc0b2@[207.152.64.133]> (raw)
At 10:36 AM 7/24/98, Byron Nikolaidis wrote:
>Bruce Tong wrote:
>> Another window appeared and said "Error while executing the query. ERROR:
>> The field being ordered by must appear in the target list (#1)."
>>
>> Since I hadn't specified any sorting, the "order by" part of the message
>> had me confused. I decided to have MS Access show me the SQL it had
>> generated:
>I finally figured out what the heck is going on with this order by
>problem in MS Access. I tested your query on a computer that has older
>versions of the Microsoft Jet db engine on it and guess what? It does
>the same thing you described! The reason that I used to have the
>problem and it miraculously went away was because I installed Visual
>Basic 5.0 and it upgraded the MS Jet dll's.
FWIW:
I seldom do much more than add the tables in MS Access's <OPINION> stupid
</OPINION> query design thingy. I immediately use the menu to view SQL and
just type the SQL I want. Obviously, different folks think different ways,
and maybe you actually understand and like that MS Access point and click
interface that I hate, but I want to be sure you're at least aware that if
it sticks an ORDER BY in there that you never asked for, you can just rip
the damn thing out in the SQL view and then run the query... At least,
that's how I make it give me the SQL I really want, instead of the SQL it
thinks I want, which it never gets right anyway.
Hope that helps.
--
--
-- "TANSTAAFL" Rich lynch@lscorp.com
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: lynch@lscorp.com, byronn@insightdist.com, zztong@laxmi.ev.net, pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!
In-Reply-To: <v02140b18b1de419dc0b2@[207.152.64.133]>
* 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