Modification date

[Ruslan Zasukhin]

On 21/2/07 5:42 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> what would be in Server 2.5.x the best way to have a modification
> date for  a record in table 1
> 
> Method?

No, because you need SAVE a value to the disk.
 
> Or do I need to do this myself whenever I write an updatequery?

Why not? This is easy.

You can use function NOW().

May be this will work in 2.5.6:

    UPDATE ...  SET fld = NOW()


----------
For v3 we developer triggers, see here:

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vsql:reference:create_trigger

Example at end of page.


-- 
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]