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

Shane


Before you start editing the field right-click menu gives you set as null, you can also use ctrl-alt-n

Roy Lambert

<<Roy Lambert wrote:

Before you start editing the field right-click menu gives you set as null, you can also use ctrl-alt-n>>

Thanks Roy - I was tearing what's left of my hair out trying to figure out, find the answer in manuals etc. I'd tried the Right Click, but was already editing at the time, so didn't spot it.

Cheers
Shane

Shane


Tim documents ElevateDB really well (as he does DBISAM) but EDBManager's documentation is at standard developer level <VBG>

There are quite a few "hidden" features, some of which, I'm pretty sure, I still haven't come across. One of my favourites is drag a table from the list onto a blank sql window and you get the sql to create the table and the option of add the row data.

Roy Lambert

<<... EDBManager's documentation is at standard developer level <VBG>

There are quite a few "hidden" features, some of which, I'm pretty sure, I still haven't come across. One of my favourites is drag a table from the list onto a blank sql window and you get the sql to create the table and the option of add the row data.>>

That's good to know - I did search for a EDBManager manual without success, so at least I know it wasn't my searching skills lacking  I was pretty sure I had seen the answer to my null query in the documentation somewhere in the past (similarly how to enter a default date and time) but couldn't find that either.

If you're reading this Tim, a one liner in the SQL documentation section under types (".. and this is how you enter a Null, todays date etc. in EDBManager" would be ideal).

I must have discovered the drag table (or anything really) to a window by accident - I use that quite regularly as I'm designing my databases - good to have a backup to go back to quickly.

Cheers
Shane