Can it be rewritten to conform to 1.5 syntax

-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Ivan C Cruz
Enviada em: segunda-feira, 14 de novembro de 2005 21:04
Para: firebird-support@yahoogroups.com
Assunto: Re: RES: [firebird-support] Re: soundex

Andre Fogelman escreveu:

>I tried to create the procedure but I get an error on the following
>line:
>
> vCurrChar = CAST(SUBSTRING(ipWORD FROM :vidx FOR 1) AS CHAR(1));
>
>

Firebird 1.5 does not accept variables on FROM and FOR.
That limitation was removed on FB 2.

Ivan.




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links