Hi folks,
I have discovered a filter table loop issue when using the decrypt function
referencing a table column.
The workaround I have discovered is simply to reference the same column in a
separate, redundant, simple set fields assignment.
I post the details here for others to note - possibly even BMC.
ARS 6.3 p 13 Windows (forgive me!)
Oracle 9.2.0.1.0 Windows
Schema:
X char 0 used for redundant assignment
Key char 30 encrypt / decrypt key
Src char 30 DO encrypt / decrypt src string
Val char 30 DO encrypt / decrypt working string
t tbl table loop table
tCry col encrypted string table column
tId col table column with record id
filter launches the table loop guide
The first one fails! Val is assigned ""
The second guide succeeds!
guide (failing):
set fields Val = decrypt(tCry, Key)
guide (succeeding):
set fields X = X + tCry + "; "
set fields Val = decrypt(tCry, Key)
Cheers
Ben Chernys
Senior Software Architect
Software Tool House Inc.
Canada / Deutschland / Germany
Mobile: +49 (0162) 175 0956 GMT + 2
Email: mailto:[EMAIL PROTECTED]
Web: http://www.softwaretoolhouse.com
A free notepad for Diary fields:
http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm
An ARS integration, import, batch facility:
http://www.softwaretoolhouse.com/products/SthMupd
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
