> >BTW, I will try to implement reading BLOB fields
> >within a few weeks. There only is a small
> >problem with that at the moment: I need to
> >implement in TODBCConnection the function
> >
> > function CreateBlobStream(Field:TField; Mode:TBlobStreamMode):TStream;
> >
> >However, I need the TSQLHandle here (for the
> >ODBC API call), not the TSQLConnection, where it
> >is a method of. I think the Handle should be
> >passed as an additional parameter. Or is there
> >some way to (correctly) get the TSQLHandle from the Field parameter?
>
> Based on my experience and lot of years "in the
> field" I'd dare to say that TIMESTAMP is most
> used than BLOB and GRAPHICS. At least if we are
> speaking about business applications(like banks, credit card operators, etc)
Sure, but what I understood from Bram, some other Timestamp/Datetime
fields were working, only this particular sort of Timestamp isn't.
> >Another thought on the problems Arí has with
> >update queries and TODBCConnection: as I need
> >only read access, I never implemented UpdateIndexDefs; might that be
> >required?
>
> UpdateIndexDefs? What is the function of such
> method? Since data base manager ever keep the
> index(es) up-to-date and it has the index(es)
> description in its areas, I can't imagine...
To let modifications things work automatically, it is needed. This
function updates the information about the indexes on the table. From
this information it derrives what the primary key is. And the where part
of the update/insert/delete statements is depending on the primary
key... But you could also 'manually' add all fields-definitions, and
then set the field that should be used in the where-clause of the sql-
statement.
> I would like to remember that it's so important
> that DB2 keep the TIMESTAMP in the format with 6
> digits of fraction of second. BTW I thing and
> insist that a return of string [26] will be more
> easy(I think) and clear. People can do the
> conversions in the application program.
I'm not sure about that. The developer is asking for a Date/time, so
he'll expect that he'll get a Date/time.
If you need a string from DB2, I would use a cast in the sql-statement.
JoJo,
Joost.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
