Hi,
I'm having a problem in VFP6 where SCATTER is not working corectly with a parameterized remote view.
The problem is that the 'm.varname' variable is not being created for the field where the filter parameter is applied.

Example:
SQL Server table
itemid int -> PK
itemname char 30
itemdesc varchar 100

CREATE SQL VIEW myview REMOTE CONNECTION 'SQL Connection' AS ;
SELECT * FROM dbo.Inv_items Inv_items ;
WHERE Inv_items.itemid = ?nItemIdFilter

SCATT MEMV
?m.itemname
The name of the item
?m.itemdesc
The description
?m.itemid
ERROR -> Variable "ITEMID" is not found

I did this in the command line alone to eliminate possible errors on my code and the problem persists.

Any ideas?

Thanks