Ok, Jason, I'm going to have to let this one go!

I spent a lot of time tracking this one down. It was a user from Mexico.
Hers was the only Patient table that had this problem.

I created the test DB and could not reproduce the "Malformed string"
error using IB_SQL. I went back to her DB, i.e. the one I used to trace
the problem and guess what, everything worked just fine.

As I mentioned I found that using F_Character(##) instead of ', ' worked
fine. Now the pipe (||) with ', ' is working without error.

Chuck

> Strip it down as much as you can. I prefer to avoid messing with UDF's if at
> all possible.
> You can send whatever you decide to send to my private email.
>
> Thanks,
> Jason

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

Hi, Jason:

I'd be glad to do that, but as part of the issue is the use of a
scrambling function that I added to FreeUDB Lib.

Is there any way I can send you this DLL privately, since I obviously do
not want to circulate my "encryption" routine.

It may be easier for both of us if I just send you a stripped down
version of a sample DB for you to play with. Like I said you can see
this behavior in IB_SQL just fine.

Let me know.

Chuck

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