Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Rene Relucio
  Where is Rene Relucio?
 Quezon City
 Rene Relucio
 To: Armin Kaminsky
  Where is Armin Kaminsky?
 Armin Kaminsky
Subject: RE: Empty Field
Thread ID: 22395 Message ID: 22399 # Views: 1 # Ratings: 0
Version: FoxPro 2.x for Windows Category: General VFP Topics
Date: Thursday, April 17, 2003 9:01:25 AM         

> Hi
> Need HELP
> Have say 2 Datbases and the second one has some empty records that need filling
> So I am trying to replace ONLY the the empty ones with the records from the first
> But, like always it's not working.
> Where am I messing up?
> REPLACE TSN3.dis_yards01 WITH ;
> IIF (EMPTY(TSN3.dis_yards01),TSN1.distance, TSN3.TSN3.dis_yards01);
> All
> Sure would like some feed-back

REPLACE TSN3.dis_yards01 WITH ;
TSN1.distance for EMPTY(TSN3.dis_yards01)

REPLACE TSN3.dis_yards01 WITH ;
TSN3.TSN3.dis_yards01 for NOT EMPTY(TSN3.dis_yards01)

- Edison Nuguid, Phil.
> Thank You
> Armin


Empty Field Posted by Armin Kaminsky @ 4/17/2003 6:40:01 AM
RE: Empty Field Posted by Rene Relucio @ 4/17/2003 9:01:25 AM
RE: Empty Field Posted by Bebot Chan @ 4/17/2003 3:21:58 PM
Remember: EMPTY(.NULL.) = .F. Posted by Ken Blum @ 4/17/2003 3:37:22 PM
RE: Empty Field Posted by Armin Kaminsky @ 4/17/2003 4:25:03 PM