[RBG7-L] - Re: Supressing an error or avoiding it

[Lawrence Lustig]

> 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