Hum,

I really think it doesn't do the conversion automatically... I tried
first without the cast and the result wasn't as expected (hoped). But it
works with the cast...

Any further comments?

Henrik

-----Original Message-----
From: Milan Babuskov [mailto:albis@...]
Sent: 21. januar 2004 16:41
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] sql question

Henrik Sitter wrote:

> I tried the following at it seems to do the trick:
>
> if (exists(select 1 TABLENAME, COLUMNNAME, cast(COLUMNVALUE as

Integer)

> from USED_TABLE
> where ((TABLENAME = 'ARTNR_SW_TABELL') and (COLUMNNAME =
> 'SW_ARTNR') and (COLUMNVALUE = :IN_SW_ARTNR)) )) then
> begin
> .
> .
> end

Here the Firebird did the conversion for you automatically.
It should work the same without CAST().

--
Milan Babuskov
http://fbexport.sourceforge.net





Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/