Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I deal with null values in a database table?
I can't replace them with 0 or anything else if there is a way Please help. I'm stuck.
Best Regards,
Gaurav Tyagi
Can you please share more information about your problem? You shouldn't be getting any problems with null values.
What exactly is happening? do you get an error message?
I am getting this message when executing my Stored Procedure.
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.
Best Regards,
Gaurav Tyagi
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.
Make sure you don't have two fields with the same name as that could also cause a problem.