Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
Using default expressions |
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] > |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |