DELETE FOR EMPTY(cWorkType)

cWorkType does not == "" as it has a length of the field size, If you want to use == then ...

DELETE FOR cWorkType == SPACE(LEN(cWorkType))




>Hi there,
>
>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,