>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()
>
Yes, it's correct. The query part of a view is executed on the backend. SQL Server wouldn't know what to do with RECNO().