<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>QBE</title>
<link rel="stylesheet" type="text/css" href="../../../style.css">
</head>
<body>
<div class="CommonContent">
<div class="CommonContentArea">
<h1>QBE</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>If we have a prototype and want to find
out if there is an object in the database with the same field values,
we can simply use QBE:</p>
<span name="cs_wiki_filter" csw_filters="cs">
<div class="FormattedSourceCode"><div class="fscHeader"><span class="fscFileName">EqualityExample.cs: <span class="fscMemberName">RetrieveEqual</span></span></div><div class="fscCode"><pre ID="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64"><div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><span style="color: #008080;">01</span><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_36_531_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_36_531_Open_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_36_531_Closed_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_36_531_Closed_Text').style.display='inline';"/><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_36_531_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_36_531_Closed_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_36_531_Open_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_36_531_Open_Text').style.display='inline';"/><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;"> RetrieveEqual() </span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_36_531_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_36_531_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">02</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;">03</span><span style="color: #000000;"><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_106_528_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_106_528_Open_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_106_528_Closed_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_106_528_Closed_Text').style.display='inline';"/><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_106_528_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_106_528_Closed_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_106_528_Open_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_106_528_Open_Text').style.display='inline';"/> </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 id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_106_528_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_106_528_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">04</span><span style="color: #000000;"><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_115_395_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_115_395_Open_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_115_395_Closed_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_115_395_Closed_Text').style.display='inline';"/><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_115_395_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_115_395_Closed_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_115_395_Open_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_115_395_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">try</span><span style="color: #000000;"> </span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_115_395_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_115_395_Open_Text"><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"/> IObjectSet result </span><span style="color: #000000;">=</span><span style="color: #000000;"> container.Get(</span><span style="color: #0000FF;">new</span><span style="color: #000000;"> Pilot(</span><span style="color: #800000;">"</span><span style="color: #800000;">Kimi Raikkonnen</span><span style="color: #800000;">"</span><span style="color: #000000;">, </span><span style="color: #800080;">100</span><span style="color: #000000;">));
</span><span style="color: #008080;">06</span><span style="color: #000000;"><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_216_305_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_216_305_Open_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_216_305_Closed_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_216_305_Closed_Text').style.display='inline';"/><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_216_305_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_216_305_Closed_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_216_305_Open_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_216_305_Open_Text').style.display='inline';"/> </span><span style="color: #0000FF;">if</span><span style="color: #000000;"> (result.Count </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;">)</span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_216_305_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_216_305_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">07</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;">Found equal object: </span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> result.Next().ToString());
</span><span style="color: #008080;">08</span><span style="color: #000000;"><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_311_390_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_311_390_Open_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_311_390_Closed_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_311_390_Closed_Text').style.display='inline';"/><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_311_390_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_311_390_Closed_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_311_390_Open_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_311_390_Open_Text').style.display='inline';"/> }</span></span><span style="color: #000000;"> </span><span style="color: #0000FF;">else</span><span style="color: #000000;"> </span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_311_390_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_311_390_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">09</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;">No equal object exist in the database</span><span style="color: #800000;">"</span><span style="color: #000000;">);
</span><span style="color: #008080;">10</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;">11</span><span style="color: #000000;"><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_417_488_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_417_488_Open_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_417_488_Closed_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_417_488_Closed_Text').style.display='inline';"/><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_417_488_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_417_488_Closed_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_417_488_Open_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_417_488_Open_Text').style.display='inline';"/> }</span></span><span style="color: #000000;"> </span><span style="color: #0000FF;">catch</span><span style="color: #000000;"> (Exception ex) </span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_417_488_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_417_488_Open_Text"><span style="color: #000000;">{
</span><span style="color: #008080;">12</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;">13</span><span style="color: #000000;"><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_497_524_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedSubBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_497_524_Open_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_497_524_Closed_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_497_524_Closed_Text').style.display='inline';"/><img id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_497_524_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedSubBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_497_524_Closed_Text').style.display='none'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_497_524_Open_Image').style.display='inline'; document.getElementById('..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_497_524_Open_Text').style.display='inline';"/> }</span></span><span style="color: #000000;"> </span><span style="color: #0000FF;">finally</span><span style="color: #000000;"> </span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_497_524_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">...</span><span id="..EqualityCS.ZipsEqualityExample.Cs_EqualityExample.Cs_RetrieveEqual_192_64_497_524_Open_Text"><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"/> CloseDatabase();
</span><span style="color: #008080;">15</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;">16</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;">17</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">EqualityExample.vb: <span class="fscMemberName">RetrieveEqual</span></span></div><div class="fscCode"><pre ID="..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64"><div><!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--><span style="color: #008080;">01</span><img id="..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64_15_781_Open_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ExpandedBlockStart.gif" align="top" onClick="this.style.display='none'; document.getElementById('..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64_15_781_Open_Text').style.display='none'; document.getElementById('..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64_15_781_Closed_Image').style.display='inline'; document.getElementById('..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64_15_781_Closed_Text').style.display='inline';"/><img id="..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64_15_781_Closed_Image" src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/ContractedBlock.gif" align="top" style="display: none;" onClick="this.style.display='none'; document.getElementById('..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64_15_781_Closed_Text').style.display='none'; document.getElementById('..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64_15_781_Open_Image').style.display='inline'; document.getElementById('..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64_15_781_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="..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64_15_781_Closed_Text" style="border: solid 1px #808080; background-color: #FFFFFF; display: none;">Sub RetrieveEqual()</span><span id="..EqualityVB.ZipsEqualityExample.Vb_EqualityExample.Vb_RetrieveEqual_314_64_15_781_Open_Text"><span style="color: #0000FF;">Sub</span><span style="color: #000000;"> RetrieveEqual()
</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;"> result </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> IObjectSet </span><span style="color: #000000;">=</span><span style="color: #000000;"> container.[</span><span style="color: #0000FF;">Get</span><span style="color: #000000;">](</span><span style="color: #0000FF;">New</span><span style="color: #000000;"> Pilot(</span><span style="color: #800000;">"</span><span style="color: #800000;">Kimi Raikkonnen</span><span style="color: #800000;">"</span><span style="color: #000000;">, </span><span style="color: #800080;">100</span><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;">If</span><span style="color: #000000;"> result.Count </span><span style="color: #000000;">></span><span style="color: #000000;"> </span><span style="color: #800080;">0</span><span style="color: #000000;"> </span><span style="color: #0000FF;">Then</span><span style="color: #000000;">
</span><span style="color: #008080;">07</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;">Found equal object: </span><span style="color: #800000;">"</span><span style="color: #000000;"> </span><span style="color: #000000;">+</span><span style="color: #000000;"> result.[</span><span style="color: #0000FF;">Next</span><span style="color: #000000;">]().ToString())
</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;">Else</span><span style="color: #000000;">
</span><span style="color: #008080;">09</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;">No equal object exist in the database</span><span style="color: #800000;">"</span><span style="color: #000000;">)
</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;">End</span><span style="color: #000000;"> </span><span style="color: #0000FF;">If</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"/> </span><span style="color: #0000FF;">Catch</span><span style="color: #000000;"> ex </span><span style="color: #0000FF;">As</span><span style="color: #000000;"> Exception
</span><span style="color: #008080;">12</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;">13</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;">14</span><span style="color: #000000;"><img src="../../../Utility/ActiPro.CodeHighligher/OutliningIndicators/InBlock.gif" align="top"/> CloseDatabase()
</span><span style="color: #008080;">15</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;">16</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;">17</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>
<p>This method allows to combine retrieval
and comparing in one operation.</p>
<p><br>
</p>
</div>
</div>
<div id="footer">
This revision (1) was last Modified 2007-09-09T16:06:01 by Tetyana.
</div>
</body>
</html>
