Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View to MySQL database
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Vista
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01352722
Message ID:
01352839
Views:
29
Hi Victor,

Yes, from what I have able to determine thus far, it does seem as if MySQL is performing a query on the backend. With that in mind I tried setting the the view's parameter to a value that would quickly hit the index and result in no matching records, however that did change anything so while a select seems to be occurring it appears that the parameter of the view has nothing to do with it.

I had considered not destroying the DBC that holds the views, when the user exits the app, so that I only pay the penalty for the delay creating those views once, but that leaves behind a container file that can be examined to reveal user logins and passwords etc.

It would seem that there must be a solution to this, somewhere......??????

Alec
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform