General information
Category:
Coding, syntax & commands
Title:
Adding a new record to a cursor from SQL staetment
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only