Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bebot Chan
  Where is Bebot Chan?
 Riyadh
 Saudi Arabia
 Bebot Chan
 To: Armin Kaminsky
  Where is Armin Kaminsky?
 Calgary
 Canada
 Armin Kaminsky
 Tags
Subject: RE: Empty Field
Thread ID: 22395 Message ID: 22415 # Views: 13 # Ratings: 0
Version: FoxPro 2.x for Windows Category: General VFP Topics
Date: Thursday, April 17, 2003 3:21:58 PM         
   


> 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
> GO TOP
>
> Sure would like some feed-back
>
> Thank You
>
> Armin

I'm not sure if its a typo but you seem to have an extra dot in your 3rd expression for the immediate IF. (TSN3.TSN3.dis_yards02).

Try this:

REPLACE ALL TSN3.dis_yards01 WITH ;
IIF (EMPTY(TSN3.dis_yards01),TSN1.distance,TSN3.dis_yards01)









COMPLETE THREAD

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