Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Deleting records
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Divers
Thread ID:
01076635
Message ID:
01076635
Vues:
52
hi all, i have a table and thousands of records in it. i want to delete any record with no entry in a field but i don't know how to do it. the field is a numeric field and i want to only delete the records that have nothing in it but not those with a 0. i have tried brow for field = .NULL. and empty(field) to see what would be deleted but this won't do. any help much appreciated. Slán ~M