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

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