>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,
SELECT DISTINCT cWorkType FROM c_list INTO CURSOR c_WorkTypes readwrite where !(cWorkType == "")
INSERT INTO c_WorkTypes VALUES ('All')
PS: If you wnat to go delete way then:
DELETE from c_list where cWorkType == ""
Behavior of == is not same for ansi and exact. With delete for it should be:
Delete for trim(cWorktype) == ""
or:
Delete for cWorktype == space(fsize('cWorkType'))
or:
delete for empty(cWorkType)
etc
Cetin