remote view with parameter

[peterf]

When I create a remote view (MS Access) with a parameter filter (ie ?mParameter), the remote view works correctly, but I am unable to subsequently modify the remote view. An error message informs me there is a 'Syntax Error'. There is no error message when I do not use a filter.

Any suggestions

Thanks

Peter

 

[wgcs]

try creating the variable (that is the parameter) at the command line, then modifying the remote view.

 

[peterf]

From Peter,

No, that does not make any difference.

Further investigation shows with a sql query (auto generated by the remote view designer) as follows :

SELECT *;
FROM "Daily ODP Detail" Daily_odp_detail;
WHERE Daily_odp_detail."Employee Id" = ?mEmp;
AND Daily_odp_detail.Quantity > ?mQty

The syntax error occurs with the Employee Id parametized filter but not with the Quantity Filter. The former being a character field, the latter a numeric. The syntax error will also occur with a date type field.

Thanks for your help.

Peter

 

[rgbean]

Peter,
Instead of using VFP's native View editor, consider using ViewEditor available (for free) at

http://www.geeksandgurus.com/vfptools/vieweditor.htm.

It's rumoured that a variant (or look alike) of this will be included in "Toledo", the next VFP.

Rick

 

[danceman]

when are you setting the filter?

is the error after the initial query? and happens when you set a filter? Attitude is Everything

 

[MCTCO]

whats your update code?