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

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