>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!
SELECT add1, recno() from cust WHERE custno=mcustno INTO CURSOR TempStore READWRITE
proceed with APPEND or INSERT as on any other cursor.
Update:
That was close. I missed the VFP 7 - but then READWRITE was introduced on VFP7
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]