Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a new record to a cursor from SQL staetment
Message
From
10/02/2016 16:45:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Adding a new record to a cursor from SQL staetment
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01631205
Message ID:
01631205
Views:
61
I need to know how to add a record to a cursor created by a SQL Select statement:

SELECT add1, recno() from cust WHERE custno=mcustno INTO CURSOR TempStore

What I am trying to do is add a record saying 'Add another Property' at the bottom of a list of properties, so if they click on that in a list/grid, it can be the trigger to append a blank for a new property in the real data file...

Any suggestions? I have tried to append blank in the cursor, but it doesn't like it...

Thanks!
Next
Reply
Map
View

Click here to load this message in the networking platform