Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete empty records
Message
From
28/08/2008 02:54:12
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Delete empty records
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01342460
Message ID:
01342460
Views:
58
hi all,

i try to delete empty records form my table after i convert excel sheet to dbf,

is there another way to do that as

IMPORT FROM (thisform.text11.value) TYPE xls&&delete all empty records

i try as
SCAN
  SET FILTER TO  no=SPACE(70)&&work
***&&no="" not work,no=space() not work 
     DELETE all
     pack
endscan 
thanks
Next
Reply
Map
View

Click here to load this message in the networking platform