Hi,

I posted a message regarding this problem several weeks ago. I am having another look at the problem again now, and still now success.

Here again is my problem:


I have a program that merges data from various external sources. I am experiencing this problem with just one section of the program.

Here is my code:

***************************************************************
select process
Wait Window "EI - Merging EI Data with Central CATS..." NoWait
Scan
scatter to Aarr_pro memvar
sin_m = sin
bpc_m = bpc
select loclaim
seek(sin_m+bpc_m)
If found()
scatter to Aarr_master memvar
If ThisFormSet.Changes(@Aarr_pro, @Aarr_master, 49)
Gather from Aarr_pro memvar
Replace Dnld_Stat with 1, Dnld_Date with Date(), Lc_Action with ",;
Lc_Time with TIME(), Lc_Date with DATE(), Lc_User with "INE"
LoUpRecs=LoUpRecs+1
Endif
Else
Append blank
Gather from Aarr_pro memvar
Replace Dnld_Stat with 1, Dnld_Date with Date(), Lc_Action with A",;
Lc_Time with TIME(), Lc_Date with DATE(), Lc_User with "INE",;
Add_Date with DATE(), Add_Time with TIME(), Add_User with "INE"
LoAddRecs=LoAddRecs+1
Endif
Endscan

If the record is found, it gathers from the array (which contains the contents of the process record). Three fields that exist in the loclaim table are Add_Date, Add_time and Add_user. These fields have a value inserted when they are added to the table (as you can see from the above code). They don't exist in the process table. When the gather from Aarr_pro takes place, it replaces the Add_Date, Add_time and Add_user fields with blank.

There are other sections of my program that follow the same type of process when updating our central database and pretty much perform the same type of action and those add_* fields don't get modified on the gather. Any idea on why this is happening? Any suggestions on how to fix it?

Thanks alot.

Jolene Dicks