<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:0cm;
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
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
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;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle32
{mso-style-type:personal-reply;
font-family:"Times New Roman","serif";
color:#1F497D;
font-weight:normal;
font-style:normal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</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-CA link=blue vlink=purple>
<div class=Section1>
<p>Hi Chris,<o:p></o:p></p>
<p>You are generalizing too much.<o:p></o:p></p>
<p>A provider will always indicate the expression functions it supports -
independent of how the function is actually implemented - via the
expression capabilities. You can use the interface <i>FdoIExpressionCapabilities::GetFunctions()</i>
to get the complete list of supported expression functions. Any function that
is returned in the <i>FdoFunctionDefinitionCollection</i> should be
supported (if it is not then this should be an error).<o:p></o:p></p>
<p>In case of the <i>ArcSDE</i> Provider - you referred to this provider
previously - the above interface is realized by getting the list of expression
functions from the Expression Engine (see file <i>ArcSDEExpressionCapabilities.cpp</i>).
The Expression Engine`s list of standard functions includes the function <i>LOWER</i>.
Therefore, the provider should support it.<br>
<br>
The Expression Engine has a default implementation of all the functions it
supports. A provider can therefore utilize this functionality to implement its
support of those functions. But that is up to the provider implementation.
<o:p></o:p></p>
<p>By using the function name you get back from the list returned by the
interface <i>FdoIExpressionCapabilities::GetFunctions()</i> you should have no
problem executing it.<o:p></o:p></p>
<p>Thanks<o:p></o:p></p>
<p class=MsoNormal> Thomas<br>
<br>
<span style='font-size:10.0pt;font-family:"Times New Roman","serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span 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 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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-11-09 6:02 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-US style='color:#1F497D'>So, jus to be clear,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 lang=EN-US 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:0cm 5.4pt 0cm 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@01CA1B27.F8558870"
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:0cm 5.4pt 0cm 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>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span 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 style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span 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 style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New"'>#define
FDO_FUNCTION_LOWER L"Lower"</span><span
style='font-size:10.0pt;font-family:"Times New Roman","serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span 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 style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'> Thomas<o:p></o:p></span></p>
<p class=MsoNormal><span 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 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Thanks for your help.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>In the managed api,
where is FDO_FUNCTION_LOWER?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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:0cm 5.4pt 0cm 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@01CA1B27.F8558870"
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:0cm 5.4pt 0cm 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 lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span 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 style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span 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 style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span 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 style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'> Thomas<o:p></o:p></span></p>
<p class=MsoNormal><span 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 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Times New Roman","serif";
color:#1F497D'>Note you can use </span><span lang=EN-US 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 lang=EN-US style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>The missing functions
can be added as custom functions, I guess.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 lang=EN-US 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:0cm 5.4pt 0cm 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@01CA1B27.F8558870"
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:0cm 5.4pt 0cm 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 lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>So, like:<o:p></o:p></span></p>
<p class=MsoNormal style='margin-left:108.0pt;text-autospace:none'><span
lang=EN-US style='font-size:10.0pt;font-family:"Courier New";color:blue'>if</span><span
lang=EN-US 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 lang=EN-US
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 lang=EN-US
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 lang=EN-US
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 lang=EN-US
style='font-size:10.0pt;font-family:"Courier New"'>
{<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-US
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 lang=EN-US
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
lang=EN-US style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 lang=EN-US 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:0cm 5.4pt 0cm 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@01CA1B27.F8558870"
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:0cm 5.4pt 0cm 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 lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Times New Roman","serif";
color:#1F497D'>To find if a provider supports LOWER is easy: just check </span><span
lang=EN-US style='font-size:10.0pt;font-family:"Courier New"'>ExpressionCapabilities.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 lang=EN-US 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:0cm 5.4pt 0cm 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@01CA1B27.F8558870"
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:0cm 5.4pt 0cm 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 lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Times New Roman","serif";
color:#1F497D'>What is the error?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>(DOTNET)<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>IUpdate updateCommand
= new …<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>updateCommand.SetFilter(queryFilter);<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>…<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>updateCommand.Execute();
<- right now this doesn’t work…<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Is there a better way
to be doing this?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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:0cm 5.4pt 0cm 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@01CA1B27.F8558870"
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:0cm 5.4pt 0cm 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 lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 lang=EN-US style='font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Times New Roman","serif";
color:#1F497D'>Why do you need it?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Times New Roman","serif";
color:#1F497D'>Thanks,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-family:"Times New Roman","serif";
color:#1F497D'>Dan.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US 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 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US 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><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Hello,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Is there a straightforward way to get the
LOWER function name for a connection?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Thanks,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Chris Erickson<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
</div>
</body>
</html>