Le 08-févr.-05 à 18:54, dave@... a écrit :

> The reason for this thread is that I was wondering if there was a way
> to use the native Firebird timestamp data type, and some API other
> than CAST, to store and retrieve the fractional seconds. IBPP doesn't
> allow me to "Set()" a timestamp column using a string variable in a
> prepared statement, even though the exact statement works correctly in
> ISQL or FlameRobin; it's a data type conflict. Otherwise IBPP has
> done what I've needed quite well.

I will have to check (or you could step the code too to verify this)
what is the exact SQL description returned by the engine to the client
code for your timestamp parameter when the statement is looking like:

> INSERT INTO CACHEDNS (REMOTEIP, REMOTEHOST, LASTUPDATED, ROWID)
> VALUES (?, ?, CAST('?' AS TIMESTAMP), ?)

I wonder if the third '?' is described as a string or as a timestamp in
the returned XSQLDA structure...

--
Olivier Mascia