Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 3 of 3 total |
Table FieldDef DateTime Default Value |
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 |
This web page was last updated on Tuesday, April 23, 2024 at 08:10 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |