>In VFP, I want to generate an ID # and APPEND a record. I have tried two versions of code w/o success:
>
> SELE Indiv
> SET ORDER TO TAG idno
> GO BOTT
> nid = idno + 1
> SET ORDER TO TAG Name
> APPEND BLANK
> REPLACE Indiv.IDNo WITH nID
>
>The REPLACE line gives me an error message: Command contains unrecognized phrase/keyword.
>
>The following line, in place of the last two above, also bombs: Syntax error.
>
> INSERT INTO Indiv (idno) VALUES (nid)
>
>What am I doing stupid? TIA.
why not just replace idno with nid?