Hi,
is this your real query? I ask, because below WHERE can be not intentionaly
written by OR
WHERE (
heir.iaccttreeid = 47
AND cast(tsi.tdt AS date) < '2018-04-01' )
OR(
heir.iaccttreeid <> 47
AND
On 20.06.2018 o 13:41, Venus Software Operations venussof...@gmail.com
[firebird-support] wrote:
> Hi Thomasz
>
> You have understood me correctly, that is what I want to do and your
> suggestion
> works thanks.
>
> Please see my reply to SET as the query has slowed down to 10 minutes with
>
The reason the first query failed, Bhavbhuti, was because I forgot that
nested CASE also needs nested END, so adding END to the end of the query
should work on Fb 2.5 (and thanks Mark, for showing me a part of
Firebird 3 that I didn't know of). Still, even though it should work, it
will be
On 19-6-2018 13:54, Svein Erling Tysvær setys...@gmail.com
[firebird-support] wrote:
>
>
> Hi Bhavbhuti!
>
> According to https://firebirdsql.org/refdocs/langrefupd15-case.html
>
> this is how case is written:
>
> CASE
> WHEN THEN result1
> WHEN THEN result2
> ...
> [ELSE
Hi,
As I understand it, what you meant is:
where
(
TRIM(vwTA.cNameCity01) = 'Balance Sheet' and CAST(tSI.tDt AS DATE) <
'2018-04-01'
)
or
(
TRIM(vwTA.cNameCity01) is distinct from 'Balance Sheet'
and CAST(tSI.tDt AS DATE) BETWEEN '2018-03-01' AND '2018-03-31'
)
If vwTA.cNameCity01 is sure to
11 matches
Mail list logo
