topic Re: Unable to load sql tables with Null values in its columns in QlikView https://community.qlik.com/t5/QlikView/Unable-to-load-sql-tables-with-Null-values-in-its-columns/m-p/447880#M167142 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="31609" class="jive-image-thumbnail jive-image" onclick="" alt="d.png" src="https://community.qlik.com/legacyfs/online/31609_d.png" width="450" /></P><P></P><P>I am getting this message when executing my Stored Procedure.</P><P>I used to get same kind of message when I was running a sql query but it started working properly when I replaced the null values with 0's. This Stored Procedure also have lots of Null values in its columns so I figured that it is because of the Null values. Please tell me if there is any other error in it.</P><P></P><P>Best Regards,</P><P>Gaurav Tyagi</P></BODY></HTML> Wed, 23 Jan 2013 12:44:01 GMT 2013-01-23T12:44:01Z Unable to load sql tables with Null values in its columns https://community.qlik.com/t5/QlikView/Unable-to-load-sql-tables-with-Null-values-in-its-columns/m-p/447878#M167140 <HTML><HEAD></HEAD><BODY><P>How can I deal with null values in a database table?</P><P>I can't replace them with 0 or anything else if there is a way Please help. I'm stuck. </P><P></P><P>Best Regards,</P><P>Gaurav Tyagi</P></BODY></HTML> Wed, 23 Jan 2013 12:26:38 GMT https://community.qlik.com/t5/QlikView/Unable-to-load-sql-tables-with-Null-values-in-its-columns/m-p/447878#M167140 2013-01-23T12:26:38Z Re: Unable to load sql tables with Null values in its columns https://community.qlik.com/t5/QlikView/Unable-to-load-sql-tables-with-Null-values-in-its-columns/m-p/447879#M167141 <HTML><HEAD></HEAD><BODY><P>Can you please share more information about your problem? You shouldn't be getting any problems with null values.</P><P></P><P>What exactly is happening? do you get an error message?</P></BODY></HTML> Wed, 23 Jan 2013 12:36:07 GMT https://community.qlik.com/t5/QlikView/Unable-to-load-sql-tables-with-Null-values-in-its-columns/m-p/447879#M167141 danielrozental 2013-01-23T12:36:07Z Re: Unable to load sql tables with Null values in its columns https://community.qlik.com/t5/QlikView/Unable-to-load-sql-tables-with-Null-values-in-its-columns/m-p/447880#M167142 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="31609" class="jive-image-thumbnail jive-image" onclick="" alt="d.png" src="https://community.qlik.com/legacyfs/online/31609_d.png" width="450" /></P><P></P><P>I am getting this message when executing my Stored Procedure.</P><P>I used to get same kind of message when I was running a sql query but it started working properly when I replaced the null values with 0's. This Stored Procedure also have lots of Null values in its columns so I figured that it is because of the Null values. Please tell me if there is any other error in it.</P><P></P><P>Best Regards,</P><P>Gaurav Tyagi</P></BODY></HTML> Wed, 23 Jan 2013 12:44:01 GMT https://community.qlik.com/t5/QlikView/Unable-to-load-sql-tables-with-Null-values-in-its-columns/m-p/447880#M167142 2013-01-23T12:44:01Z Re: Unable to load sql tables with Null values in its columns https://community.qlik.com/t5/QlikView/Unable-to-load-sql-tables-with-Null-values-in-its-columns/m-p/447881#M167143 <HTML><HEAD></HEAD><BODY><P>Sorry, the error message isn't descriptive enough for me to understand the problem, anyway it seems like the OLE DB driver is having problems with it, not QlikView, you should try using an ODBC connection.</P><P></P><P>Make sure you don't have two fields with the same name as that could also cause a problem.</P></BODY></HTML> Wed, 23 Jan 2013 12:47:13 GMT https://community.qlik.com/t5/QlikView/Unable-to-load-sql-tables-with-Null-values-in-its-columns/m-p/447881#M167143 danielrozental 2013-01-23T12:47:13Z