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.
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
