August 25, 200817 yr I must be missing something very basic and peculiar to FMP but if I write a script that sets Set Variable $Client=ClientID and then set up a Perform Find in which it says ClientID=$Client I would expect results from this. Instead, I get "No records match this set of find requests" and I can see the $Client [with the $ sign] in the ClientID field. Can filemaker not deal with $vars in a search?? That seems too absurd to be true.
August 25, 200817 yr If this doesn't work... Set Variable [ $Client; Value:Untitled::ClientID ] Enter Find Mode [ ] Set Field [ Untitled::ClientID; $Client ] Perform Find [ ] ...is it somewhat of an surprice indeed! --sd
August 25, 200817 yr Author OH! THAT's the syntax?! I thought 'set field' was for just entering values in browse mode. i didn't realize i had to do that and THEN perform the find. Thanks! So in the "perform find: specify" dialog, can i only put fields and "text" in there...no $vars?
August 25, 200817 yr Author Sorry. I don't follow. So I can't put $ into those [restore] find requests? i always have to do the Find mode/set field/perform find sequence?
August 25, 200817 yr Not exactly true Barbara! Set Variable [ $myVar; Value:Untitled::aField ] Perform AppleScript [ Calculated AppleScript: "show every record whose cell 1 = "" & $myVar & """ ] --sd
Create an account or sign in to comment