[mapguide-users] Mapguide 3.0 Postgre view problem

[sebafr]

Hi,

I had the same problem here and really complex views do not work in the
guide
One solution is to use a function to get fields from the second table

CREATE OR REPLACE FUNCTION public.guide_generic_search_table(vfield
character varying, vNameTable character varying, vfilter character varying)
  RETURNS character varying AS
   $BODY$
	DECLARE
		v_out character varying;
		cSQL character varying;
	BEGIN
	   cSQL := 'SELECT '||vfield||' FROM '||vNameTable||' WHERE '||vfilter ||
';';
           EXECUTE cSQL INTO v_out;
	   return (v_out);
	END;
   $BODY$
  LANGUAGE plpgsql 

This way you cheat the mapguide, but it works!

[]s





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-3-0-Postgre-view-problem-tp5298765p5298792.html
Sent from the MapGuide Users mailing list archive at Nabble.com.