Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting null field value recordsl
Message
From
29/10/2006 13:37:49
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01165373
Message ID:
01165381
Views:
10
>>I have discovered that there are some blank fields in one of my tables.
>>
>>The numeric field in question has never had a numeric(or any other)value written to it.
>>
>>I have tried
>>
>>
>>DELETE FOR x = .null
>>
>>
>>but that code does not work for me. How can I globally mark the blank field records for deletion?
>>
>>+++ Grady ---
>
>Grady try with
>
DELETE FOR EMPTY(x)
Thanks folks - problem solved.
I ain't skeert of nuttin eh?
Yikes! What was that?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform