TIMESTAMP returns field of type ftTimestamp

[upscene]

Hi there,

When I have a column of type TIMESTAMP in my Oracle database, the ODAC components return a TField of type "ftTimestamp". This confused me a bit ...

According to the Delphi help, "ftTimestamp" is only used for dbExpress.

This got my code all confused and non-working

Any reason why it's not a ftDateTime field?

--
Martijn Tonies
Upscene Productions

[Paul]

ftDateTime corresponds to TDateTimeField.
ftTimestamp is used for TOraTimeStampField type.
TDateTimeField represents functionality of Oracle DATE type.
TOraTimeStampField represents functionality of Oracle TIMESTAMP type. Those are different types with different functionality.
What problem do you have?

[upscene]

Hello Paul,

As I said earlier - according to the Delphi help, ftTimestamp is ONLY used by dbExpress. ODAC isn't dbExpress.

So, I do not really have a problem with it (although it messed some of my generic code), but I wonder why the TOraTimestampField doesn't return a "ftDateTime" result for the field type as this is what - again, according to the Delphi help - fields that support date+time return...

Obviously, as the Oracle TIMESTAMP type adds stuff to the "normal" DATE type, your TOraTimestampField could be a descendant of TDateTimeField

As I do NOT use dbExpress, this got me (and my code ) confused.

--
Martijn Tonies
Upscene Productions