<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:#1F497D;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:#1F497D;}
span.EmailStyle25
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle26
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle27
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:#1F497D;}
span.EmailStyle28
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:#1F497D;
font-weight:normal;
font-style:normal;}
span.EmailStyle29
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle30
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:#1F497D;
font-weight:normal;
font-style:normal;}
span.EmailStyle31
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>So, jus to be clear,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I should always be able to use ‘Lower’
because it is either supported in the provider or supported by the expression
engine?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="_x0000_i1030" src="cid:image001.png@01CA1A9C.44796FF0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson</span><span
style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Thomas Knoell<br>
<b>Sent:</b> Tuesday, August 11, 2009 6:51 AM<br>
<b>To:</b> 'FDO Users Mail List'<br>
<b>Subject:</b> RE: [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Hi Chris,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Sorry for the late response. Not sure if this is still an issue
for you, but just in case, FDO_FUNCTION_LOWER is defined in the file
IExpressionCapabilities.h in the unmanaged part (Fdo\Unmanaged\Inc\\Fdo\Connections\Capabilities)
only, hence it appears that it is not available in the managed code. It is
defined as follows:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Courier New"'>#define
FDO_FUNCTION_LOWER L"Lower"</span><span
lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Maybe using the string the constant is set to solves your
issues.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'> Thomas<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Chris Erickson<br>
<b>Sent:</b> August-06-09 11:03 AM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> RE: [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Thanks for your help.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>In the managed api, where is
FDO_FUNCTION_LOWER?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="_x0000_i1025" src="cid:image001.png@01CA1A9C.44796FF0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'><a
href="mailto:chris@cartopac.com">chris@cartopac.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.493.9500 x
191<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.482.1485
(fax)</span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Thomas Knoell<br>
<b>Sent:</b> Friday, July 31, 2009 1:10 PM<br>
<b>To:</b> 'FDO Users Mail List'<br>
<b>Subject:</b> RE: [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Hi Chris,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>If a provider indicates that it does not support an expression
function, then this is independent of whether or not there is native support
for it. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>The ArcSDE provider gets the list of supported functions from
the Expression Engine and hence will include the function LOWER as a supported
function. If a function is in the list that is not natively supported the
provider will redirect the request to the Expression Engine to handle it. To
see all supported expression function names, you can use the GetFunctions
interface on the expression capabilities and query it. The fact that your check
“Contains” does not return the correct answer may have to do with the spelling
of the function name. As Dan suggested try using the constant
FDO_FUNCTION_LOWER.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'> Thomas<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Dan Stoica<br>
<b>Sent:</b> July-31-09 2:56 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'>Note you can use </span><span style='font-size:10.0pt;
font-family:"Courier New"'>FDO_FUNCTION_LOWER <span style='color:#1F497D'>instead
of</span> “LOWER”.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Yes, in these cases if the
provider says a function is not supported it means it is not supported
natively.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>The missing functions can be
added as custom functions, I guess.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Chris Erickson<br>
<b>Sent:</b> Friday, July 31, 2009 2:45 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>It tells me that the provider
doesn’t support LOWER (SQL 2008 / SDE 9.2) when I know it does. Ideas?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="_x0000_i1026" src="cid:image001.png@01CA1A9C.44796FF0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'><a
href="mailto:chris@cartopac.com">chris@cartopac.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.493.9500 x
191<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.482.1485
(fax)</span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Chris Erickson<br>
<b>Sent:</b> Friday, July 31, 2009 12:41 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>So, like:<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:1.5in;text-autospace:none'><span
style='font-size:10.0pt;font-family:"Courier New";color:blue'>if</span><span
style='font-size:10.0pt;font-family:"Courier New"'> (_connection.ExpressionCapabilities.Functions.Contains(<span
style='color:#A31515'>"LOWER"</span>))<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New"'>
<span
style='color:green'>//need to search for variants<o:p></o:p></span></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New"'>
updateFilter = <span style='color:#2B91AF'>String</span>.Format(<span
style='color:#A31515'>" LOWER({0}) = {1} OR LOWER({0}) = {2}"</span>...<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New"'>
<span style='color:blue'>else<o:p></o:p></span></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New"'>
{<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New"'>
result.Message += <span style='color:#A31515'>" Warning: Could not do case
insensitive search. LOWER not supported by datasource."</span>;<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New"'>
updateFilter = <span style='color:#2B91AF'>String</span>.Format(<span
style='color:#A31515'>" {0} = {1} OR {0} = {2}"</span>...</span><span
style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Is there any way to get the
function name, or is it standard across almost all providers?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="_x0000_i1027" src="cid:image001.png@01CA1A9C.44796FF0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'><a
href="mailto:chris@cartopac.com">chris@cartopac.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.493.9500 x
191<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.482.1485
(fax)</span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Dan Stoica<br>
<b>Sent:</b> Friday, July 31, 2009 12:35 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'>To find if a provider supports LOWER is easy: just check </span><span
style='font-size:10.0pt;font-family:"Courier New"'>ExpressionCapabilities.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Chris Erickson<br>
<b>Sent:</b> Friday, July 31, 2009 2:25 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>It works on a select, on an
update I get an error (invalid function or return type LOWER).<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I would more would just like to
code it correctly to work with more providers, and to be able to identify if a
provider supports LOWER.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="_x0000_i1028" src="cid:image001.png@01CA1A9C.44796FF0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'><a
href="mailto:chris@cartopac.com">chris@cartopac.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.493.9500 x
191<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.482.1485
(fax)</span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Dan Stoica<br>
<b>Sent:</b> Friday, July 31, 2009 12:13 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'>What is the error?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Chris Erickson<br>
<b>Sent:</b> Friday, July 31, 2009 2:04 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Setting a query filter, wanting
to match for GUID variations in fields that are of string type (i.e. oracle):<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>(DOTNET)<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>string queryFilter =
“LOWER(MyGuidFieldName) = ‘83a1fb63-8141-4a75-987c-c64552e3b240’ OR
LOWER(MyGuidFieldName) = ‘{83a1fb63-8141-4a75-987c-c64552e3b240}’”;<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>IUpdate updateCommand = new …<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>updateCommand.SetFilter(queryFilter);<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>…<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>updateCommand.Execute(); <-
right now this doesn’t work…<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Is there a better way to be
doing this?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0
style='border-collapse:collapse'>
<tr style='height:4.0pt'>
<td width=97 valign=top style='width:72.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><a href="http://www.cartopac.com/"><b><span
style='font-size:12.0pt;color:#1F497D;text-decoration:none'><img border=0
width=78 height=69 id="Picture_x0020_1"
src="cid:image001.png@01CA1A9C.44796FF0"
alt="cid:image003.png@01C8E59D.204D9280"></span></b></a><span
style='color:#1F497D'><o:p></o:p></span></p>
</td>
<td width=541 valign=top style='width:405.9pt;padding:0in 5.4pt 0in 5.4pt;
height:4.0pt'>
<p class=MsoNormal><span style='color:#1F497D'>chris erickson<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>developer<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'><a
href="mailto:chris@cartopac.com">chris@cartopac.com</a><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.493.9500 x
191<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:8.0pt;color:#595959'>970.482.1485
(fax)</span><span style='font-size:8.0pt;color:#1F497D'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Dan Stoica<br>
<b>Sent:</b> Friday, July 31, 2009 11:59 AM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] RE: Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'>Do you mean the native name?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'>Why do you need it?<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'>Thanks,<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'>Dan.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-users-bounces@lists.osgeo.org [mailto:fdo-users-bounces@lists.osgeo.org] <b>On
Behalf Of </b>Chris Erickson<br>
<b>Sent:</b> Friday, July 31, 2009 1:52 PM<br>
<b>To:</b> FDO Users Mail List<br>
<b>Subject:</b> [fdo-users] Get LOWER function name for source<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hello,<o:p></o:p></p>
<p class=MsoNormal>Is there a straightforward way to get the LOWER function
name for a connection?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks,<o:p></o:p></p>
<p class=MsoNormal>Chris Erickson<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>