<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 15 (filtered medium)">
<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:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Webdings;
panose-1:5 3 1 2 1 5 9 6 7 3;}
@font-face
{font-family:r_ansi;
panose-1:2 11 6 9 2 2 2 2 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;
mso-fareast-language:EN-US;}
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;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></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="DA" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:#1F497D">Hi Alan,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1F497D">Since the two sort fields are in the subfile CMS8020ASF, you could sort the subfile in the request/run, where it is created, thus avoiding sorting the record complex containing the table with a blob.
<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>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Mange hilsner / With kind regards</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA">
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Ole Hansen</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">IT-Consultant</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">ScanConsult IT-Partners ApS</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Jegstrupvej 96A</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">DK-8361 </span><span lang="EN-US" style="color:black;mso-fareast-language:DA">
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Hasselager</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Denmark</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA">
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Phone (switchboard): +45 7734 7474</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Phone (direct): +45 7734 7472</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Mobile: +45 4040 1150</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Fax: +45 7734 7575</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><br>
</span><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><a href="mailto:oh@scanconsult.aero" target="_blank"><span lang="EN-US" style="font-family:"Arial",sans-serif">oh@scanconsult.aero</span></a></span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><br>
</span><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><a href="http://www.scanconsult.aero" target="_blank"><span lang="EN-US" style="font-family:"Arial",sans-serif">www.scanconsult.aero</span></a></span><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"> <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">ParaSuite: A Suite of Air Cargo Handling solutions</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><br>
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">We partner with Microsoft,</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA">
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Hewlett-Packard,</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA">
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">Oracle</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA">
</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;mso-fareast-language:DA">and others</span><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;mso-fareast-language:DA"><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 #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="mso-fareast-language:DA">From:</span></b><span lang="EN-US" style="mso-fareast-language:DA"> powerh-l-bounces+oh=scanconsult.aero@lists.sowder.com [mailto:powerh-l-bounces+oh=scanconsult.aero@lists.sowder.com]
<b>On Behalf Of </b>Thurston, Alan R JTST:EX<br>
<b>Sent:</b> Monday, June 08, 2015 11:38 PM<br>
<b>To:</b> 'powerh-l@lists.sowder.com'<br>
<b>Cc:</b> Johnson, Harold A AVED:EX; Holland, Peter A EDUC:EX; Thornton, Norah JTST:EX<br>
<b>Subject:</b> QTP Compile error on Itanium Powerhouse 840g<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span lang="EN-CA">Hello All,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">I have a statement in QTP that compiles OK in Powerhouse 710g1 but fails to compile in Powerhouse 840g. The statement is:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi">access *CMS8020ASF &<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"> link CBR_ID of CMS8020ASF &<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"> to CBR_ID of CBR_TU in LRBDB &<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"> link TU_NAME_ID of CBR_TU &<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"> to TU_NAME_ID of TU_NAME in LRBDB &<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"> link TU_LOCAL_ID of TU_NAME &<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"> to TU_LOCAL_ID of TU_LOCAL in LRBDB &<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"> link TU_ID of TU_LOCAL &<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"> to TU_ID of TRADE_UNION in LRBDB
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi">sort on CASE_ID of CMS8020ASF &<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"> on DISP_ID of CMS8020ASF
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">The error is:<o:p></o:p></span></p>
<p class="MsoNormal"><b><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi">*E*</span></b><span lang="EN-CA" style="font-size:10.0pt;font-family:r_ansi"> Cannot sort table containing blob items.</span><span lang="EN-CA"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">The subfile is mostly blank fields that get populated later in this request. One of the linked tables does have a field defined as BLOB.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">The statement does compile in QTP 710g1 and also compiles in QUIZ 840g, just not in QTP 840g<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">I suspect I could create a database view of the blob-containing table and exclude the blob from the view a the blob field does not get used in the QTP run but I was hoping not to re-code too much, and that there might
be options or parameters somewhere that would resolve the issue.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Any ideas would be appreciated.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA">Thank you,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><i><span lang="EN-CA" style="color:black;mso-fareast-language:EN-CA">Alan Thurston -
</span></i></b><span lang="EN-CA" style="font-size:10.0pt;color:black;mso-fareast-language:EN-CA">Senior Software Developer</span><span lang="EN-CA" style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:black;mso-fareast-language:EN-CA"> - Information
Systems Branch<br>
</span><span lang="EN-CA" style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:gray;mso-fareast-language:EN-CA">Ministry of Community, Sport and Cultural Development | Ministry of Jobs, Tourism, and Skills Training (and Responsible for Labour)</span><span lang="EN-CA" style="font-size:8.0pt;font-family:"Times New Roman",serif;color:#1F497D;mso-fareast-language:EN-CA"><br>
<br>
</span><span lang="EN-CA" style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:gray;mso-fareast-language:EN-CA">Phone: 250 387-0220 | Fax: 250 387-1590</span><span lang="EN-CA" style="font-size:8.0pt;font-family:"Times New Roman",serif;color:#1F497D;mso-fareast-language:EN-CA">
<br>
</span><span lang="EN-CA" style="font-size:8.0pt;font-family:"Verdana",sans-serif;color:gray;mso-fareast-language:EN-CA">3<sup>rd</sup> Floor, 800 Johnson Street, PO Box 9802 Stn Prov Govt, Victoria, BC V8W 9W1</span><span lang="EN-CA" style="font-size:8.0pt;font-family:"Times New Roman",serif;color:#1F497D;mso-fareast-language:EN-CA">
<o:p></o:p></span></p>
<p class="MsoNormal"><b><i><span lang="EN-GB" style="font-size:18.0pt;font-family:Webdings;color:green;mso-fareast-language:EN-CA">P</span></i></b><b><i><span lang="EN-GB" style="font-size:20.0pt;color:#1F497D;mso-fareast-language:EN-CA">
</span></i></b><b><i><span lang="EN-CA" style="font-size:9.0pt;font-family:"Arial",sans-serif;color:green;mso-fareast-language:EN-CA">Please consider the environment before printing this e-mail</span></i></b><span lang="EN-CA" style="color:#1F497D;mso-fareast-language:EN-CA">
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-CA"><o:p> </o:p></span></p>
</div>
</body>
</html>