Hi all, ARS 6.3
I am trying to separate the file name out of the path by using an active link to add an attachment in a Display-only attachement field. The first action works properly because I can use another action to set the field in a character field and then I see the path and the file name. However, I would like to have the path in one charater field and the file name in another character field. To achieve this(I started with the file name) someone recommended me to use a Set Field SQL as shown below. However, it does not work when I use the variable($ProdlistFileLocation$) which is my attachement field. I receive a memory error and my client crashes. If I manually add the string in the SQL function is works: SELECT SUBSTR ('\\path\path\path\path\FileName.ext',(INSTR ('\\path\path\path\path\FileName.ext','\',-1))+1) FROM DUAL There is something I dont get. Also if I set a character field containing the string mentioned above (\\path\path\path\path\FileName.ext) it works. Is this a bug? *************************** $ProdlistFileLocation$ = $536880933$ Active Link: Action#1 Run Process PERFORM-ACTION-ADD-ATTACHMENT 536880933 Action#2 Set Field SELECT SUBSTR ('$ProdlistFileLocation$',(INSTR ('$ProdlistFileLocation$','\',-1))+1) FROM DUAL *************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org