General information
Category:
Coding, syntax & commands
>>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")
Maybe faster:
CREATE CURSOR Tmp2 (Name C(20))
INSERT INTO Tmp2 (Name) VALUES ("None")
SELECT Name FROM Tmp2 INTO CURSOR Tmp1;
UNION (SELECT Field1 AS Name FROM Table1)
USE IN Tmp2
This is also a little less risky since it doesn't use an array.
Vlad
Previous
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