numeric field and PGLoader.fieldtype

[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

[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.

[piopio1]

Hello,

Is there any workaround, in the meantime ?

Thanks
Pio Pio

[DemetrionQ]

As a workaround, you can create all columns automatically using TPgLoader.CreateColumns method.

[piopio1]

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

[AlexP]

Hello,

We have already fixed the problem, the fix will be included to the next version of PgDAC

[piopio1]

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

[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;

[piopio1]

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

[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;
...