>>Hi Sarosh ----
>>
>>Hmmmm.....I just tested it on a local view and on a remote (SQL Server) view and you are right, it is blank for both VFP5 *and* VFP6.....
>
>Maybe it only works if you register the parameters. On the Query menu pad there's a paramerers something-or-other -- I don't have VFP available.
>
>-Mike

Hi Michael!

You are right. We 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'

Thanks guys.


Sarosh.