Subject | Re: [ib-support] Is this a valid query? It seems so, but it doesn't return anything |
---|---|
Author | Adrian Roman |
Post date | 2002-07-30T16:36:17Z |
Hi,
I changed the query with
select max(RTRIM("Cont")) from "Conturi" where "Sintetic"='D' and :"Cont"
starting with RTRIM("Cont") into :"Sintetic";
and now it works.
I don't understand why it doeasn't work without RTRIM, because "Cont" is a
VARCHAR field.
Adrian Roman
I changed the query with
select max(RTRIM("Cont")) from "Conturi" where "Sintetic"='D' and :"Cont"
starting with RTRIM("Cont") into :"Sintetic";
and now it works.
I don't understand why it doeasn't work without RTRIM, because "Cont" is a
VARCHAR field.
Adrian Roman