Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CSavedFilterTable
Message
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00759037
Message ID:
00759425
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform