Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view won't load in EXE
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00525921
Message ID:
00525957
Views:
14
You may want to check the view's SQL statement. I have seen views that fail because they don't have the 'dbo.' embedded on them or some other type of ownership that SQL requires to validate access to the table.

Try the following command in a view that works and in a view that does not work to see if you can spot the problem.
_cliptext=dbgetprop('yourdbc!yourview','view','sql')
modi comm
CTRL+V
>Any ideas why a single remote view would fail to load when the EXE is run from the desktop shortcut but load properly when the same EXE run from VFP? Other remote views from the same SQL database on this form load properly. This table was added to the SQL database Thursday; the SQL DBA insists this table has the same rights and user settings as all others.
Hector Correa
Previous
Reply
Map
View

Click here to load this message in the networking platform