At 05:18 AM 04-06-01 -0700, you wrote:

>Hello.
>
>I need to know how to get the internal date of
>creation / change of a record in IB 6.0., eg
>
>list of all transaction updated today
>
>

Duleep,
Include a Timestamp column in your table and fill it with a trigger. Here a couple of triggers I have for tables in my databases:

create trigger Mem_LogInsert for Members
active before insert position 0 as
begin
NEW.CREATIONDATE=CURRENT_TIMESTAMP;
if (NEW.LASTUPDATE IS NULL) then
NEW.LASTUPDATE=CURRENT_TIMESTAMP;
if ((NEW.UPDATEDBY IS NULL)
or (NEW.UPDATEBY='')) then
NEW.UPDATEDBY=USER;
end

create trigger Mem_LogUpdate for Members
active before update position 0 as
begin
NEW.LASTUPDATE=CURRENT_TIMESTAMP;
NEW.UPDATEDBY=USER;
end

You can write a little slave program that creates the script for you!

Cheers,
Helen
All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________