Hello,
1st, the following condition does not work unfortunately. (call a stored
procedure in the where-condition in a coalesce..)
and d.bsnr = coalesce(select ag from p_getmaxag(:teilenr,:typ,1),d.bsnr) and
d.bsnr coalesce (select ag from p_getmaxag(:teilenr,:typ,2),100)
I have some
This works:
and (d.bsnr = coalesce((select ag from
p_getmaxag(a.teilenr,:typ,1)),d.bsnr))
but how can I get the records without a bsnr, without an workstep, no record
in the table d.bsnr..)
Thanks
Hello,
1st, the following condition does not work unfortunately. (call a stored
and coalesce(d.bsnr, -1) = coalesce((select ag from
p_getmaxag(a.teilenr,:typ,1)),d.bsnr,-1)
seem to be a possible, but probably not very performant approach.
Doing a left join with the procedure in case the stuff before your
leading and holds true could be a solution...
Thomas
Am 14.08.2014
On 2012-12-02 18:16:17 +0100, Thomas Steinmaurer wrote:
On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé
[1][1][1]l.r...@griensu.com
wrote:
Hi, I'm wondering if there's a way to refer columns by number in
WHERE
conditions.
I need this
On 2012-12-01 14:14:50 -0500, Ann Harrison wrote:
On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé [1]l.r...@griensu.com
wrote:
Hi, I'm wondering if there's a way to refer columns by number in WHERE
conditions.
I need this because I'm creating a generic method
On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé [1]l.r...@griensu.com
wrote:
Hi, I'm wondering if there's a way to refer columns by number in WHERE
conditions.
I need this because I'm creating a generic method to create where
clauses for hopefully ANY
On 2012-12-02 16:59:24 +0100, Thomas Steinmaurer wrote:
On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé
[1][1]l.r...@griensu.com
wrote:
Hi, I'm wondering if there's a way to refer columns by number in
WHERE
conditions.
I need this because I'm
On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé
[1][1]l.r...@griensu.com
wrote:
Hi, I'm wondering if there's a way to refer columns by number in
WHERE
conditions.
I need this because I'm creating a generic method to create where
On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé
[1][1]l.r...@griensu.com
wrote:
Hi, I'm wondering if there's a way to refer columns by number in
WHERE
conditions.
I need this because I'm creating a generic method to create where
Hi, I'm wondering if there's a way to refer columns by number in WHERE
conditions.
I need this because I'm creating a generic method to create where
clauses for hopefully ANY query, in FreePascal.
I need this:
select col1, col2, colN
from ...
join ...
where
col1 = condition1, col2 =
On 2012-12-01 10:09:15 -0300, Leonardo M. Ramé wrote:
Hi, I'm wondering if there's a way to refer columns by number in WHERE
conditions.
I need this because I'm creating a generic method to create where
clauses for hopefully ANY query, in FreePascal.
I need this:
Hi, I'm wondering if there's a way to refer columns by number in WHERE
conditions.
I need this because I'm creating a generic method to create where clauses
for hopefully ANY query, in FreePascal.
I need this:
select col1, col2, colN
from ...
join ...
where
col1 = condition1, col2 =
On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé l.r...@griensu.com wrote:
Hi, I'm wondering if there's a way to refer columns by number in WHERE
conditions.
I need this because I'm creating a generic method to create where
clauses for hopefully ANY query, in FreePascal
What you suggest,
13 matches
Mail list logo