DateTimeStamp - can I set vDB to automate my DTStamp?

[Ruslan Zasukhin]

On 3/25/12 4:19 AM, "Barry G. Sumpter" <barrysum at bigpond.net.au> wrote:

Hi Barry,

> I'd still like to know if valentina will allow me to set the DateTime field
> to auto populate.

You mean insert NOW()  on insert of record ?

You can use trigger for this

Please check 

http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:refe
rence:reference 

Something like this:

CREATE TRIGGER trig_before_insert_T1
  BEFORE INSERT
  ON T1
BEGIN
       fldDate = NOW();
END

Please check WIKI ..


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