#1 Re: mORMot 1 » Return value if some field does not exist » 2017-05-02 15:35:30

That´s appear de same pronblem by other post with title invalid Date and time.

#2 Re: mORMot 1 » EConvertError with message "0.42821" is a not valid timestamp » 2017-04-30 03:20:00

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.

#3 Re: mORMot 1 » EConvertError with message "0.42821" is a not valid timestamp » 2017-04-29 04:20:06

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.

#4 Re: mORMot 1 » EConvertError with message "0.42821" is a not valid timestamp » 2017-04-28 19:57:07

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

#5 Re: mORMot 1 » EConvertError with message "0.42821" is a not valid timestamp » 2017-04-27 21:44:19

I tested with firebird and mysql sql. Both raise the same error. I think that's this error in SynDbZeos...

#6 Re: mORMot 1 » EConvertError with message "0.42821" is a not valid timestamp » 2017-04-27 21:41:18

i got today 27 apr 2017 the lastest version of mormot and the error raised agan.

Board footer

Powered by FluxBB