At 12:26 29/3/2006, you wrote:
Bram, I think Arí is using the same ODBC connection with other programming langs. So the ODBC can report the YYYY-MM-DD HH.MM.SS.UUUUUU. I just didn't want you spending to much time questioning the ODBC connection.
Ya! These whole story begins with a project of migration of a fourth tool of IBM mainframe(named COOL:Gen) to single cobol for MVS programs. We have the CA-Realia cobol installed in our local network and it emulates the mainframe environment. As I hate cobol(even being an expert) I wrote utilities in FPC and Lazarus. With the release 0.9.12 I discovered that Lazarus can access DB2 tables via ODBC. I wrote a Lazarus program to let the people that are testing the converted programs make alterations on DB2 tables in user-friendly format(DBNavigator + DBGrid). When I try to browse the 1st table containing TIMESTAMP Db2 columns the show begins. I'm using the same ODBC driver that is used for CA-Realia cobol (not simultaneous, of course).
It is my understanding that the SQLdb currently does not support any PK type other than numeric. So I think Update, Delete would not work with a TTimeStamp. I'm not to sure how the insert would work.
How I am only browsing the tables in sequential mode with Lazarus visual tools, there are no PK(primary keys envolved), I suppose. Am I wrong?
[ ] Ricardo _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives