topic Implicit String Conversion in QlikView https://community.qlik.com/t5/QlikView/Implicit-String-Conversion/m-p/288754#M107336 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Hello,</SPAN></P><P><SPAN class="hps">&nbsp;&nbsp; I created</SPAN> <SPAN class="hps">a</SPAN> QV <SPAN class="hps">script that</SPAN> <SPAN class="hps">automatically</SPAN> <SPAN class="hps">stores some</SPAN> <SPAN class="hps">Oracle tables</SPAN> into <SPAN class="hps">QVD files</SPAN>. <SPAN class="hps">Unfortunately</SPAN> <SPAN class="hps">some fields</SPAN> <SPAN class="hps">(of </SPAN><SPAN class="hps">string type, but</SPAN> <SPAN class="hps">that contain numbers</SPAN>, <SPAN class="hps">eg</SPAN>. <SPAN class="hps atn">"</SPAN>07092") <SPAN class="hps">are converted</SPAN> <SPAN class="hps">before being</SPAN> <SPAN class="hps">stored</SPAN> <SPAN class="hps">into </SPAN><SPAN class="hps">QVD files</SPAN>. <SPAN class="hps">To resolve</SPAN> <SPAN class="hps">this problem</SPAN> <SPAN class="hps">I</SPAN> can <SPAN class="hps">use the</SPAN> <SPAN class="hps">Text</SPAN> <SPAN class="hps">()</SPAN> function <SPAN class="hps">on all fields</SPAN> <SPAN class="hps">of all</SPAN> <SPAN class="hps">tables that</SPAN> I <SPAN class="hps">store but </SPAN><SPAN class="hps">this is a</SPAN> <SPAN class="hps">problem because it</SPAN> <SPAN class="hps">would force</SPAN> <SPAN class="hps">me</SPAN> <SPAN class="hps">to change</SPAN> <SPAN class="hps">the script</SPAN> <SPAN class="hps">and </SPAN><SPAN class="hps">spell</SPAN> <SPAN class="hps">the names of all</SPAN> string <SPAN class="hps">fields</SPAN> <SPAN class="hps">of all tables</SPAN> <SPAN class="hps">(now</SPAN> <SPAN class="hps">I do a</SPAN> <SPAN class="hps">SELECT</SPAN> <SPAN class="hps">*</SPAN>).</P><P></P><P><SPAN class="hps">Is there a</SPAN> <SPAN class="hps">way to </SPAN>leave <SPAN class="hps">the fields content</SPAN> <SPAN class="hps">unchanged (as in </SPAN><SPAN class="hps">the database) and </SPAN><SPAN class="hps">does not</SPAN> <SPAN class="hps">perform any</SPAN> implicit <SPAN class="hps">conversion?</SPAN></P><P></P><P><SPAN class="hps">Thanks, Capetto</SPAN></P></BODY></HTML> Mon, 26 Sep 2011 07:39:16 GMT 2011-09-26T07:39:16Z Implicit String Conversion https://community.qlik.com/t5/QlikView/Implicit-String-Conversion/m-p/288754#M107336 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Hello,</SPAN></P><P><SPAN class="hps">&nbsp;&nbsp; I created</SPAN> <SPAN class="hps">a</SPAN> QV <SPAN class="hps">script that</SPAN> <SPAN class="hps">automatically</SPAN> <SPAN class="hps">stores some</SPAN> <SPAN class="hps">Oracle tables</SPAN> into <SPAN class="hps">QVD files</SPAN>. <SPAN class="hps">Unfortunately</SPAN> <SPAN class="hps">some fields</SPAN> <SPAN class="hps">(of </SPAN><SPAN class="hps">string type, but</SPAN> <SPAN class="hps">that contain numbers</SPAN>, <SPAN class="hps">eg</SPAN>. <SPAN class="hps atn">"</SPAN>07092") <SPAN class="hps">are converted</SPAN> <SPAN class="hps">before being</SPAN> <SPAN class="hps">stored</SPAN> <SPAN class="hps">into </SPAN><SPAN class="hps">QVD files</SPAN>. <SPAN class="hps">To resolve</SPAN> <SPAN class="hps">this problem</SPAN> <SPAN class="hps">I</SPAN> can <SPAN class="hps">use the</SPAN> <SPAN class="hps">Text</SPAN> <SPAN class="hps">()</SPAN> function <SPAN class="hps">on all fields</SPAN> <SPAN class="hps">of all</SPAN> <SPAN class="hps">tables that</SPAN> I <SPAN class="hps">store but </SPAN><SPAN class="hps">this is a</SPAN> <SPAN class="hps">problem because it</SPAN> <SPAN class="hps">would force</SPAN> <SPAN class="hps">me</SPAN> <SPAN class="hps">to change</SPAN> <SPAN class="hps">the script</SPAN> <SPAN class="hps">and </SPAN><SPAN class="hps">spell</SPAN> <SPAN class="hps">the names of all</SPAN> string <SPAN class="hps">fields</SPAN> <SPAN class="hps">of all tables</SPAN> <SPAN class="hps">(now</SPAN> <SPAN class="hps">I do a</SPAN> <SPAN class="hps">SELECT</SPAN> <SPAN class="hps">*</SPAN>).</P><P></P><P><SPAN class="hps">Is there a</SPAN> <SPAN class="hps">way to </SPAN>leave <SPAN class="hps">the fields content</SPAN> <SPAN class="hps">unchanged (as in </SPAN><SPAN class="hps">the database) and </SPAN><SPAN class="hps">does not</SPAN> <SPAN class="hps">perform any</SPAN> implicit <SPAN class="hps">conversion?</SPAN></P><P></P><P><SPAN class="hps">Thanks, Capetto</SPAN></P></BODY></HTML> Mon, 26 Sep 2011 07:39:16 GMT https://community.qlik.com/t5/QlikView/Implicit-String-Conversion/m-p/288754#M107336 2011-09-26T07:39:16Z