VFP database. Preparing for upgrade.

Regards
Geoff Scott

>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 ).
>>