Daniel,
I found the following on MS knowledge base.
parameter = "Ringer"
CREATE SQL VIEW test REMOTE CONNECT myconnect AS ;
SELECT * FROM authors WHERE authors.au_lname = ?parameter
You can pass it a parameter. It works in my situation..
Again, thanks for all your help
Roland
==============================================================================
>Roland,
>
>I don't have a solution for remote views since I don't use them. In case you could use SQL passthrough, the following line should work:
>
>
>SQLEXEC(lnSql, "SELECT whatever FROM MyTable WHERE DATEDIFF(day, BirthDate, getdate()) = 0")
>
>
>As Vlad mentioned, you need to use functions supported by SQL Server (T-SQL) when using SPT.
>
>This is different with remote views. I thought one of the advanteges of remote views was that you can define a view that works with different backends. Therefore I suspect above syntax won't work for RVs. Maybe an expert on remote views can chime in?
>
>>Hi,
>>
>>I am trying to create a filtered remote view using the view designer.
>>
>>FILTER by:
>>
>>dbf.birthdate (This is a SQL DATETIME field) = Today's date
>>
>>Heres what I would like to use.
>>
>>TTOD(dbf.birthdate) = DATE(); but that does not seem to work.
>>
>>I am trying to select records that the birthdate((DATETIME)only the date part) is equal to today's date. I don't know how to express the above to get the view designer to accept the required filter.
>>
>>Could someone please explain the proper usage to accomplish the above filtering.
>>
>>Thanks in advance!
>>Roland