[mapguide-users] I can't see views when I use the FDO/ODBC.

[Luiz Marcio Viana]

...'Views' are the same than 'Queries' in MSAccess.

MapGuide 6.5 can use Views/Queries to represent Point Geometry or a 
Secundary Table,
but I can't do it with MapGuide Open Source and FDO/ODBC.

I think this is a limitation of open source version. Is it right?
Does this problem occour with the new MapGuide Enterprise?

Thanks,
Luiz Marcio

----- Original Message ----- 
From: "Andy Morsell" <amorsell at spatialgis.com>
To: <users at mapguide.osgeo.org>
Sent: Thursday, July 06, 2006 1:24 AM
Subject: RE: [mapguide-users] I can't see views when I use the FDO/ODBC.


>I switched my nomenclature around, they are Queries in Access and Views in
> Oracle and SQL Server.  It would be nice if even Microsoft called them the
> same thing between their different database programs..........
>
>
> Andy
>
> -----Original Message-----
> From: Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca]
> Sent: Wednesday, July 05, 2006 7:41 PM
> To: users at mapguide.osgeo.org
> Subject: Re: [mapguide-users] I can't see views when I use the FDO/ODBC.
>
> Ah....I've never heard it called a View before.
>
> Andy Morsell wrote:
>> A view is a query definition within the Access database itself.  There
>> are several types of views, but in this case, it would be a select
>> view where either a single table is filtered or two or more tables are
>> joined on a common key.  Views are very common.  They are called
>> Queries in SQL Server and Views in Oracle.
>>
>>
>> Andy
>>
>> -----Original Message-----
>> From: Andrew DeMerchant [mailto:andrew.demerchant at gemtec.ca]
>> Sent: Wednesday, July 05, 2006 2:47 PM
>> To: users at mapguide.osgeo.org
>> Subject: Re: [mapguide-users] I can't see views when I use the FDO/ODBC.
>>
>> What exactly are you trying to look for other than a table? What's a
> 'view'?
>> Do you mean a 'form'? ODBC connections will only let you access
>> tables. No forms, no reports, etc....
>>
>> Andrew
>>
>> Luiz Marcio Viana wrote:
>>
>>> Hi,
>>>
>>> I'm trying to see views in MapGuide Studio, using the FDO/ODBC, but I
>>> see only the tables.
>>> I'm using the MS Access database and the last versions of MapGuide
>>> Open Source and MapGuide Studio Preview.
>>>
>>> Are there any problem with FDO/ODBC to publish views?
>>> I know FDO/ODBC works only with MS Access. Is It right?
>>>
>>> Thanks,
>>> Luiz Marcio
>>>
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>>> For additional commands, e-mail: users-help at mapguide.osgeo.org
>>>
>>>
>>>
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>> For additional commands, e-mail: users-help at mapguide.osgeo.org
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>> For additional commands, e-mail: users-help at mapguide.osgeo.org
>>
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org