RE: [firebird-support] Evaluate "empty" string

2017-08-16 Thread 'bogdan mordicom' bog...@mordicom.si [firebird-support]
This is also possible If (coalesce(terminal, '') <> '') then Regards Bogdan From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Wednesday, August 16, 2017 6:39 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Evaluate

Re: [firebird-support] Evaluate "empty" string

2017-08-16 Thread Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support]
That's right! I was focusing in the wrong place! So stupid me! Thanks a lot (also to Michel). 2017-08-16 13:20 GMT-03:00 Mark Rotteveel m...@lawinegevaar.nl [firebird-support] : > On 16-8-2017 17:53, Jorge Andres Brugger jorge.brug...@gmail.com >

Re: [firebird-support] Evaluate "empty" string

2017-08-16 Thread Michel LE CLEZIO mlcvi...@yahoo.fr [firebird-support]
May be this : if (terminal<>'') and ( not  (terminal is null)) thendo something With best regardsMichel Le Mercredi 16 août 2017 18h20, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" a écrit :   On 16-8-2017 17:53, Jorge Andres Brugger

Re: [firebird-support] Evaluate "empty" string

2017-08-16 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 16-8-2017 17:53, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > Hello all. > I need to evaluate if one SP varchar parameter is "not empty". I´m using: > if (((CHAR_LENGTH(trim(terminal))>0) or (terminal is not null)) then something>. > If I send '' (empty string) as

[firebird-support] Evaluate "empty" string

2017-08-16 Thread Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support]
Hello all. I need to evaluate if one SP varchar parameter is "not empty". I´m using: if (((CHAR_LENGTH(trim(terminal))>0) or (terminal is not null)) then . If I send '' (empty string) as parameter content, the expression evaluates to true (I´m expecting to get a false). What am I doing wrong?

Re: [firebird-support] FIRST 1 of each iItemID

2017-08-16 Thread venussof...@gmail.com [firebird-support]
Thanks a lot Set. Yes, I guess I was not able to explain my requirements clearly. I think because the underlying is a view, vwPriceListHistory, the query you suggested is taking very long to run. I will try your suggestion where there is a table rather than derived data Kind regards

Re: [firebird-support] Automation tools?

2017-08-16 Thread Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support]

Re: [firebird-support] Re: FIRST 1 of each iItemID

2017-08-16 Thread venussof...@gmail.com [firebird-support]
Thanks Mark. I went back to the cID as you suggested. I added a 0 padded iItemID before the date and also padded the rest of the cID with 0 just like you wanted (though expanded) and your query works lightening fast. I will be able to make practical use of it I am sure. Thanks again for