[FX.php List] Search a calculated field

[Rob H. Christensen]

Hi, 

I have a field in my database, which is set with a simple calculation:

Case ((Status="Archived);"Passive";(Status="Canceled);"Passive";"Active").

When I try to search the database to get a list of active records, I either
get nothing (Error 401) or I get a list of all files, whether the field is
set to "Active" or "Passive"

 $findListe=new FX($serverIP,$webCompanionPort,'FMPro5/6');
$findListe->SetDBData('Database.fp5','Layout',$groupSize);
$findListe->SetDBPassword($PASWORD,'');
$findListe->AddDBParam('Activity','Active',eq);
$findListe->AddSortParam($Sorter,'descend');
$findListe->FMSkipRecords($skipSize);
$findListeResult=$findListe->FMFind();

If I remove the "eq" I get 401 No record match...
If I set it as 
$findListe->AddDBParam('Activity','Passive',eq);
I get a list of all records.
If I add the field in the list, it shows the proper data for each record.
Why can't I search and get a list of Active records only?

Rob