> 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)