We have problem creating our forms based on back-end datasource.
Our setup...
Back-end : SQL Server 6.5, Contains table(s) and view(s).
Front-end : Visual Foxpro 5.0, Contains Remote View(s) based on SQL

At SQL end users have access to tables/views and some of users have access
to some specific fields only whereas the forms are accessible to all users.
We have noticed that if user does not have permission to any one of the fields
SQL returns an error.

How can we dynamically modify our view at run time, depending on what fields
user can see, without changing the original view.