>Hi friends
>is there any easy way to find a blank record in a table.
>
>at our sites ,there are few tables that contain blank records i.e. even though record is added no field is actually filled in. i need to delete such records.
>Thanks for the help.
select myTable
scatter name oBlank memo blank
scan
scatter name oCurrent memo
if compobj(oBlank,oCurrent)
delete
endif
endscan
Cetin