The problem is that it's a class and the SQL is created 'on the fly' from the class properties (e.g. cColumnFields = cus_name, cus_casenum, cus_ssn). I don't really want to have to mess up that routine because of a bug. I'll probably handle it in the UI someway (dropdown list or command buttons).

Thanks

John

>You can always create an empty cursor by runing your select with a condition that ptoduces 0 records, like WHERE .F. or WHERE 1=0 (Sql Server style).
>