Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
APPENDectomy
Message
From
08/11/1996 14:08:38
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
APPENDectomy
Miscellaneous
Thread ID:
00011853
Message ID:
00011853
Views:
69
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.
Next
Reply
Map
View

Click here to load this message in the networking platform