Re: NUMERIC type makes trouble in MS Access

Поиск
Список
Период
Сортировка
От Tobias Wendorff
Тема Re: NUMERIC type makes trouble in MS Access
Дата
Msg-id 8492731c6ad493448ba8ed226888cfca.squirrel@webmail.tu-dortmund.de
обсуждение исходный текст
Ответ на Re: NUMERIC type makes trouble in MS Access  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Список pgsql-odbc
Hi Hiroshi,

thanks for your reply!

Am Sa, 26.05.2018, 14:23 schrieb Inoue, Hiroshi:
>> commercial ODBC driver:
>
> What is the commercial ODBC driver?

Devart ODBC Driver for PostgreSQL

> The column v is numeric item without precision.
> Are the following insertions possible using the commercial DBMS?
>
>> INSERT INTO demo VALUES (1.0123456789);
>> INSERT INTO demo VALUES (1.01234567890123456789);
>> INSERT INTO demo VALUES (12345.012345678901234567890123456789);

I don't insert things, it's a read only database. The problem is
about getting the data into Access. The insertions just were an
example for testing, which values or types actually make an issue ;)

Could you perhaps add a switchable function like "cast numeric to
float"?

Best regards,
Tobias



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

Предыдущее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: NUMERIC type makes trouble in MS Access
Следующее
От: "Tobias Wendorff"
Дата:
Сообщение: Re: NUMERIC type makes trouble in MS Access