Just a side comment, but you really ought to rethink that. If you're using a homegrown crypto system of any kind, instead of a well-tested, mature library, you're just asking to be hacked. And if you feel the need to keep it secret for any reason, you're falling afoul of Kerckhoffs' Principle, one of the fundamental principles of sound cryptography.

The only thing you should ever need to keep secret in any crypto system is the key. If not, you are absolutely Doing It Wrong.

Mason

--- In IBObjects@yahoogroups.com, Chuck Belanger <phytotech@...> wrote:
>
> 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
> >
> >
> >
> >
>