I found out some more information and a work around, but there is still
a problem here:
1. The error is reproducible in IB_SQL. (works fine otherwise in IB_Expert)
2. If I limit the concantenation to one set of pipes, the query opens fine.
3. If I replace the comma and space with F_Character(44) ||
F_Character(32) || it now works fine and gives me the LastName, First
Name format I wanted.

Still why the problem with concantenating with ', ' ?

Chuck

> Hello:
>
> Below is a query using in XE2, IBO 5+ beta. Originally, IBOQuery, then
> tried IB_Query both threw a "Malformed String" error followed by a I/O
> 32 Error. Interestingly, this did not trigger a madExcept error.
>
> This query works just fine off the same DB within the SQL Editor of
> IB_Expert.
>
> SQL.Add('Select pt_id, F_Str2Str(Name_Last,'+InttoStr(TV.HPW)+')||'',
> ''||');
> SQL.Add('f_str2str(Name_First,'+inttoStr(TV.HPW)+') as FullName FROM
> Patients');
> SQL.Add('order by Name_Last');
> Open;
>
> If I remove the concantenation and separate the last and first names
> then it opens fine.
>
> SQL.Add('Select pt_id, F_Str2Str(Name_Last,'+InttoStr(TV.HPW)+'), ');
> SQL.Add('f_str2str(Name_First,'+inttoStr(TV.HPW)+') as FullName FROM
> Patients');
> SQL.Add('order by Name_Last');
>
> f_str2str() is a udf to scramble the patient table columns.
>
> This has worked fine in D2007/Win7 environment and even with other DBs
> in this newer XE2 version of my application. The only difference is that
> this Patient table does have Hispanic names in it with the various
> characters to support that.
>
> What's going on?
>
> Thank you,
>
> Chuck Belanger
>
>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links
>
>
>
>