>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.
Hi Rajani,
Normally there is usually 1 field in your table that always requires data (like an id field). So pick a field like that and scan for empty(). For example, if you have a field ABCID in table TEST, you could do the following:
select test
scan for empty(abcid)
delete
endscan
This will scan through the whole table looking for empty ABCID fields. It then deletes these records one-by-one. For a single user system you can simply type the following command:
delete for empty(abcid)
Regards,
Ed