table property

[Ruslan Zasukhin]

On 2/19/11 10:37 PM, "George Parkinson" <george at microtherapy.ca> wrote:

Hi George,

> i can't think of one that has such a feature.
> the db that i'm migrating from is codebase (client/server using foxpro dbfs)
> claims to have such a feature but i've never seen it work.

Actually, after I have sent letter, I did remember that we do have in plans
feature, which may do this job:
    some internal clocks in db,
    and each schema object remember last "time" of change

 
> triggers - yes - that should do nicely!
> (i'm still very new to the sql stuff)

Then few fast advices here:

You will need create few triggers for a table:
  CREATE TRIGGER ON INSERT,  ON UPDATE, ON DELETE.

Body of trigger can be as simple as

CREATE TRIGGER ON INSERT ..
BEGIN
    SET PROPERTY MyLastTime OF TABLE T TO  SomeValue
END


====
And if you have N table in db, you need such triggers for each Table.
So you can make some general function in your RB code
Which give name of table, and produce these 3 triggers for it.

Actually this CODE, which build SQL strings of triggers,
Can be even inside of db itself as Stored Procedure.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]