table property

[George Parkinson]

hi ruslan,
cool - i'll get use of that new feature.
in the meantime, the trigger/property will certainly do the trick.
much appreciated - thanks for your help!
george




----- Original Message ----
From: Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com>
To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
Sent: Sun, February 20, 2011 2:59:56 AM
Subject: Re: table property

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]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina