[mapguide-users] OSGeo FDO problem...

[Andrew DeMerchant]

I'd love to try that, but where do I have that option? I'm using 
Studio...I see no place to either use an SQL statement of my own, or to 
put anything (let alone quotes) around a table name.

Andrew

Robert Fortin wrote:

> Andrew,
>  
> Have you tried using single quote around you table name/column?
>  
> RF 
>
> ------------------------------------------------------------------------
> *From:* Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca]
> *Sent:* Wednesday, June 28, 2006 9:24 AM
> *To:* users at mapguide.osgeo.org
> *Subject:* [mapguide-users] OSGeo FDO problem...
>
> It seems that the OSGeo FDO provider doesn't like spaces in table 
> names. The error log said that the FDO was causing a "Syntax error in 
> FROM clause". Is this something that can be fixed? It should be a 
> pretty simple fix, really..since I'd guess that all that needs to be 
> done is to enclose table names (and field names, for that matter) in 
> square brackets (ie, [Table Name], or [Table Name].[Field Name]). The 
> work around for me for now is to make another Access database and link 
> all of the tables from my real database. In this new database, I just 
> rename the tables to get rid of the spaces. But I can't really rely on 
> his workaround, because having to change table names means changing a 
> lot of other things for other projects (this database is used in a lot 
> of other ways, not just MapGuide). Is there any chance that this FDO 
> can get modified to account for these spaces?
>
> Andrew
>
> -- 
> 	*Andrew DeMerchant*
> *Computer Technologist*
> ph.1-877-4GEMTEC x.163
> fax 506-453-9470
>
> /GEMTEC Limited <http://www.gemtec.ca>
> /191 Doak Road
> Fredericton, NB, Canada
> E3C 2E6
>

-- 
	*Andrew DeMerchant*
*Computer Technologist*
ph.1-877-4GEMTEC x.163
fax 506-453-9470

/GEMTEC Limited <http://www.gemtec.ca>
/191 Doak Road
Fredericton, NB, Canada
E3C 2E6

-------------- next part --------------
Skipped content of type multipart/related