Insert NULL question from .NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,
There is a text field that does not allow zero string and is not a required
field. In SQL Server inserting a null value is something like this:
Insert into table(id, txtField) values(34) -- that inserts a null value into
the txtField field.
But, how to insert a null into this field in Access?
Thanks for your input.
Roy
 
Hi,


INSERT INTO tableName(f1, f2) VALUES( 24, NULL )


will supply a NULL for f2, if f2 is nullable. Alternatively, if f2 as a NULL
as DEFAULT value, use

INSERT INTO tableName(f1) VALUES( 24 )


with a S to values, even if there is just one, now..




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top