Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view error
Message
 
 
To
02/11/2005 22:01:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01064818
Message ID:
01064820
Views:
17
What backend remote view connects to?

>I can create a local view
>
	CREATE SQL VIEW V_HOLSSTD_ALL AS ;
>		SELECT Holsstd.s_key, ;
>			Holsstd.descr, ;
>			Holsstd.day, ;
>			Holsstd.htype, ;
>			Holsstd.month, ;
>			Holsstd.dow, ;
>			Holsstd.wom, ;
>			Holsstd.adjust, ;
>			Holsstd.country, ;
>			Holsstd.region, ;
>			Holsstd.active, ;
>			CAST(IIF(day>0, day, wom*10+dow) AS N(2)) AS seq ;
>		FROM wots!holsstd ;
>		ORDER BY Holsstd.month, 12
>
>but when I try to create it as a remote view
>
	CREATE SQL VIEW V_HOLSSTD_ALL REMOTE CONNECTION rWots SHARE AS ;
>		SELECT Holsstd.s_key, ;
>			Holsstd.descr, ;
>			Holsstd.day, ;
>			Holsstd.htype, ;
>			Holsstd.month, ;
>			Holsstd.dow, ;
>			Holsstd.wom, ;
>			Holsstd.adjust, ;
>			Holsstd.country, ;
>			Holsstd.region, ;
>			Holsstd.active, ;
>			CAST(IIF(day>0, day, wom*10+dow) AS N(2)) AS seq ;
>		FROM wots!holsstd ;
>		ORDER BY Holsstd.month, 12
>
>I get a error odbc connectivity error - Function is missing ).
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform