<!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=iso-8859-2">
<META content="MSHTML 6.00.2900.2722" 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><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 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>Regards,</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>Keith</SPAN></FONT></DIV><FONT face=Arial color=#0000ff
size=2></FONT><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>Ivan
Milicevic<BR><B>Sent:</B> 19 February 2007 12:03<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 class=Section1>
<P class=MsoNormal><SPAN
defanghtml_style='font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D'>Anyone
know aboout this?<O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN
defanghtml_style='font-size:11.0pt;font-family:"Calibri","sans-serif"; color:#1F497D'><O:P></O:P></SPAN></P>
<DIV
defanghtml_style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<P class=MsoNormal><B><SPAN lang="EN-US"
defanghtml_style='font-size:10.0pt;font-family: "Tahoma","sans-serif"'>From:</SPAN></B><SPAN
lang="EN-US"
defanghtml_style='font-size:10.0pt; font-family:"Tahoma","sans-serif"'>
mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Ismael
Cams<BR><B>Sent:</B> 15. veljača 2007 10:04<BR><B>To:</B>
mapguide-users@lists.osgeo.org<BR><B>Subject:</B> [mapguide-users] Accessing
views/queries in MS Access<O:P></O:P></SPAN></P></DIV>
<P class=MsoNormal><O:P></O:P></P>
<DIV>
<P class=MsoNormal>Hello everyone,<O:P></O:P></P></DIV>
<DIV>
<P class=MsoNormal><O:P></O:P></P></DIV>
<DIV>
<P class=MsoNormal>is there any chance to make use of queries/views in MapGuide.
I am especially interested in making data connections towards a query
(view) in MS Access. The data I need is stored in different tables and
therefore I need this view. In MapGuide 6.5 it was not a problem to access
views.<O:P></O:P></P></DIV>
<DIV>
<P class=MsoNormal>If not possible, is there any workaround
?<O:P></O:P></P></DIV>
<DIV>
<P class=MsoNormal><O:P></O:P></P></DIV>
<DIV>
<P class=MsoNormal>Thanks in advance.<O:P></O:P></P></DIV>
<DIV>
<P class=MsoNormal><O:P></O:P></P></DIV>
<DIV>
<P class=MsoNormal><O:P></O:P></P></DIV></DIV><BR><BR><FONT
style="BACKGROUND-COLOR: #ffffff">
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">This message has been
scanned for viruses by </FONT><A
href="http://bluepages.wsatkins.co.uk/?6875772"><FONT
style="BACKGROUND-COLOR: #ffffff"
color=#000000>MailControl</FONT></A></P></FONT><br><br>
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff" color=#ff0000><STRONG><FONT color=#000000>This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding</FONT>.</STRONG></FONT></P>
<P align=center><STRONG>The ultimate parent company of the Atkins Group is WS Atkins plc. Registered in England No. 1885586. Registered Office Woodcote Grove, Ashley Road, Epsom, Surrey KT18 5BW.</STRONG></P>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt" align=center><SPAN style="FONT-SIZE: 18pt; COLOR: green; FONT-FAMILY: Webdings">P</SPAN><FONT size=2><SPAN style="COLOR: navy"> </SPAN><STRONG><SPAN style="COLOR: green; FONT-FAMILY: Arial">Consider the environment.</SPAN></STRONG><SPAN style="COLOR: blue"> </SPAN><STRONG><SPAN style="COLOR: green; FONT-FAMILY: Arial">Please don't print this e-mail unless you really need to.</SPAN></STRONG></FONT></P>
</body></HTML>