![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
![]() |
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 ![]() 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 ![]() 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 Wednesday, July 2, 2025 at 06:46 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |