>Hi,
>
> Thanks for your reply. Can i clerify something, if i use view, i only can use those function that are available in the backend databawse ( for eg, sql server). If the backend database not support, so even i use view also can not use the specific function like recno()
>
>regards,
>
>florence
Florence,
Depends on which part of RV you're talking about. If you're asking for its definition SQL you can only use SQL server functions. If you're asking for functions where you're using the view then you can use VFP functions. ie:
create sql view myView remote connection myConn as select ... where myDate < datetime() ...
wouldn't work as SQL server doesn't understand VFP function datetime() but understand getdate().
create sql view myView remote connection myConn as select * from Northwind.dbo.employees
use myDBC!myView
locate for hire_date > datetime(1998,5,1)
select * from myView where hire_date between gomonth(date(),-10) and date()
select * from myView where recno() between 3 and 5
...
works.
Cetin