Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir H.
  Where is Samir H.?
 Yogyakarta
 Indonesia
 Samir H.
 To: mohammed qasem
  Where is mohammed qasem?
 amman
 Jordan
 mohammed qasem
 Tags
Subject: RE: .NULL.
Thread ID: 288987 Message ID: 288990 # Views: 49 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Monday, December 27, 2010 3:53:20 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


You mean replace NULL with 0?
scan for isnull(f28)
  repl f28 with 0
endscan


... or replace 0 with null? -> make sure the field f28 accepts NULL.

Regards
Samir

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