Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 15th September 2017, 08:00
jojovalenton jojovalenton is offline
Senior Member
 
Join Date: Aug 2007
Posts: 184
jojovalenton is on a distinguished road
Baan: InforLN FP7 - DB: SQL Server 2008 R2 - OS: Window Server 2008 R2
encrypt table field data
Baan: ERP LN 6.1 FP7 (Infor ERP 10.1)
C/S: Both

hi,

i need help on how to encrypt data save in table fields same on how dem and tools password were saved in LN tables. using inputfield.password ui fields are star chars but saved in table as normal alphanum. thanks.

regards,
jojo
Reply With Quote
Sponsored Links
  #2  
Old 16th September 2017, 06:15
jojovalenton jojovalenton is offline
Senior Member
 
Join Date: Aug 2007
Posts: 184
jojovalenton is on a distinguished road
Baan: InforLN FP7 - DB: SQL Server 2008 R2 - OS: Window Server 2008 R2
i think encryption in LN something like creating GUID id but anybody knows how to do this via LN scripts?
Reply With Quote
  #3  
Old 18th September 2017, 08:21
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,286
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
TIV starting from 2000 supports cipher.* functions which you can use to store the passwords using AES algorithms. Take a look at the latest programmers guide on the examples of how to do it.

If not, you need to use some external utility where you will pass the string value to it and it will output the encrypted version.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #4  
Old 18th September 2017, 19:38
jojovalenton jojovalenton is offline
Senior Member
 
Join Date: Aug 2007
Posts: 184
jojovalenton is on a distinguished road
Baan: InforLN FP7 - DB: SQL Server 2008 R2 - OS: Window Server 2008 R2
hi,
thanks for reply. i will explore this idea.

regards,
jojo
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to update the data to another table when delete the one data tracylee Tools Development 6 28th August 2015 09:38
Auto populate table field based on two other fields pjohns Tools Development 2 25th September 2013 15:58
Inserting data on a table using vars _Ralph_ Tools Development 3 16th February 2007 11:50
Session Report: Table & Columns Referenced by Session KBacca Tools Development 7 11th October 2006 15:05
Tables used for MRP and PRP. BurghMan Tools Development 1 10th February 2005 14:08


All times are GMT +2. The time now is 20:41.


©2001-2017 - Baanboard.com - Baanforums.com