Thanks again - Also one last question I was wondering if a particular bug in naport 6 was fixed
We run about 20 different porfiles against 26 different databases (making about 500 Inaport profiles that we run nightly). However when we upgraded from In5 to In6 we had one profile that gave erratic results in In6. So we left it in In5 at that time.
Now we are upgrading to Goldmine 8 and I have read in other posts that In5 is not compatible with GM 8 - so we will have to resolve the problem with this particular profile before we go forward. We currenly run the most recent release of In6 and still have the problem with this profile.
The Select statement is causing the problem - it works fine in In5 but not In6 - do you think In7 has fixed this problem
select * from ps_history where not exists
(select linkrecid from conthist where PS_HISTORY.gm_donation_id =
conthist.linkrecid) and PS_HISTORY.gm_date is not null