Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Mon, Jan 28 2008 9:37 PM	Permanent Link
"Andrew Hill"	Hi, I am trying to set the default TimeStamp value in a table field:- Add('EditedOn', ftDateTime, 0, false, 'Now()'); Add('EditedOn', ftDateTime, 0, false, 'DateTime'); Add('EditedOn', ftDateTime, 0, false, 'TimeStamp'); Add('EditedOn', ftDateTime, 0, false, 'Time'); Add('EditedOn', ftDateTime, 0, false, '2007-01-01 00:00:00'); All of the above fail, please advise - Thanks in advance Regards Andy
Tue, Jan 29 2008 5:58 AM	Permanent Link
Mauricio Campana Nonino	Andy <<Hi, I am trying to set the default TimeStamp value in a table field:->> CURRENT_TIMESTAMP is what you need. Mauricio Campana Nonino Nonino Software
Tue, Jan 29 2008 12:58 PM	Permanent Link
"Robert"	"Andrew Hill" <andyhill@axfite.com.au> wrote in message news:A6C967F5-C8E2-4189-AA69-6D61E87DFCFE@news.elevatesoft.com... > > Add('EditedOn', ftDateTime, 0, false, '2007-01-01 00:00:00'); > It's been a while since I've done these in code (SQL is much simpler) but I think it should be Add('EditedOn', ftDateTime, 0, false, StrToDate('1/1/80')); IOW that the default has to be the same type as the field. Robert