Antwerp
Posts: 24
|
| Posted: 03/17/2005, 8:58 AM |
|
I have an encrypted field that I need to decrypt and display in a text box. I use the following query to decrypt:
SELECT AcctNum, fn_decrypt(MeterReading) as MtrRdg FROM Meter;
** fn_decrypt is a function in my database.
Now, how do I bind this alias (MtrRdg) to my text box and display the value there. I selected the alias as control source for the text box. It did not work. Whatever I do, it displays the encrypted value, not the decrypted value. Obviously, CCS seems to be reading MeterReading (actual column name) as the control source and not the alias.
I checked the query in Data Source SQL builder. It works perfectly. I am at a loss trying to figure out the problem.
|
 |
 |
E43509
Posts: 283
|
| Posted: 03/17/2005, 9:28 AM |
|
Just a few things to try.
Create a view in the db that already has it decrptyed and have CCS look at the view.
Perhaps create that text box as a db expression instead of a db field.
|
|
|
|
|
