Re: Triggers and Unix Time Format

Robert Minter (rob@dssmktg.com) wrote: : The only way I see is to change col2B to a DATETIME YEAR TO FRACTION field, : ( or whatever settings you want for a DATETIME field ) and try a trigger like: : create trigger A : update of col1A on tableA : referencing new as newA : for each row : ( update tableB : set col2B = ( select current from systables where rowid = 1 ) : where col3B = newA.col4A : ); Shouldn't "set col2B = CURRENT" be ok, too? I think you only need the "select xxx from systables..." if you want to use xxx in i4gl or esql. Regards, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+