MS Access via ODBC

Поиск
Список
Период
Сортировка
От Taral
Тема MS Access via ODBC
Дата
Msg-id 000001bdc3c6$299f7960$3b291f0a@taral
обсуждение исходный текст
Список pgsql-sql
I noticed that when trying to get MS Access to do a query of "SELECT * FROM
table ORDER BY somekey" as its data source for a form, it actually issues
"SELECT primarykey FROM table ORDER BY somekey", which PostgreSQL rejects
because "somekey" isn't being selected.

Now, either PostgreSQL has put an (odd) restriction on SQL, or MS Access is
issuing an invalid SQL query. Which one is it?

Taral


В списке pgsql-sql по дате отправления:

Предыдущее
От: Johann Spies
Дата:
Сообщение: Re: [SQL] What is the recommended machine configuration?
Следующее
От: "Stuart logan"
Дата:
Сообщение: Installing PostgreSQL 6.3.2 On Linux