Doug,

Thanks for the reply. I was looking at the OpenFilt method yesterday and thinking about the possibility of creating a filters table in the SQL database. I appreciate your advise and if I decide to go this way, I'll let you know how it works.

Kind Regards,

Mat

>Hi Mat.
>
>>The problem is that now we have several installations that are employing Citrix with our SQL Server version of the product. Since all of the application data is stored in a SQL database, the clients are questioning why the users need write access to the application server or citrix server. Has anyone else had to deal with this issue? If the system admin takes away write access, then attempting to save a filter generates an error.
>
>I haven't tried this, but you could create a filters table in SQL Server and modify Stonefield Query to use that table rather than a native VFP one. The code you'd have to modify is in SFGetFilter.OpenFilt and StoreFilter. OpenFilt would use SQLEXEC to create a cursor of stored filters and StoreFilter would use SQLEXEC to write changes back to the SQL table. Alternatively, you could use a remote view.
>
>Doug