Set single field to NULL in Table View

[JESS1CA]

Hi everyone,
I was wondering if anyone knows of a shortcut to set a single field to 'Null' from within the Table Model view. I continually have to write update queries to do this, and it seems like there should be an easier way.

Thanks in advance!
Jess

 

[tlbroadbent]

Jess,

Could explain with a little more detail what you want to accomplish? What do you mean by "Table Model View?" Are you updating one column on one row or one column on many rows?

Thanks, Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[JESS1CA]

Hi Terry,

I'm just trying to update one column and one row. I think there should be a way to update a field to 'NULL,' just like you can directly type a value into a field when you are looking at the table.

I know I can update the field using SQL (using an update query) but I was hoping to find a shorter/easier way to do this when I am going through the data.

Thanks!
Jess

 

[tlbroadbent]

In SQL 2000 EM table view you can type Ctrl-0 (zero) in the cell and NULL will be inserted. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.