Could a simple generator (64bit) not replace your TimeStamp
or be used in an additional fields to follow the exact order of inserts ?

=====================================================================================

----- Original Message -----
From: "Joe Martinez" <joe@...>
To: "Interbase Support" <firebird-support@yahoogroups.com>
Sent: Sunday, October 08, 2006 7:50 PM
Subject: [firebird-support] Exact timestamp w/o using UDF?


> Is there any way to get the exact timestamp within a trigger, other
> than using a UDF?
>
> I have a trigger that inserts the current timestamp into a
> field. When I wrote the trigger, I used CURRENT_TIMESTAMP, and I
> unfortunately assumed that it would include the fractions of
> seconds. My application needs to be able to query records, sorted by
> the order in which they were inserted, and whole seconds isn't
> granular enough for that, and it is now causing problems in my
> application. So, I now need to modify my trigger in some way so that
> the timestamp value that it inserts will include the fractions of seconds.
>
> I am trying to do some quick damage control now, and I'd like it to
> be as simple as deleting and re-adding the trigger. I have a lot of
> installations out there, and the databases are currently NOT attached
> to FBUDF. I'd like to avoid having to set that up in all of the
> installations out there, so I'm hoping for a non-UDF solution. This
> is FB 1.0, and a Dialect 1 database, by the way.
>
> Any ideas?
>
> Thanks,
> Joe
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>