Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
We are experiencing some problem in the database which stopped QV from reloading. We've pick a few records and we'd like to exclude them from the script to try to catch the problem but I keep getting syntax error.
Here is my script. I am trying to exclude OrderNum = 1234567 but it stopped right at SQL select *. Please help.
LOAD
CustNum,
OrderNum,
SalesRepList,
CheckBox06,
Company,
RepRate1
SQL Select *
FROM PUB.OrderHed
where
not
( OrderNum = 1234567);
Have you tried running this outside of QlikView, in Toad?
Select *
FROM PUB.OrderHed
Where not (OrderNum = 1234567);
Thanks for answering. We don't have Toad. I can only test it in QV...:(
Hi
where
( OrderNum <> 1234567);
I guess you need to figure out if the SQL syntax is right or not.... try this
LOAD
CustNum,
OrderNum,
SalesRepList,
CheckBox06,
Company,
RepRate1;
Select *
FROM PUB.OrderHed
Where OrderNum NOT IN (1234567);
did yo find an answer?
I think the correct code is
where
( OrderNum <> '1234567');
which kind of database do you use: Oracle, MS SQL, MySQL?
Use the below one..
LOAD
CustNum,
OrderNum,
SalesRepList,
CheckBox06,
Company,
RepRate1;
SQL Select *
FROM PUB.OrderHed
where
OrderNum <> '1234567';