>>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 ADDITIVE
> if compobj(oBlank,oCurrent)
> delete
> endif
>endscan
>
Cetin