<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Optimization</title>
<link rel="stylesheet" type="text/css" href="../../../../style.css">
</head>
<body>
<div class="CommonContent">
<div class="CommonContentArea">
<h1>Optimization</h1><script>
//We attach this function to a browser object as a variable so that if multiple of these blocks are
//present on the same page, then they will simply over-write eachother with the same function instead
//of generating a naming collision.
window.WikiCodeFormattingCopyToClipboard = function copyToClipboard(sID){
var sContent = document.getElementById(sID).innerText;
if( window.clipboardData && clipboardData.setData )
{
clipboardData.setData("Text", sContent);
}
else
{
alert("You must enable javascript access to your clipboard for this feature to work. Please referr to your browser documentation or Google search for instructions.");
}
}
</script><p>Those of you who are familiar with db4o query processor may
already suspect that LINQ queries as well as NQ and QueryByExample queries are
converted to <a href="../soda_query.html" class="wikiLink">SODA Query</a> under the hood. And that is true. The downside of this is
that some of the queries cannot be converted to SODA and will run against all
instances of matching class objects. Some of the cases when conversion is not possible: </p>
<ul><li>there is no SODA alternative available</li><li>constraints on aggregates (avg(List) = constant)</li><li>constraints to values that are not available before
query executions (Pilot.Points = Pilot.Name.Length</li></ul>
<span name="cs_wiki_filter" csw_filters="cs">
<div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">LinqExample.cs: <span class="fscMemberName">SelectUnoptimized</span></span></div><div class="fscCode"><pre ID="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60"><div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><span style="color: #008080;">01</span><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/None.gif" align="top"/><span style="color: #0000FF;">private</span><span style="color: #000000;"> </span><span style="color: #0000FF;">static</span><span style="color: #000000;"> </span><span style="color: #0000FF;">void</span><span style="color: #000000;"> SelectUnoptimized()
</span><span style="color: #008080;">02</span><span style="color: #000000;"><img id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_48_721_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_48_721_Open_Text').style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_48_721_Closed_Image').style.display='inline'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_48_721_Closed_Text').style.display='inline';"/><img id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_48_721_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_48_721_Closed_Text').style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_48_721_Open_Image').style.display='inline'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_48_721_Open_Text').style.display='inline';"/> </span><span id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_48_721_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_48_721_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">03</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> IObjectContainer container </span><span style="color: #000000;">=</span><span style="color: #000000;"> Database();
</span><span style="color: #008080;">04</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (container </span><span style="color: #000000;">!=</span><span style="color: #000000;"> </span><span style="color: #0000FF;">null</span><span style="color: #000000;">)
</span><span style="color: #008080;">05</span><span style="color: #000000;"><img id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_150_711_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_150_711_Open_Text').style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_150_711_Closed_Image').style.display='inline'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_150_711_Closed_Text').style.display='inline';"/><img id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_150_711_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_150_711_Closed_Text').style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_150_711_Open_Image').style.display='inline'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_150_711_Open_Text').style.display='inline';"/> </span><span id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_150_711_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_150_711_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">06</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">try</span><span style="color: #000000;">
</span><span style="color: #008080;">07</span><span style="color: #000000;"><img id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_188_446_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_188_446_Open_Text').style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_188_446_Closed_Image').style.display='inline'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_188_446_Closed_Text').style.display='inline';"/><img id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_188_446_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_188_446_Closed_Text').style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_188_446_Open_Image').style.display='inline'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_188_446_Open_Text').style.display='inline';"/> </span><span id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_188_446_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_188_446_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">08</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> IEnumerable</span><span style="color: #000000;"><</span><span style="color: #000000;">Pilot</span><span style="color: #000000;">></span><span style="color: #000000;"> result </span><span style="color: #000000;">=</span><span style="color: #000000;"> from Pilot p </span><span style="color: #0000FF;">in</span><span style="color: #000000;"> container
</span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">where</span><span style="color: #000000;"> p.Points </span><span style="color: #000000;">==</span><span style="color: #000000;"> p.Name.Length
</span><span style="color: #008080;">10</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> select p;
</span><span style="color: #008080;">11</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/>
</span><span style="color: #008080;">12</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> ListResult(result);
</span><span style="color: #008080;">13</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">
</span><span style="color: #008080;">14</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">catch</span><span style="color: #000000;"> (Exception ex)
</span><span style="color: #008080;">15</span><span style="color: #000000;"><img id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_500_600_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_500_600_Open_Text').style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_500_600_Closed_Image').style.display='inline'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_500_600_Closed_Text').style.display='inline';"/><img id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_500_600_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_500_600_Closed_Text').style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_500_600_Open_Image').style.display='inline'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_500_600_Open_Text').style.display='inline';"/> </span><span id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_500_600_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_500_600_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">16</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> System.Console.WriteLine(</span><span style="color: #800000;">"</span><span style="color: #800000;">System Exception: </span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> ex.Message);
</span><span style="color: #008080;">17</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">
</span><span style="color: #008080;">18</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">finally</span><span style="color: #000000;">
</span><span style="color: #008080;">19</span><span style="color: #000000;"><img id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_641_697_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_641_697_Open_Text').style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_641_697_Closed_Image').style.display='inline'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_641_697_Closed_Text').style.display='inline';"/><img id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_641_697_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_641_697_Closed_Text').style.display='none'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_641_697_Open_Image').style.display='inline'; document.getElementById('..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_641_697_Open_Text').style.display='inline';"/> </span><span id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_641_697_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..LinqCs.ZipsLinqExample.Cs_LinqExample.Cs_SelectUnoptimized_698_60_641_697_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">20</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> CloseDatabase();
</span><span style="color: #008080;">21</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">
</span><span style="color: #008080;">22</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockEnd.gif" align="top"/> }</span></span><span style="color: #000000;">
</span><span style="color: #008080;">23</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> }</span></span></div></pre></div></div>
</span>
<span name="cs_wiki_filter" csw_filters="vb">
<div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">LinqExample.vb: <span class="fscMemberName">SelectUnoptimized</span></span></div><div class="fscCode"><pre ID="..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60"><div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><span style="color: #008080;">01</span><img id="..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60_15_614_Open_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60_15_614_Open_Text').style.display='none'; document.getElementById('..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60_15_614_Closed_Image').style.display='inline'; document.getElementById('..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60_15_614_Closed_Text').style.display='inline';"/><img id="..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60_15_614_Closed_Image" src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60_15_614_Closed_Text').style.display='none'; document.getElementById('..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60_15_614_Open_Image').style.display='inline'; document.getElementById('..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60_15_614_Open_Text').style.display='inline';"/><span style="color: #0000FF;">Private</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Shared</span><span style="color: #000000;"> </span><span id="..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60_15_614_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">Sub SelectUnoptimized()</span><span id="..LinqVB.ZipsLinqExample.Vb_LinqExample.Vb_SelectUnoptimized_822_60_15_614_Open_Text"><span style="color: #0000FF;">Sub</span><span style="color: #000000;"> SelectUnoptimized()
</span><span style="color: #008080;">02</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Dim</span><span style="color: #000000;"> container </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> IObjectContainer </span><span style="color: #000000;">=</span><span style="color: #000000;"> Database()
</span><span style="color: #008080;">03</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">If</span><span style="color: #000000;"> container </span><span style="color: #0000FF;">IsNot</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Nothing</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Then</span><span style="color: #000000;">
</span><span style="color: #008080;">04</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Try</span><span style="color: #000000;">
</span><span style="color: #008080;">05</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Dim</span><span style="color: #000000;"> pilots </span><span style="color: #000000;">=</span><span style="color: #000000;"> From item </span><span style="color: #0000FF;">In</span><span style="color: #000000;"> container _
</span><span style="color: #008080;">06</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> Where item.GetType </span><span style="color: #0000FF;">Is</span><span style="color: #000000;"> </span><span style="color: #0000FF;">GetType</span><span style="color: #000000;">(Pilot) </span><span style="color: #0000FF;">Select</span><span style="color: #000000;"> </span><span style="color: #0000FF;">CType</span><span style="color: #000000;">(item, Pilot)
</span><span style="color: #008080;">07</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Dim</span><span style="color: #000000;"> result </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> IEnumerable(</span><span style="color: #0000FF;">Of</span><span style="color: #000000;"> Pilot) </span><span style="color: #000000;">=</span><span style="color: #000000;"> From p _
</span><span style="color: #008080;">08</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">In</span><span style="color: #000000;"> pilots Where p.Points </span><span style="color: #000000;">=</span><span style="color: #000000;"> p.Name.Length </span><span style="color: #0000FF;">Select</span><span style="color: #000000;"> p
</span><span style="color: #008080;">09</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> ListResult(result)
</span><span style="color: #008080;">10</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">Finally</span><span style="color: #000000;">
</span><span style="color: #008080;">11</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> CloseDatabase()
</span><span style="color: #008080;">12</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">End</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Try</span><span style="color: #000000;">
</span><span style="color: #008080;">13</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> </span><span style="color: #0000FF;">End</span><span style="color: #000000;"> </span><span style="color: #0000FF;">If</span><span style="color: #000000;">
</span><span style="color: #008080;">14</span><span style="color: #000000;"><img src="../../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockEnd.gif" align="top"/> </span><span style="color: #0000FF;">End Sub</span></span></div></pre></div></div>
</span>
</div>
</div>
<div id="footer">
This revision (3) was last Modified 2008-03-15T17:42:12 by Tetyana.
</div>
</body>
</html>
