Hi, Jason:

Did you see this?

"Still why the problem with concantenating with ', ' ?"

Chuck Belanger

> 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
>>
>>
>>
>>
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> 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
>
>
>
>