Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting null field value recordsl
Message
 
To
29/10/2006 12:24:55
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:
01165377
Views:
9
>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)
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform