by ChuckFlowers » Wed Dec 14, 2011 11:05 am
In recently using the trial version of VPME, I used the CursorAdapter.
The server tables were all available for use in the CursorAdapter, but server views were not visible.
I have used VFP remote views in the past; can't remember if server views showed up or not.
I plan to try out VPME with VFP remote views soon to see if the server tables show up there there.
I also plan to try at some point and see if MS SQL Server views show up as virtual server tables in VFP.
I just don't have it set up right now to test.
It is supposed to be considered good db server security practice to not allow access directly to tables, only to views.
Or even better, stored procedures (for the big boys, anyway).
Initial thought was that large corporate accounts wouldn't allow VFP coders access to their tables.
And maybe why lots of people had to move on to Visual Studio ?
As far as my VFP experience level, I have been a database hobbyist since 1984, first FileMaker on the Mac then FoxPro on the Mac and on MS-DOS; now making a concerted effort to make the transition to expert.
Have put together a couple of small, minimalist apps in VFP.
I feel comfortable that I am not over my head in this conversation. Not yet, anyway.
BTW, FileMaker will ask if you want to access tables only, or include server views.
Supposed to work with MySQL, Oracle, and MS SQL Server.