>>>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.
>>
>>I guess you should use different view definitions (try to do it programmatically using e.g. CURSORSETPROP()) for different users depending on their security status (could be implemented as individual/group user accounts for VFP app).
>
>Thanx for the response,
> I have tried CURSORSETPROP but it does't work because the users has either full rights or part rights to the table at the back-end. So i am looking for a method by which i can select only those fields to which user is having rights.
here is a sugestion
use the code syntax for
create sql view remote connection shared as select
make one for each security level, store the code in a file with a memofield and run the code from the memofield when a user logs in and this will create the viw defined for that security level
Best
Allan