Hi Alex!
In fact I was trying to do a browse with option
of UPDATE, DELETE or INSERT via DBNavigator and
DBGrid. The functions that make changes in the
DB2 tables are not OK. I give up. I had the idea
because I'd do a similar browse in Firebird bases.
During conversations about this we began to discuss about DB2 TIMESTAMP format.
But, thank you for your contribuition.
(How are the whole things?)
Regards
Ricardo
At 12:50 4/4/2006, you wrote:
Hello Arì!
I was reading the thread, and then come to my mind a technique I was
using in such cases where the database has more advanced fields than
what is possible with Delphi.
I always use TDateTime usually because it is very standard and
painless to work with. I can switch the database backend with no
problems. I like it.
But when I want some very specific information from the database that
i can't get from a standard TDatetime (for example, I'm always using
PostgreSQL that I like a lot, the timestamp can contain localized
information, but not the TDateTime format) so what I do is that in my
SQL query I'm casting the type to another type, like a string, so that
I can proces the information manually by myself when required. This is
always working because the casting of the database is standard.
Now this is valid for PostgreSQL RDBMS, and since I don't know about
DB2, I'm wondering if casting the field type to another type in the
SQL statement could be a solution for you? So you could use standard
TDateTime when not required, or some casting when you need very
precise information.
Hope this can help you.
Best regards.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
