Welcome, Guest
Username: Password: Remember me
CodeTyphon MS Windows (Win7, Win8.x, Win10 and Win11) OS Development, discussions and problems
  • Page:
  • 1

TOPIC:

Wrong date content (CT and PostgreSQL 15) 1 year 10 months ago #17479

  • J. M. Dias Costa
  • J. M. Dias Costa's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 4
  • Thank you received: 0
Hi.

I'm developing a small 64-bit application with Postgresql 15 and, usually, at intervals
I make a new copy of the application directory as a backup.

In a data module of the application I have a TPQConection, a TSQLTransacion, a TSQLQuery
and a TDataSource.
The application shows the dates in the grid correctly.

A few days ago I found that the data grid shows all date columns in all table rows
with 12-31-9999 date instead of the correct date.

Moments ago I found that also the integer columns have strange wrong values in all rows.

In the last backup the date in the application grid is correct.
I can't recall I made any changes in the data module.

Even executing the SQL in the TSQLQuery SQL little window shows the same wrong date.

Trying to resolve the problem I installed the latest version of CT and replaced all the
Postgresql libs in the application and in the CT directory.

Does someone can help me, please?
Dias Costa

Please Log in or Create an account to join the conversation.

Last edit: by J. M. Dias Costa.
  • Page:
  • 1