Hello,
I'm having this issue (FYI it's working well with zeoslib comp).
1: Create a simple table with a TDateTime field.
2: Create a simple delphi project with a grid connected with this table
Retreive at design time the fields.
Compile and launch the project, insert a row, go into the DateTimeField, put a value and post.... (it will works). Close the project.
3: Now, with your favorite DBA tool,open the mysql table and change the DateTime field to an DateField.
4: Launch the project again, insert a new row and go into the DateTimeField.... you will raise an exception (0.0 is not a correct time).
As said before, I don't have this behaviour with other mysql compatible components. It is possible to change this behaviour ?
Thank you very much.
Stephan
Exception when changing field type from DateTime to Date
Re: Exception when changing field type from DateTime to Date
MyDAC doesn't support such conversion.
Most likely that Zeos uses the same field type for DATE and DATETIME fields.
Most likely that Zeos uses the same field type for DATE and DATETIME fields.
-
- Posts: 451
- Joined: Wed 19 Jan 2005 09:59