Select Statement

Fri, 12 Jun 2009 10:30:17 GMT

I'm loading a number of fields form Lotus Notes using ODBC. After the load statement I have the following Select Statement:

SQL

FROM

"Administrator_Views_QlikView_Export" where LEASE_TERM <> '6' and CUSTOMER_ASSET_STATUS <> '6' AND (ASSET_TYPE = 'PC' OR ASSET_TYPE = 'Laptop');

SELECT *

FROM

"Administrator_Views_QlikView_Export" where LEASE_TERM <> '6' and CUSTOMER_ASSET_STATUS <> '6' AND (ASSET_TYPE = 'PC' OR ASSET_TYPE = 'Laptop');

SELECT *

FROM

"Administrator_Views_QlikView_Export" where LEASE_TERM <> '6' and CUSTOMER_ASSET_STATUS <> '6' AND (ASSET_TYPE = 'PC' OR ASSET_TYPE = 'Laptop');

The result unfortunately shows no sign of filtering. It is as if the Where part of the statement was not there. I get records whose asset types are neither PC or Laptop and that have Lease Terms = 6.

Don't SQL statements work to there full capicity when used in this context,

Select Statement

Fri, 12 Jun 2009 15:00:31 GMT

Hi,

can you paste the actual script please, and i'll take a look. What you have put here doesn't look as if it was taken from the script directly.
Thanks,

Matt

topic Select Statement in QlikView

Select Statement

I'm loading a number of fields form Lotus Notes using ODBC. After the load statement I have the following Select Statement:

Select Statement