1 Reply Latest reply: Jan 28, 2012 4:30 AM by HakanBiroglu RSS

    Access to encrypted data


      Value "V1" (of the table "PS_T1") is encrypted in database (with the "encrypt" method). A field on a page is prompting on this table. I'd like to decrypt this value "V1" when the user access to the prompt. How can I do this ?

        • 1. Re: Access to encrypted data
          Replace the editbox prompt, with a dropdown on a derived record
          On the rowinit of the dropdown (if on level 1>) or component (if on level 0) create a rowset that fetches the data from the prompt table..

          Now populate the dropdown by looping trough the rowset and decrypt the encrypted data using buildin function Decrypt

          something like this:

          &FLD = GetRecord(Record.[derived]).GetField(Field.[dropdownfield]);

          &rs = CreateRowset(Record.[yourprompttable]);
          &rs .Fill();

          For &I = 1 To &rs.ActiveRowCount
          &CodeIn = Decrypt+(&rs.GetRow(&I).GetRecord(1).FIELD.Value);
          &DescIn = &rs.GetRow(&I).GetRecord(1).DESCR.Value;

          &FLD.AddDropDownItem(&CodeIn, &DescIn);