Page 1 of 1
Expecting: TDateField actual: TPgDateField
Posted: Sun 13 Sep 2009 20:36
by yapt
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.
Posted: Sun 13 Sep 2009 22:59
by dschuch
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.
Posted: Mon 14 Sep 2009 10:55
by Plash
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.
Posted: Mon 14 Sep 2009 16:06
by yapt
Solved....
Thanks a lot...