Luciano,
I think you are right. The best behavior may be to generate an INSERT
statement that specifies no column values at all. Some databases will
allow insert statements like this:
INSERT INTO tableName () VALUES ()
But, I am not certain this is standard; we need to check. DB errors are
likely if default values have not been specified for all columns.
--
Kevin
Luciano Resende wrote:
Hi Kevin
My understanding is that we do not generate commands that include
the ID
when it is a generated primary key of a table, also, if you want to
force a
insert passing all fields you will loose any default column value
especified
during table creation. I think what you really want is to create a empty
record with the appropriae primary key on the table, and I'm trying to do
some reserch if this is possible or not. If anyone have any ideas on
how to
create a SQL command to create an empty record without specifying any
values
to the columns (e.g NULL) please let us know.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
