Chuck,

I didn't notice this issue yet.
Please send me exact instructions, including DDL for the table, to reproduce
this problem.

Thanks,
Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Chuck Belanger
Sent: 15 November 2012 03:23 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] query creating "Malformed String" when it worked
before--Jason?

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

>
>
>
>

------------------------------------

___________________________________________________________________________
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