Thank you Larry, the autonumbered column is not included in the insert. The insert does work as expected with the exception of the error message.
Tom ----- Original Message ----- From: "Lawrence Lustig" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, August 10, 2004 2:07 PM Subject: [RBG7-L] - Re: Supressing an error or avoiding it > > One of the > > columns is autonumbered and > > one is set after the command completes. > > > > The command file works, but the error "-ERROR- > > Incorrect number of values > > for this table(118)" Is returned. > > Do NOT include the autonumbered column in your INSERT > statement: > > INSERT INTO MyTable (MyDataCol) VALUES (DataValue) > > but NOT: > > INSERT INTO MyTable (MyAutonumCol, MyDataCol) + > VALUES (Nothing, DataValue) > > You also need to check that the INSERT worked (by > checking the SQLCode or error variable) before editing > the record. > -- > Larry > >
