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:
01165378
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 ---

delete for IsBlank(myField)
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform