<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=061103018-31102006><FONT face=Arial
color=#0000ff size=2>I stand corrected (yet again)...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=061103018-31102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=061103018-31102006><FONT face=Arial
color=#0000ff size=2>I don't see the datetime fields either in Studio with a SQL
Server join. I happened to be looking at a feature source that was still
connected to an Access join...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=061103018-31102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=061103018-31102006><FONT face=Arial
color=#0000ff size=2>Sorry for any confusion I might have
caused.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=061103018-31102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=061103018-31102006><FONT face=Arial
color=#0000ff size=2>Warren</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> Campbell, Keith A
[mailto:keith.campbell@atkinsglobal.com] <BR><B>Sent:</B> Tuesday, October 31,
2006 5:01 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=234435510-31102006><FONT face=Arial
color=#0000ff size=2>The fields aren't even showing up in Studio. I am puzzled
by this as I thought I'd established that DateTime fields were a problem, but
smallDateTime weren't. However, the SmallDateTime fields aren't showing up
either now, and I've not changed anything on the database
side.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=234435510-31102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=234435510-31102006><FONT face=Arial
color=#0000ff size=2>BTW, is your SQL database 2005? I'm running a 2000 version
and I wonder if some problems may be version related.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=234435510-31102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=234435510-31102006><FONT face=Arial
color=#0000ff size=2>Keith</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> Warren Medernach
[mailto:warren.medernach@imaginit.ca] <BR><B>Sent:</B> 30 October 2006
19:49<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=098484519-30102006><FONT face=Arial
color=#0000ff size=2>Maybe I replied too soon,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=098484519-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=098484519-30102006><FONT face=Arial
color=#0000ff size=2>The 'field' is showing up in Studio, but if that field is
included in the search results, it doesn't display anything.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=098484519-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=098484519-30102006><FONT face=Arial
color=#0000ff size=2>Maybe that's what you were indicating
Keith?</FONT></SPAN></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=098484519-30102006><FONT face=Arial color=#0000ff
size=2>Warren</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> Warren Medernach
[mailto:warren.medernach@imaginit.ca] <BR><B>Sent:</B> Monday, October 30, 2006
1:37 PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=868563519-30102006><FONT face=Arial
color=#0000ff size=2>Hmm, that's interesting... the datetime fields I have
in this dbase are showing up in Studio?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=868563519-30102006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=868563519-30102006><FONT face=Arial
color=#0000ff size=2>Warren </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> Campbell, Keith A
[mailto:keith.campbell@atkinsglobal.com] <BR><B>Sent:</B> Monday, October 30,
2006 11:40 AM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SQL Server Provider vs. FDO Provider for a feature
join...<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=411203817-30102006><FONT face=Arial
color=#0000ff size=2>On a similar note, SQL Server DateTime and SmalDateTime
type fields don't show up in Studio (although the tables
do).</FONT></SPAN></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Arial
color=#0000ff size=2></FONT> </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/?4318150"><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><A
href="http://www.blackspider.com/"><FONT style="BACKGROUND-COLOR: #ffffff"
color=#000000></FONT></A></P></BODY></HTML>