I'm trying to work with InterBase and its (column level) encryption facility.
After doing the ground work, I start to select (and show) data from a
table with some encrypted columns.
This works in IBConsole as I'm prompted for a password string when doing
select *
from MAOSPC_P
where a field (FNR) in the table (MAOSPC_P) is encrypted.
If I give the wrong password, there's an error message (nothing shown).
If I cancel, only the non-encrypted columns are shown.
If I give corect password, everything shows.
Fine.

Now, how can I let a user (read: Delphi application) handle this?
How can I serve up the relevant password(s)?

If I try the same select with IB_SQL (IBO/4.8.7) the result is an
error message:
ISC ERROR CODE 335544845
encryption password not set for column MAOSPC_P.FNR
which (of course) is correct. But I don't know how to provide the
password in this situation.

I'm using D/2007 and D/2010 (and IBO/4.8.7 and IBO/4.9.9).
Also IB/2009 (developer version).
(I don't know how IBX handles this)


--
Aage J.