Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Luis Maria Guayan
  Where is Luis Maria Guayan?
 Yerba Buena
 Argentina
 Luis Maria Guayan
 To: Jignesh Parekh
  Where is Jignesh Parekh?
 Rajkot
 India
 Jignesh Parekh
 Tags
Subject: RE: .NULL.
Thread ID: 288987 Message ID: 289171 # Views: 37 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, December 28, 2010 11:25:42 PM         
   


> > hi all,
> >
> > i need your help to replace 0 with .NULL.
> >
> > i try as below not work,
> > **f28 numaric type
> >
> > scan
> >    if f28=.NULL.
> >       replace f28 with 0
> >    endif
> > endscan
> > 

> > thanks
>
>
REPLACE f28 WITH NVL(num,0) ALL

>
> Regards,
> Jignesh Parekh
> --------------------------------------------------------------------------------------------------------------------------------
> If better is possible, Good is not enough.

REPLACE ALL f28 WITH NVL(f28,0)



Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de www.PortalFox.com

ENTIRE THREAD

.NULL. Posted by mohammed qasem @ 12/27/2010 3:40:33 PM
RE: .NULL. Posted by piyuhsh vaishnavswami @ 12/27/2010 3:44:12 PM
RE: .NULL. Posted by Samir H. @ 12/27/2010 3:53:20 PM
RE: .NULL. Posted by Anders Altberg @ 12/27/2010 4:40:40 PM
RE: .NULL. Posted by Christian Tabligan @ 12/28/2010 2:28:39 AM
RE: .NULL. Posted by Jignesh Parekh @ 12/28/2010 4:41:06 AM
RE: .NULL. Posted by Luis Maria Guayan @ 12/28/2010 11:25:42 PM
RE: .NULL. Posted by Jignesh Parekh @ 12/29/2010 8:16:03 AM
RE: .NULL. Posted by Jun Tangunan @ 12/30/2010 5:55:15 AM
RE: .NULL. Posted by Jignesh Parekh @ 12/30/2010 2:15:26 PM
RE: .NULL. Posted by Anders Altberg @ 12/30/2010 4:57:26 PM
RE: .NULL. Posted by mohammed qasem @ 12/30/2010 5:27:32 PM