Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select SQL into a cursor
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00063640
Message ID:
00063642
Views:
52
>I have a ComboBox that I would like to list all of the records in a file but I also would like the first entry in the combo box to say "None" or whatever. I thought I would put the "none" record in a cursor and then append the records from the table through a select sql. Well when I do that I lose the "none" record. Is there a way to get all of the records into a cursor from a table using Select SQL and then adding one more record to that cursor?

Create Cursor tmp1 (Name C(20))
Select field1 From table1 Into array tmpArray
Insert Into tmp1 from array tmparray
Insert Into tmp1 Values("None")
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform