Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
TimeStamp Default Value |
Thu, Feb 2 2006 2:07 PM | Permanent Link |
"Johnnie Norsworthy" | Is there a way to specify default value for a timestamp field in the form:
DefaultValue = CURRENT_TIMESTAMP + (2 hours) I need to compensate for time zone differences. All of my users are CST and the server is in PST. -Johnnie |
Fri, Feb 3 2006 5:25 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Johnnie,
<< Is there a way to specify default value for a timestamp field in the form: DefaultValue = CURRENT_TIMESTAMP + (2 hours) I need to compensate for time zone differences. All of my users are CST and the server is in PST. >> Unfortunately you cannot use complete expressions for the default values in DBISAM, so you'll have to populate them using a BeforeInsert and BeforeUpdate trigger. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Feb 3 2006 6:10 PM | Permanent Link |
"Johnnie Norsworthy" | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:1ADAFCA3-AF34-4526-B925-3F9520DABEEA@news.elevatesoft.com... > Johnnie, > > << Is there a way to specify default value for a timestamp field in the > form: > > DefaultValue = CURRENT_TIMESTAMP + (2 hours) > > I need to compensate for time zone differences. All of my users are CST > and the server is in PST. >> > > Unfortunately you cannot use complete expressions for the default values > in DBISAM, so you'll have to populate them using a BeforeInsert and > BeforeUpdate trigger. Thank you. -Johnnie |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |