| Subject | Re: [IBO] Delphi 10 Seattle and latest IBO: date and timestamp |
|---|---|
| Author | Helen Borrie |
| Post date | 2015-12-18T19:44:54Z |
| firebird 2.5.4. database: SQLDialect 1 Connectin SQLDialect 1 and if i try to create a table comes error: ..... sql.add('bdat date,'); ..... --------------------------- Benachrichtigung über Debugger-Exception --------------------------- Exception der Klasse EIB_ISCError mit der Meldung 'ISC ERROR CODE:0 ISC ERROR MESSAGE: SQL warning code = 301 DATE data type is now called TIMESTAMP SQL warning code = 301 DATE data type is now called TIMESTAMP |
I am curious to know what the actual problem is.
Are you saying that your current Delphi/IBO interface interprets the warning as an exception and won't allow the table to be created?
This warning has been generated throughout Firebird's life. It is a warning, not an error.
| What in the hell is there going on? Has someone an idea, what i can do? |
Using the latest build of IB_SQL from the IBO website and Fb 2.5.4, I created a Dialect 1 database, no problems with that.
Then:
create table test1 (
f1 integer,
f2 date)
On Prepare, that raised the same warning that you saw.
On Execute, it created the table.
Browse shows the data type as
(Timestamp) DATE
Next:
create table test2 (
f1 integer,
f2 timestamp)
Prepare and execute, no warning.
Browse shows the data type as
(Timestamp) DATE
So, it seems, whatever version of IBO Jason used to compile that executable knows about the Dialect 1 data type transposition and does the right thing, either way.
Sorry, I can't compile anything in your environment. The youngest Delphi I have is D7.
Helen