[mapguide-users] Accessing views/queries in MS Access

[Warren Medernach]

Should we not clarify this a bit though...
 
It is possible to get at a view...  just not through the Studio UI...
 
A view can be created by overriding the schema and pushing the XML
through the MapAgent..
 
See the following post:
http://www.nabble.com/I-can%27t-see-views-when-I-use-the-FDO-ODBC.-tf189
7275s16610.html#a5202964
 

   Warren Medernach

________________________________

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Orest
Halustchak
Sent: Monday, February 19, 2007 10:14 AM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Accessing views/queries in MS Access


Yes, this is something that we're looking at for the FDO ODBC provider -
mapping a class to an existing query in MS Access (as well as view
support for other providers).
 
Orest.

________________________________

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jason Birch
Sent: Monday, February 19, 2007 10:53 AM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Accessing views/queries in MS Access


 
There is a limited case where you can access views, but only if you are
using MapGuide Open Source with the King.Oracle provider and an Oracle
database.
 
If you're not using this combination there is no current solution, but
it looks like future releases of FDO may support these.  Last week a
code revision was posted entitled "Change 2519: Reverse engineer views
by default", with the description "This submission modifies the Generic
Schema Manager to generate classes for views, by default, when connected
to a non-FDO datastore."
 
Jason

________________________________

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Campbell,
Keith A
Sent: Monday, February 19, 2007 06:48
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Accessing views/queries in MS Access


You cannot access views in any database with MapGuide Open Source or
Enterprise as you could in the old MapGuide 6.x, etc. This is a big
shortcoming in my opinion, but I believe there may be support for them
in future.
 
As a workaround, we have data in SQL Server linked to SDF files in an
MGOS implementation - we use stored procedures in SQL Server to
create/update tables instead of using views. This approach may be
difficult in other situations depending on how your overall application
is structured.
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070219/4a222b51/attachment.html