Perform Find with $vars

[blissland]

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.

[Søren Dyhr]

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

[blissland]

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?

[Søren Dyhr]

You unload the $variable for what it carries!

--sd

[blissland]

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?

[bcooney]

Yes.

[Søren Dyhr]

Not exactly true Barbara!

Set Variable [ $myVar; Value:Untitled::aField ] 

Perform AppleScript [ Calculated AppleScript: "show every record whose cell 1 = "" & $myVar  & """ ] 

--sd

[bcooney]

Got me, Soren. I don't use a Mac, so I don't think about AppleScript.