>>Bhavbhuti,
>>
>>What result would you get if you access the view from VFP using SPT?
>
>Sorry but what is SPT?
>
SPT - SQL Path-Through. You connect to the data source using the SQLCONNECT( ) or SQLSTRINGCONNECT( ) function and send SQL statement to a backend using SQLEXEC( ) Function.