>Than it's PHDBase problem. It's not surprising because PHDBase hasn't been supported for years. I think it's time for you to look for some alternative solutions.

In the test I did today, I created another table with the one million records. I then use the PHD('IXADD') approach instead to bypass that bug. So, it took over an hour to index each record at a time. Then, I run a search. No matter what I enter, I get 0 result. Talk about that. The PHD index is close to 100 meg. But, that seems to make it bug as it is too big. So, that approach is a no go as well. The only think workable so far with that technology is the way I have it now.