Hi, Jason and others:

I need to reask this question, since the ColumnCoding routine works with
SELECTS and not with UPDATES/INSERTS. I had it backwards.

It seems to me that I could use the IBO str2str routine in passing
parameters to the UPDATE or INSERT to achieve what I am looking for,
which is a possible end run around the VPS installed Firebird not
accessing the UDF library FreeUDFLib.dll which has F_STR2STR.

Thank you,

Chuck

On 7/25/2018 1:47 PM, Chuck Belanger phytotech@... [IBObjects] wrote:
> Hi, Jason:
>
> I am reaching out to plan for what may be an issue around using an UDF
> dll on a VPS remote server. I just posted my problem with the inability
> to access FreeUDFLib.dll on the VPS, but it works just fine on my local
> machine and even on an older FTP server, remotely.
>
> Anyway, a while back, you added Str2Str as a routine to IBO. This
> function I have been accessing via the UDF for SELECTS and using your
> IBO ability to call the function for UPDATES and INSERTS via
> IB_Connection.OnColumnCoding event. Str2Str is an XOR routine to
> scramble text.
>
> My question is:
>
> Can I use your Str2Str for SELECT statements, thus negating the need for
> use of the UDF? Not sure how I would do this. If so, can you advise how
> I would set this up?
>
> Thank you!
>
> Chuck
>
>
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
>
>
> ------------------------------------
> Posted by: Chuck Belanger <phytotech@...>
> ------------------------------------
>
> ___________________________________________________________________________
> 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 !
> http://tracker.ibobjects.com - your portal to submit and monitor bug reports
> http://community.ibobjects.com - your portal to purchase and upgrade
> ------------------------------------
>
> Yahoo Groups Links
>
>
>
>