Subject | Is this a valid query? It seems so, but it doesn't return anything |
---|---|
Author | Adrian Roman |
Post date | 2002-07-30T15:02:05Z |
Hi,
I tried the following query in a stored procedure:
select max("Cont") from "Conturi" where "Sintetic"='D' and :"Cont" starting
with "Cont" into :"Sintetic";
:"Cont" is an input parameter, :"Sintetic" is an output.
:"Cont" would be something like '411.1'
and where are things with field "Cont" as 4, 41, 411 with "Sintetic"='D' in
table "Conturi".
I tried to get 411 as a result with the above query. Unfortunately, it
doesn't return anything.
Adrian R
I tried the following query in a stored procedure:
select max("Cont") from "Conturi" where "Sintetic"='D' and :"Cont" starting
with "Cont" into :"Sintetic";
:"Cont" is an input parameter, :"Sintetic" is an output.
:"Cont" would be something like '411.1'
and where are things with field "Cont" as 4, 41, 411 with "Sintetic"='D' in
table "Conturi".
I tried to get 411 as a result with the above query. Unfortunately, it
doesn't return anything.
Adrian R