>Hi is there other way were in I can assign the default connection of remote view at runtime? because I dont want to expose that password and username in DBC.And I dont want to see the ODBC login prompt either. I check on USE COMMAND , we can assign like user vMembers in [connection string | handle ] my problem is if i have 30 view do i have to issued this command? specila when my View are in the DE? thank
Hello Simplicio Jison
Usually I have separate database only for views ( remote views) and keep it near exe.
In this case we can use dbsetprop function for many sets we have to change
In you case you can use it for connection, used in your views
Set displogin=3
and set connectstring with password and user name you can make for selfmade
VFP form with user and password name
Check also all views will have share connection
Best wishes, Vladimir
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.