Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

1998-07-24 Thread Bruce Momjian
> > Since I'm learning SQL in my spare time, I tend to use these feature in MS > Access and PgAccess to point me in the right direction or sometimes > confirm, or deny my assertions. > > I like psql, but its not the kind of tool which suggests other > alternatives. It just says "this part is bog

Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

1998-07-24 Thread Bruce Tong
> FWIW: > > I seldom do much more than add the tables in MS Access's stupid > 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 clic

Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

1998-07-24 Thread Byron Nikolaidis
Richard Lynch wrote: > > > FWIW: > > I seldom do much more than add the tables in MS Access's stupid > 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 th

Re: [GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

1998-07-24 Thread Richard Lynch
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

[GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

1998-07-24 Thread Byron Nikolaidis
Bruce Tong wrote: > > > The working version of \windows\system\MSJET35.DLL is 3.51.0623.4 > > The broken version I tested was 3.50.3602.4 > > I'm not sure at what release they fixed this problem. > > > > I will dig around on MS web site. > > > > Does anyone know if its OK to redistribute the MS J

[GENERAL] Re: [INTERFACES] ODBC Driver -- Access Order By problem solved!!!

1998-07-24 Thread Byron Nikolaidis
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 m

[GENERAL] Re: [INTERFACES] ODBC Driver

1998-07-22 Thread Byron Nikolaidis
Bruce Tong wrote: > > I knew I needed to check my work before bringing the ODBC driver problems > out in the open. Here's what I've found. > > I was designing a simple query using MS-Access having already defined > an external data source to a PostgreSQL database just to make sure > things work