I believe just replace

CURRENT_TIME by 'NOW' .. with quotes

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <firebird-support@yahoogroups.com>
Sent: Sunday, March 20, 2005 2:44 PM
Subject: RE: [firebird-support] tracking progress of a SP


>
> I was trying to track the internal progress of a SP that was running
> quite slow.
>
> I created an external table, then wrote to the table at various
> points from within the SP and updated using CURRENT_TIME and a note
> field. Of course, as I later learned from the documentation the
> CURRENT_TIME was set at the beginning of the SP and never
> incremented.
>
> I finally figured out what was causing the slow processing, but I
> would like to know for the future if something like this is
> possible. I tried to Google, but only got information as to why it
> doesn't work.
>
> Is there any way to get a real CURRENT_TIME from within a SP?
>
> Thanks,
>
> Rick
>
> use 'NOW' instead of CURRENT_TIME
> Alan
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>