Here's an exampleApril 23 2012 at 12:16 PM
Score 5.0 (1 person)
from IP address 220.127.116.11
Response to sql interface reject not working properly
Hi, I'm sorry for the silence as I've been out for a week. I could see that this thread raised quite an interest, so many thanks!
Here below a detailed description of my issue :
My sql interface DLR includes here a simple SQL query for Sample Basic db :
WHEN coterimp IN ('001','002') THEN 'NEW YORK'
Which gives as a result :
NEW YORK 1
Now in my DLR I specify NA as a reject (Reject = String NA Equal) as I want to rejet Non Applicable datarows.
Here dataload header is set as : jan,sales,"100-10",Actual
However this is the error I have as if my reject was not taken into account...
\\ Member NA Not Found In Database
- Just tried it in 18.104.22.168 and Reject works - Cameron Lackpour on Apr 23, 2012, 1:26 PM
- Bad feeling - Sroux on Apr 23, 2012, 2:57 PM