Infrastructure Map Server Developer

Infrastructure Map Server Developer

Reply
Contributor
nickins
Posts: 12
Registered: ‎10-02-2003
Message 1 of 2 (74 Views)

SQL views and Mapguide themeing

74 Views, 1 Replies
09-15-2003 01:01 AM
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
*Snapple
Message 2 of 2 (74 Views)

Re: SQL views and Mapguide themeing

09-24-2003 12:28 PM in reply to: nickins
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
>
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.