Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
How to type a NULL value into a column when editing in EDBManager |
Tue, Sep 28 2021 12:39 AM | Permanent Link |
Shane Sturgeon | Hi
Title says it all really - I have a column in the table that I previously typed a string into, and now I want the value to be null (preferably via a key, rather than having to write SQL to do it). Typing the word "Null" doesn't do it (it's a string field so I'm not sure how to do this. In a similar vein, I seem to remember there was a keystroke you could use to automatically fill a date field with the current date - Can anyone tell me what that is please. Cheers Shane |
Fri, Nov 5 2021 6:54 PM | Permanent Link |
Richard Harding Wise Nutrition Coaching | Greetings Shane
I missed your post and you may have already worked it out. <<Typing the word "Null" doesn't do it (it's a string field so I'm not sure how to do this.>> If you right-click in the field, the menu gives an option to "Set as Null". <<In a similar vein, I seem to remember there was a keystroke you could use to automatically fill a date field with the current date - Can anyone tell me what that is please.>> Similarly, you can set Current Date, Current Time or Current Timestamp by right clicking in the field and selecting the appropriate option. <ctrl> <alt> N, <ctrl> <alt> D, <ctrl> <alt> T, <ctrl> <alt> S sets the field to null, the current date, current time and current timestamp. You can also set the default value of the fields to be CURRENT_DATE(), CURRENT_TIME() or CURRENT_TIMESTAMP(). Richard |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |