Macro substitution syntax

[bsutton55]

I am struggling with some macro substitution syntax.
I have a label which has the following property "cfilter" set to "SET FILTER TO MYTABLE.ACCEPTED" where the ACCEPTED field is Logical.

The code in the doubleclick event is

&this.cfilter

I am getting unrecognised command verb.

What am I doing wrong?
Thanks
Barry Sutton.

 

[Olaf Doschke]

In short: You can't use a property for macro substitution. The macro has to be in a string variable, nothing else works. With your code VFP would expect a variable named "this", which doesn't and can't exist, but only variables are used for substution. So do it this way:

Local lcMacro
lcMacro = This.cFilter
&lcMacro.

Bye, Olaf.

 

[DSummZZZ]

The label contains that (cfilter) property? Or is it the caption?
If it's the label itself, in the doubleclick event you could do something like:

STORE STRTRAN(This.cfilter, "SET FILTER TO", "") TO  cFilter
SET FILTER TO &cFilter

If it's the caption, use instead:

STORE STRTRAN(This.Caption, "SET FILTER TO", "") TO cFilter
SET FILTER TO &cFilter

-Dave Summers-

Even more Fox stuff at:

http://www.dave-summers.net/foxprolinks.htm

 

[bsutton55]

Olaf/Dave
Thank you both. Now working.
Barry