| Subject | Re: [IBO] Re: Delphi 10 Seattle and latest IBO: date and timestamp |
|---|---|
| Author | Gerhard Knapp |
| Post date | 2015-12-18T11:39:24Z |
Hello Jason,
the bad thing for me is, i have to stay on Dialect 1
But i had the Choice in IB_Connection for dialect 1 or dialect 3,
or with other words, if the xxx.fdb file itself is on dialect1 and i set
the connection to dialect1, this allways worked for me.
And i want to stay with dialect 1, because to much lines of code
to alter :(
There are many production databases with a GB sizes and 1000tes of
tables, that i have to migrate, changing fieldtype from "date" to "timestamp".
Then next thing is changing this also in all application code, where fieldtypes
are reading out, or new tabels will be created, and so on.
I know dialect1 is old, but i have no idea how to migrate soon.
My surprise was, that IBO seems not longer give me the opinion to
Dialect1, whether it's set. Seems to be it works only with dialect 3 now.
And i was not sure ist this the new Delphi Seattle or the latest IBO version.
Uff
many thanks for answering
Gerhard
the bad thing for me is, i have to stay on Dialect 1
But i had the Choice in IB_Connection for dialect 1 or dialect 3,
or with other words, if the xxx.fdb file itself is on dialect1 and i set
the connection to dialect1, this allways worked for me.
And i want to stay with dialect 1, because to much lines of code
to alter :(
There are many production databases with a GB sizes and 1000tes of
tables, that i have to migrate, changing fieldtype from "date" to "timestamp".
Then next thing is changing this also in all application code, where fieldtypes
are reading out, or new tabels will be created, and so on.
I know dialect1 is old, but i have no idea how to migrate soon.
My surprise was, that IBO seems not longer give me the opinion to
Dialect1, whether it's set. Seems to be it works only with dialect 3 now.
And i was not sure ist this the new Delphi Seattle or the latest IBO version.
Uff
many thanks for answering
Gerhard
Am 17.12.2015 um 19:00 schrieb
supportlist@... [IBObjects]:
This was one of the most awkward and painful aspects of changing from Dialect 1 to Dialect 3.
They changed the way the DATE column works and renamed things.
Are you wanting to stay with Dialect 1 or can you just migrate to Dialect 3?
Jason Wharton
