<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: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 14 (filtered medium)">
<style><!--
/* Font Definitions */
@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;}
/* 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-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@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="EN-CA" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hello All,<o:p></o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span 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 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 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 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 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 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 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 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 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 style="font-size:10.0pt;font-family:r_ansi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:r_ansi"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span 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 style="font-size:10.0pt;font-family:r_ansi"> on DISP_ID of CMS8020ASF
<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The error is:<o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:r_ansi">*E*</span></b><span style="font-size:10.0pt;font-family:r_ansi"> Cannot sort table containing blob items.</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The statement does compile in QTP 710g1 and also compiles in QUIZ 840g, just not in QTP 840g<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Any ideas would be appreciated.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thank you,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><i><span style="color:black;mso-fareast-language:EN-CA">Alan Thurston -
</span></i></b><span style="font-size:10.0pt;color:black;mso-fareast-language:EN-CA">Senior Software Developer</span><span style="font-size:8.0pt;font-family:"Verdana","sans-serif";color:black;mso-fareast-language:EN-CA"> - Information Systems Branch<br>
</span><span 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 style="font-size:8.0pt;font-family:"Times New Roman","serif";color:#1F497D;mso-fareast-language:EN-CA"><br>
<br>
</span><span 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 style="font-size:8.0pt;font-family:"Times New Roman","serif";color:#1F497D;mso-fareast-language:EN-CA">
<br>
</span><span 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 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 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 style="color:#1F497D;mso-fareast-language:EN-CA">
</span><span style="color:#1F497D;mso-fareast-language:EN-CA"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>