SELECT DISTINCT cWorkType FROM c_list ;
WHERE NOT EMPTY(cWorkType) ;
INTO CURSOR c_WorkTypes readwrite
INSERT INTO c_WorkTypes VALUES ('All')
>
>I create a cursor with a number of rows to populate a combobox. A blank row always gets in and I want to get rid of it. Here is my code.
>
>SELECT DISTINCT cWorkType FROM c_list INTO CURSOR c_WorkTypes readwrite
>INSERT INTO c_WorkTypes VALUES ('All')
>DELETE FOR cWorkType == ""
>
>Instead of "" I tried null but the blank is always there.
>
>Any hep would be much appreciated,
--sb--