All,

Not sure what's wrong with the following. Trying to create a remote view and it doesn't like the desc even though it as an AS clause next to it.

Please help.

	LOCAL lcScript
	IF USED("ALLPAIS")
		SELECT ALLPAIS
		USE
		DROP VIEW ALLPAIS
	ENDIF
	lcScript = ""
	lcScript = "CREATE SQL VIEW ALLPAIS CONNECTION conPAIS as SELECT PAIS_opord2.allocqty, PAIS_opord2.ualocqty, PAIS_mascrd.payname, PAIS_minve.cstock, PAIS_pomas.jobnum,"
	lcScript = lcScript + "	PAIS_minve.itemnum, PAIS_minve.size AS minveSize, PAIS_minve.desc AS minveDescrip, PAIS_pomas.qtyorder"
	lcScript = lcScript + "	FROM PAIS_pomas LEFT OUTER JOIN	PAIS_minve ON PAIS_pomas.itemnum = PAIS_minve.itemnum LEFT OUTER JOIN" 
	lcScript = lcScript + "	PAIS_mascrd ON PAIS_pomas.vendnum = PAIS_mascrd.vendnum LEFT OUTER JOIN"
	lcScript = lcScript + " PAIS_opord2 PAIS_opord2 ON PAIS_pomas.jobnum = PAIS_opord2.jobnum"
	lcScript = lcScript + " WHERE PAIS_pomas.jobnum = " + ALLTRIM(STR(Session.jobnum))
	EXECSCRIPT(lcScript)