Expecting: TDateField actual: TPgDateField

yapt · Post by **yapt** » Sun 13 Sep 2009 20:36

PgDAC 1.20
PostgreSql 8.4.0
***********************

After upgrade to 1.20 I have this error on open/activate a PgTable that was working fine with 1.10:

TableName: Type mismatch for field 'datefield', expecting: TDateField actual: TPgDateField

Greetings.

dschuch · Post by **dschuch** » Sun 13 Sep 2009 22:59

sounds to me as a type change. try to recreate your fields. i think your fields are static in your dfm, delete that fields and recreate them in the fields editor.

daniel.

Plash · Post by **Plash** » Mon 14 Sep 2009 10:55

The field type is controlled via the EnablePgTimeStamps option of TPgConnection. When this option has the default value (False), standard TDateField is created.
When this option is True, TPgDateField is created. TPgDateField supports all values supported by DATE field in PostgreSQL database including B.C. dates. If you don't have dates from the distant past or future, you should use standard TDateField.

To fix the problem, set the EnablePgTimeStamps option to a value that you want. Then recreate fields in Field editor.

yapt · Post by **yapt** » Mon 14 Sep 2009 16:06

Solved....

Thanks a lot...