Обсуждение: Q: How to exclude system columns from the result of SQLColumns()?

Поиск
Список
Период
Сортировка

Q: How to exclude system columns from the result of SQLColumns()?

От
"Dmitriy Ivanov"
Дата:
Hello folks,

This is probably a FAQ, but I have failed to find the answer in the mailing
list archive.

In the DSN Datasource options (ANSI driver 08.02.0100), the ShowSystemTables
and OID boxes are unchecked. But call to SQLColumns always returns tableoid,
oid xmin and the others. Is there any setting to turn this off?
--
Sincerely,
Dmitriy Ivanov
Common Lisp ODBC interface - lisp.ystok.ru/ysql.html




Re: Q: How to exclude system columns from the result of SQLColumns()?

От
Hiroshi Inoue
Дата:
Dmitriy Ivanov wrote:
> Hello folks,
>
> This is probably a FAQ, but I have failed to find the answer in the mailing
> list archive.
>
> In the DSN Datasource options (ANSI driver 08.02.0100), the ShowSystemTables
> and OID boxes are unchecked. But call to SQLColumns always returns tableoid,
> oid xmin and the others. Is there any setting to turn this off?

Could you send me the Mylog output ?

regards,
Hiroshi Inoue