TAble Insert

[Dale]

I have a person table that has id, firstname, lastname, address, city, state,
zip. I have set all fields except id to have required = no and allow zero
length = yes. But when I try the following query it will not insert the
record because the firstname is not filled out. Any ideas?

INSERT INTO person ( id, lastname, firstname, address, city, state, zip )
VALUES (1783, 'Hacienda La Daniela', '', '5310 SW 192 Avenue', 'Sw Ranches',
'Fl', '33331');

 

[Allen Browne]

Try inserting Null instead of a zero-length string:

INSERT INTO ...
VALUES (1783, 'Hacienda La Daniela', Null, '5310 SW 192 Avenue', ...

More info about how to handle nulls:
http://allenbrowne.com/casu-12.html