<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML defanghtml_xmlns="http://www.w3.org/TR/REC-html40"
defanghtml_xmlns:m="http://schemas.microsoft.com/office/2004/12/omml"
defanghtml_xmlns:w="urn:schemas-microsoft-com:office:word"
defanghtml_xmlns:o="urn:schemas-microsoft-com:office:office"
defanghtml_xmlns:v="urn:schemas-microsoft-com:vml"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR>
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@page Section1 {size: 612.0pt 792.0pt; margin: 70.85pt 70.85pt 70.85pt 70.85pt; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman","serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
.MsoChpDefault {
mso-style-type: export-only
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!--[if gte mso 9]><!--<defanghtml_xml>
<defanghtml_o:shapedefaults v:ext="edit" spidmax="1026" />
</defanghtml_xml>--><![endif]--><!--[if gte mso 9]><!--<defanghtml_xml>
<defanghtml_o:shapelayout v:ext="edit">
<defanghtml_o:idmap v:ext="edit" data="1" />
</defanghtml_o:shapelayout></defanghtml_xml>--><![endif]--></HEAD>
<BODY lang=HR vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=557011016-19022007><FONT face=Arial
color=#0000ff size=2>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).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=557011016-19022007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=557011016-19022007><FONT face=Arial
color=#0000ff size=2>Orest.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Jason
Birch<BR><B>Sent:</B> Monday, February 19, 2007 10:53 AM<BR><B>To:</B> MapGuide
Users Mail List<BR><B>Subject:</B> RE: [mapguide-users] Accessing views/queries
in MS Access<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=131134515-19022007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=131134515-19022007><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=131134515-19022007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=131134515-19022007><FONT face=Arial><FONT
size=2><FONT color=#0000ff>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 "<SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">This submission modifies the Generic
Schema Manager to generate classes for views, by default, when connected to a
non-FDO datastore."</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=131134515-19022007><FONT face=Arial><FONT
size=2><FONT color=#0000ff><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=131134515-19022007><FONT face=Arial><FONT
size=2><FONT color=#0000ff><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Jason</SPAN></FONT></FONT></FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Campbell,
Keith A<BR><B>Sent:</B> Monday, February 19, 2007 06:48<BR><B>To:</B> MapGuide
Users Mail List<BR><B>Subject:</B> RE: [mapguide-users] Accessing views/queries
in MS Access<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=471254214-19022007>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.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=471254214-19022007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff size=2><SPAN
class=471254214-19022007>As a workaround, </SPAN></FONT><FONT face=Arial
color=#0000ff size=2><SPAN class=471254214-19022007>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.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT size=2><STRONG><SPAN
style="COLOR: green; FONT-FAMILY: Arial"></SPAN></STRONG></FONT> </DIV></BODY></HTML>