-----Original Message-----

> SPs expect constants as input. 'a'||'b' is an expression. If you

need to

> pass an expression, you'll have to resolve it to a constant in the

host

> language. What you need to do is prepare the statement with a

replaceable

> parameter and then have your application pass the resolved expression

to

> the parameter before executing.
> e.g. in Delphi I would do

> Sql.clear;
> Sql.add(execute procedure foo(:result));
> Prepare;
> Params[0].AsString := 'a' + 'b';
> Execute;

Hellen,

Would:

execute procedure foo(CAST('a' | 'b' AS VARCHAR(10))

or the like work?

George



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/


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.524 / Virus Database: 321 - Release Date: 10/6/2003


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.524 / Virus Database: 321 - Release Date: 10/6/2003