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

___________________________________________________________________________

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

___________________________________________________________________________

> 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