Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Christian Tabligan
  Where is Christian Tabligan?
 Bacolod City, Neg. Occ.
 Philippines
 Christian Tabligan
 To: mohammed qasem
  Where is mohammed qasem?
 amman
 Jordan
 mohammed qasem
 Tags
Subject: RE: .NULL.
Thread ID: 288987 Message ID: 289024 # Views: 54 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, December 28, 2010 2:28:39 AM         
   


> 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

CREATE CURSOR TEMP (NUM I NULL) && MUST ACCEPT NULL
INSERT INTO TEMP VALUES (0)
INSERT INTO TEMP VALUES (2)
INSERT INTO TEMP VALUES (0)
REPLACE NUM WITH IIF(NUM <> 0, NUM, .NULL.) ALL 
BROWSE


Best Regards,

CriZ (,")

"We are the foxes, we are the runners, we are the dancers, we create the dreams."

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