Page 1 of 1
numeric field and PGLoader.fieldtype
Posted: Thu 19 Sep 2013 23:30
by piopio1
Hello,
Which is the correct PGLoader.FieldType for a numeric(16,2) field in a PostgreSQL table ?
I tried ftcurrency and ftfloat but none of these work.
Many thanks
Pio Pio
Re: numeric field and PGLoader.fieldtype
Posted: Fri 20 Sep 2013 14:53
by DemetrionQ
Hello.
Thank you for the information. We have reproduced the problem and are investigating it. We will inform you as soon as we have any results.
Re: numeric field and PGLoader.fieldtype
Posted: Fri 20 Sep 2013 14:56
by piopio1
Hello,
Is there any workaround, in the meantime ?
Thanks
Pio Pio
Re: numeric field and PGLoader.fieldtype
Posted: Fri 20 Sep 2013 16:24
by DemetrionQ
As a workaround, you can create all columns automatically using TPgLoader.CreateColumns method.
Re: numeric field and PGLoader.fieldtype
Posted: Fri 20 Sep 2013 18:03
by piopio1
DemetrionQ wrote:As a workaround, you can create all columns automatically using TPgLoader.CreateColumns method.
I tried both, design time and runtime, but no joy, any other advice ?
Thanks
Pio Pio
Re: numeric field and PGLoader.fieldtype
Posted: Tue 24 Sep 2013 09:05
by AlexP
Hello,
We have already fixed the problem, the fix will be included to the next version of PgDAC
Re: numeric field and PGLoader.fieldtype
Posted: Tue 24 Sep 2013 13:35
by piopio1
AlexP wrote:Hello,
We have already fixed the problem, the fix will be included to the next version of PgDAC
Is there any workaround in the meantime ?
Thanks
Pio Pio
Re: numeric field and PGLoader.fieldtype
Posted: Wed 25 Sep 2013 10:32
by AlexP
Hello,
You can modify the column type at both design-time - in the PgLoader column editor - and run-time:
Code: Select all
PgLoader1.CreateColumns;
PgLoader1.Columns.FieldType := ftXXXX;
Re: numeric field and PGLoader.fieldtype
Posted: Fri 27 Sep 2013 22:09
by piopio1
AlexP wrote:Hello,
You can modify the column type at both design-time - in the PgLoader column editor - and run-time:
Code: Select all
PgLoader1.CreateColumns;
PgLoader1.Columns.FieldType := ftXXXX;
sorry but I cannot fine any ftXXXX among the values in PgLoader1.Columns.FieldType
Re: numeric field and PGLoader.fieldtype
Posted: Tue 01 Oct 2013 09:11
by AlexP
Hello,
The field types are declared in the DB module, i.e.:
Code: Select all
uses ..., DB;
...
PgLoader1.Columns[0].FieldType := ftFloat;
PgLoader1.Columns[1].FieldType := ftInteger;
...