You are not logged in.
Pages: 1
That´s appear de same pronblem by other post with title invalid Date and time.
Well, i maked tests with this modifications. Works almost well.
The error no more raise, the contente of TDateField are ok. But the content of TTimeFields apears with blank Date together. If we use editmask property at TTime field raise the error invalid timefield becouse the delphi dont expect these date together.
But i'm happy. Plase qq if you can correct this on yor code. Thakss a lot.
I maked more tests. I return to use mysql and i verify that even using SQLDBRows.Step the contente of columns of type DateTime retrive a blank value. At this tima i did not use ToDataSet procedure. I.E. The problem problably do not reside in ToDataSet procedure.
Well, today I tested with the sqlite and I use to connect
Props := TSQLDBSQLite3ConnectionProperties.Create('testedbsqlite.db3', '', '', '' );
then a single sql in memo end run this code
datasource.dataset := ToDataSet(Self, Props.Execute(Memo1.Text, []));
If no date, datetime or time fields at table run ok. But if existe any date, datetime and time field the error raise at the same form that raise in firebird and mysql using zeos.
I think new that this error is in ToDateSet procedure.
But I knew a person in facebook that use mormot than I ask if he help-me with this issue. I send to him my source exemplo and,
For my surprise, the code runs nice.
I create a new virtual machine with Windows, i installed delphi and mormot and zeos. But the error raise agan im my new machine.
That´s crucial tu me for use mormot becouse i will don´t use ORM i only need to user direct acess for firebrd, sqlite or mysql
I tested with firebird and mysql sql. Both raise the same error. I think that's this error in SynDbZeos...
i got today 27 apr 2017 the lastest version of mormot and the error raised agan.
I got the same problem.
i got the same problem
Pages: 1