Set Variable [$counter; Value:1] Set Variable [$maxCounter; Value:Get(FoundCount)] Loop Set Variable [$theCheese; Value:GetNthRecord ( cheeses::cheeseName ; $counter )] Set Variable [$doIlikeIt; Value:GetNthRecord ( cheeses::IlikeIt ; $counter )] If [$doIlikeIt <> "Yes"] Set Variable [$cheeses; Value:List( $cheeses ; $theCheese )] End If Set Variable [$counter; Value:$counter + 1] Exit Loop If [GetAsNumber( $counter ) > GetAsNumber( $maxCounter )] End Loop Set Variable [$cheeseCount; Value:ValueCount( $cheeses )]
SELECT cheeseName FROM cheeses WHERE IlikeIt <> 'Yes'
SELECT cheeseName FROM cheeses WHERE IlikeIt <> 'Yes' OR IlikeIt IS NULL
SELECT cheeseName FROM cheeses WHERE IlikeIt = 'No' OR IlikeIt IS NULL
Soliant Consulting employs the largest FileMaker development team in the world. We have a deep bench of talent starting with our CEO, Bob Bowers: he's co-authored seven books, led the team that has written six editions of the Authorized Training Series for FileMaker, Inc., spoken at more than a dozen FileMaker Developer Conferences, and has taught literally thousands of students spanning two decades of leadership in the field. Certified Expertise Soliant's team is certified in every version of FileMaker Pro and are specialists in building high-performance databases, hybrid web-FileMaker applications, integrations with a range of technologies including SQL, and conversions from prior versions. We work with your solution as is or can build from scratch. Find out how we can take your FileMaker databases to the next level.Website: www.soliantconsulting.com/filemaker
- A FileMaker Bag of Goodies: ExecuteSQL, Named Buckets & more
- FileMaker Deployment, Security and SQL Webinar
- Doing a mass export of all data, using FileMakerâs native ExecuteSQL function
- A Handy FileMaker SQL Utility Script Select Builder
- FileMaker Custom Function Parameters: Value or Reference? An Example.