Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

HOW DO I DELETE A RECORD IN ONE FIELD?

i have fields like this say sno, name, address1, address2 etc., and there
are records in it. now i want to delete address1 for sno. don't want to
replace. how can i do this?
thnaks
n
[203 byte] By [Nimmy] at [2007-11-10 12:49:37]
# 1 Re: HOW DO I DELETE A RECORD IN ONE FIELD?
In news:3ece40e6@tnews.web.dev-archive.com,
Nimmy <RemoveThisjoriveek@RemoveJUnkyahoo.com> typed:
> i have fields like this say sno, name, address1, address2 etc., and
> there are records in it. now i want to delete address1 for sno. don't
> want to replace. how can i do this?

Hi Nimmy,

See if the BLANK command will do what you want.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com
Cindy Winegarden at 2007-11-11 23:50:54 >
# 2 Re: HOW DO I DELETE A RECORD IN ONE FIELD?
Yes, it's doing exactly what I want and exactly as you spoken...

Thanks
N.

"Cindy Winegarden" <cindy.winegarden@mvps.org> wrote in message
news:3ece5f7d$1@tnews.web.dev-archive.com...
> In news:3ece40e6@tnews.web.dev-archive.com,
> Nimmy <RemoveThisjoriveek@RemoveJUnkyahoo.com> typed:
> > i have fields like this say sno, name, address1, address2 etc., and
> > there are records in it. now i want to delete address1 for sno. don't
> > want to replace. how can i do this?
>
> Hi Nimmy,
>
> See if the BLANK command will do what you want.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy.winegarden@mvps.org www.cindywinegarden.com
>
>
>
Nimmy at 2007-11-11 23:52:00 >