SQL views and Mapguide themeing

[Anonymous]

I am trying to set up Mapguide themes using an SQL view for the theme designations. I keep getting error 529-15602. My view has about 50 columns and 36000 records. Is the view too big? Do I need to break it down to get it to work properly. I have double checked my datasource and that seems to be set up okay. I keep getting the error that there is incorrect syntax near my database name. Any suggestions?

Thank you.
Joan Rickard
Information Systems Analyst
City of Walnut Creek
1666 N Main St
Walnut Creek, CA 94596
gis@walnut-creek.org
925-943-5800

[Anonymous]

Hi Rickard

Why donot try this , rather than having dataview create a table of this
dataview for testing sake only and try your thematic based on this table.

If it works than ask your DBA to optimize this view table by redusing the
number of unneccesary columns (Do you use all these columns for your
mapguide?)

If error persist than better check the way you use the columns , sometimes
it cause by sql syntax error or datatypes problems

Hopefully helps
snapple
"nickins" wrote in message
news:f18a306.-1@WebX.maYIadrTaRb...
> I am trying to set up Mapguide themes using an SQL view for the theme
designations. I keep getting error 529-15602. My view has about 50 columns
and 36000 records. Is the view too big? Do I need to break it down to get it
to work properly. I have double checked my datasource and that seems to be
set up okay. I keep getting the error that there is incorrect syntax near my
database name. Any suggestions?
> Thank you.
> Joan Rickard
> Information Systems Analyst
> City of Walnut Creek
> 1666 N Main St
> Walnut Creek, CA 94596
> gis@walnut-creek.org
> 925-943-5800
>