Support Forums - View Thread

View Thread

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

Messages 1 to 5 of 5 total

Thu, Jan 29 2009 9:26 PM	Permanent Link
"Paul Coshott"	Hi All, when I'm creating a table using "ElevateDB Manager", how do I create a default value for a field. I like to always use a default of zero for my numeric fields. What do I need to put in the "Default Expression" tab memo box to create a default value of 0 ? Thanks, Paul
Fri, Jan 30 2009 4:07 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Paul A 0 works for me. But I always make sure to backspace to the margin after clicking into the (I guess) memo. Roy Lambert [Team Elevate]
Wed, Feb 4 2009 5:45 PM	Permanent Link
"Paul Coshott"	Hi Roy, thanks for the help. Does CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP still work? Cheers, Paul "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:DFDF2398-8F4D-435C-8D41-013EF8A5C1B2@news.elevatesoft.com... > Paul > > A 0 works for me. But I always make sure to backspace to the margin after > clicking into the (I guess) memo. > > > Roy Lambert [Team Elevate] >
Thu, Feb 5 2009 2:14 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Paul Yup Roy Lambert [Team Elevate]
Thu, Feb 5 2009 8:05 PM	Permanent Link
"Paul Coshott"	Hi Roy, thanks for the help. Cheers, Paul "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:5977E5B6-EA64-4912-96D6-A478FA8C7C5C@news.elevatesoft.com... > Paul > > > Yup > > Roy Lambert [Team Elevate] >