[FX.php List] Search a calculated field

Rob H. Christensen robhelleshoj at tiscali.dk
Sun Mar 12 04:51:05 MST 2006


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




More information about the FX.php_List mailing list