>In all of my adventures with VFP views (tool construction etc.) , I have never seen this work. Luckily, I have never had a need for it.

Hi Erik!

Yes, It does work but you have to register the parameters. To do this we have to open the View Designer then select the "Query" Menu and then select the "View Parameters..." option and then insert the required parameters.

Do not include "?m.id_customer" as a parameter (without quotes) just "id_customer" (without quotes) if you put the "m." prefix then it truncates everything after the "." period.

The DBGETPROP("v_customer","view","ParameterList") looks at this list and returns a ";" semicolon delimited string if there is more than one parameter.

e.g. return string for one parameter
id_customer,'I'

e.g. return string for two parameters
id_item,'I';id_item_no,'I'


Sarosh