<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML dir=ltr><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE>font-face {
        FONT-FAMILY: Tahoma
}
P.MsoNormal {
        FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
        FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
        FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
        COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
        COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
        COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
        COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
        COLOR: windowtext; FONT-FAMILY: Arial
}
SPAN.EmailStyle18 {
        COLOR: navy; FONT-FAMILY: Arial
}
DIV.Section1 {
        page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=898214013-05102006><FONT face=Arial
color=#0000ff size=2>SQL Server provider is read-write. There should not
be any problem writing data back.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=898214013-05102006><FONT face=Arial
color=#0000ff size=2>You would probably have to create a class for the redlined
data and use the standard FDO feature commands against it. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=898214013-05102006><FONT face=Arial
color=#0000ff size=2>In case this doesn't fit with your db setup for some
reason, remember that there is always the SQL pass through command that you can
use and just pass SQL statement. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=898214013-05102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=898214013-05102006><FONT face=Arial
color=#0000ff size=2>It's probably better to get the first approach to
work...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=898214013-05102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=898214013-05102006><FONT face=Arial
color=#0000ff size=2>RF</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> Lockyer James
[mailto:James.Lockyer@bradford.nhs.uk] <BR><B>Sent:</B> Thursday, October 05,
2006 3:50 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server 2005<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=idOWAReplyText18349 dir=ltr>
<DIV dir=ltr><SPAN lang=en-gb><FONT face=Arial size=2>Robert</FONT></SPAN></DIV>
<DIV dir=ltr><SPAN lang=en-gb><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV dir=ltr><SPAN lang=en-gb><FONT face=Arial size=2>Thanks.... Think my
brain might have gone into overload now... will bring it back on line in a
mo.</FONT></SPAN></DIV>
<DIV dir=ltr><SPAN lang=en-gb><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV dir=ltr><SPAN lang=en-gb><FONT face=Arial size=2>Out of interest, as I have
managed to create an SQL datastore that can be seen by Mapguide Enterprise/OS is
it possible to save redlined data to the datastore through the standard FDO-SQL
provider, or is the provider only capable of reading data from the SQL
database.</FONT></SPAN></DIV>
<DIV dir=ltr><SPAN lang=en-gb><FONT face=Arial size=2></FONT></SPAN> </DIV>
<DIV dir=ltr><SPAN lang=en-gb><FONT face=Arial
size=2>Jim</FONT></SPAN></DIV></DIV>
<DIV dir=ltr><BR></DIV></BODY></HTML>