SQL: INSERT INTO without specifying any column

[Alexander]

Hi there!
I need to write an sql statement, that inserts a blank (empty) row into a
table.

I tried
"Insert Into tabname",
"Insert Into tabname () VALUES ()"
"Insert Into tabname VALUES ()"
"Insert Into tabname VALUES"
....

But nothing worked.

As I am writing classes to access databases, I do not know any field-name
when inserting a blank row.
There is an autovalue - column (identity), which I use to identify the new
row.

Any idea, how a statement can insert a blank line?

Regards
Alex

[Steve Jorgensen]

A blank row is one that contains a Null value in every row. To explicitly
insert a null into a column, you can simply use the word Null, so just include
one column explicitly, and use (Null) for the VALUES clause.

Example:
INSERT INTO tblFoo (FirstFooColumn) VALUES (NULL)

On Fri, 19 Dec 2003 08:36:03 +0100, "Alexander" <ab****@gmx.net> wrote:

Hi there!
I need to write an sql statement, that inserts a blank (empty) row into a
table.

I tried
"Insert Into tabname",
"Insert Into tabname () VALUES ()"
"Insert Into tabname VALUES ()"
"Insert Into tabname VALUES"
...

But nothing worked.

As I am writing classes to access databases, I do not know any field-name
when inserting a blank row.
There is an autovalue - column (identity), which I use to identify the new
row.

Any idea, how a statement can insert a blank line?

Regards
Alex