Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Arvin Mendoza
  Where is Arvin Mendoza?
 The Fort
 Arvin Mendoza
 To: mut jayan
  Where is mut jayan?
 mut jayan
Subject: RE: delete field
Thread ID: 232154 Message ID: 232197 # Views: 28 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, June 20, 2009 12:05:09 PM         

> How to delete particular field value?

Hi Mut,

Correct me if I'm wrong. Do you mean the whole content of a certain field? If that's so, you may try this.

Update set =[] && Note: use [] or '' or "" if character, 0 if Numeric, if it's nullable you may set it to null.


1. Update Employee Set Lastname=[]
2. Update Employee Set Lastname=Null
3. Update Employee Set Salary=0
4. Update Employee Set Salary=NULL


Arvin P. Mendoza
Talavera, Nueva Ecija


delete field Posted by mut jayan @ 6/20/2009 6:21:38 AM
RE: delete field Posted by tushar @ 6/20/2009 6:30:26 AM
RE: delete field Posted by Jun Tangunan @ 6/20/2009 6:47:38 AM
RE: delete field Posted by Arvin Mendoza @ 6/20/2009 12:05:09 PM