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

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