$result = $find->execute(); echo '<span style="color:green">SUCCESS</span>' . PHP_EOL . PHP_EOL; echo 'Check result consistency...' . PHP_EOL; echo 'Record count... '; $count = $result->getFetchCount(); echo 'Expected 1, returned ' . $count . '... ' . ($count == 1 ? '<span style="color:green">SUCCESS</span>' : '<span style="color:red">FAIL</span>') . PHP_EOL . PHP_EOL; echo 'Record total count... '; $count = $result->getFoundSetCount(); echo 'Expected 2, returned ' . $count . '... ' . ($count == 2 ? '<span style="color:green">SUCCESS</span>' : '<span style="color:red">FAIL</span>') . PHP_EOL . PHP_EOL; echo 'Try to get First Record... '; $record = $result->getFirstRecord(); echo ($record instanceof \tranduchieu\FileMaker\Object\Record ? '<span style="color:green">SUCCESS</span>' : '<span style="color:red">FAIL</span>') . PHP_EOL . PHP_EOL; echo 'Check if expected record (ID = 2)... '; echo 'returned ' . $record->getField('id') . '... ' . ($record->getField('id') == 2 ? '<span style="color:green">SUCCESS</span>' : '<span style="color:red">FAIL</span>') . PHP_EOL . PHP_EOL; echo 'Test Create CompoundFind... '; $request = $fm->newCompoundFindCommand($layout->getName()); echo '<span style="color:green">SUCCESS</span>' . PHP_EOL . PHP_EOL; echo 'Test Create FindRequets... '; $findReq1 = $fm->newFindRequest($layout->getName()); $findReq1->addFindCriterion('id', '1'); $findReq2 = $fm->newFindRequest($layout->getName()); $findReq2->addFindCriterion('id', '2...4'); $findReq3 = $fm->newFindRequest($layout->getName()); $findReq3->addFindCriterion('id', '3...4'); $findReq3->setOmit(true); echo '<span style="color:green">SUCCESS</span>' . PHP_EOL . PHP_EOL; echo 'Add FindRequets to compoundFind... '; $request->add(1, $findReq1); $request->add(2, $findReq2); $request->add(3, $findReq3); echo '<span style="color:green">SUCCESS</span>' . PHP_EOL . PHP_EOL;