> Actually, there are two issues here. First, the message about the field
> being ordered by must appear in the target list is appearing because
> Access is throwing that order by clause in there for some reason which
> we have been unable to discover (perhaps for optimization?). BTW, are
> you using Access 97 or 95? Second, Dave has a patch for Postgres on our
> website which allows the order by and group by clauses to not be in the
> target list, which would probably get you past this.
Access 97.
> I created your tables in my database and was not able to re-create the
> error in Access. You might try upgrading to the latest driver (.0248)
> which is what I was using to test with. I used to get the same message
> you got here but I haven't been able to reproduce it lately. You might
> want to relink your tables in Access and/or re-create the query before
> you try your test again.
I can make my database available to you over the net if you want. I just
need your IP address so I can authorize you in pg_hba. Contact me directly
if you're interested and I'll create an account for you, etc. The actual
tables are a little bigger than the examples I posted. I can also send you
the exact table definitions as I have all the SQL to create them in a file
I use in accordance with a makefile. Let me know if/how you want to
proceed.
I'll grab the latest driver and try that as well.
Bruce Tong | Got me an office; I'm there late at night.
Systems Programmer | Just send me e-mail, maybe I'll write.
Electronic Vision / FITNE |
zztong@laxmi.ev.net | -- Joe Walsh for the 21st Century