SQL Insert command

[Fox20]

Hi,

I am using an Access database with an ODBC driver and VC++ 6. One field is declared as AutoValue, i.e. the number increases automatically for every new record.

If I insert a recordset with "insert into table values ('x', 'y', ...)" - what do I have to use for the AutoValue field? ('x', '', 'y') or ('x',, 'y') or what else?

Thanks,


Fox


"I don't like much, really, do I? [laugh] But what I do like, I love passionately!" (Pet shop boys)

[Burlacu Ovidiu]

Try in thsi way:

insert into table (col1, col2, ...) values ('x', 'y', ...)//and name only col u want to set a value (col1, col2, etc.)the rest will automaticaly take default value

Let me know if this help u
Regards,
ovidiu