>I am using the following command for a remote view.
>
> create SQL VIEW myview REMOTE CONNECTION myconnection AS ;
> SELECT *;
> FROM database.table1 table1, ;
> database.table2 table2 ;
> WHERE table1.field1 = table2.field2
>
>I would like to change the WHERE statement in :
>
> WHERE table1.field1 = table2.field2 and ;
>
> table1.field3 > m.avalue
>
>m.avalue is a memory vaiable containing an integer.
>
>This doesn't work .
>If anybody has a solution, thanks in advance.
>
>Sena
Sena,
Use parameterized view.
WHERE table1.field1 = table2.field2 and table1.field3 > ?m.avalue
You could then populate m.avalue anywhere and requery (most likely you'd use "nodataonload =.t.")
Cetin