Since a remote view uses ODBC, you won't be able to use the CAST() function as that's VFP9 specific. ODBC is still stuck at VFP6 support level.


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