Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Armin Kaminsky
  Where is Armin Kaminsky?
 Calgary
 Canada
 Armin Kaminsky
 Tags
Subject: Empty Field
Thread ID: 22395 Message ID: 22395 # Views: 21 # Ratings: 0
Version: FoxPro 2.x for Windows Category: General VFP Topics
Date: Thursday, April 17, 2003 6:40:01 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
GO TOP

Sure would like some feed-back

Thank You

Armin

COMPLETE THREAD