Merry Christmas and a Happy New Year. I think I got it from Bill Downall.
Albert
[email protected] wrote:
Albert: I cannot believe after umpteen years of RBase programming
that I had NO CLUE you could use the "nonum" to insert into an
autonumbered column!!!! I would have a separate one-column
autonumbered table where I grabbed my "next", with no autonumber on
the real table ....
Thanks for the Christmas present!
Karen
INSERT INTO Invoices (col list here) +
SELECT InvNo, <and the rest> +
FROM InvEntry NONUM
