we have database fields which has file links like '\\servername\fold1\fold2\file.pdf'
When I specify URL for this column, the display is right. But the link is interpreted as
'\servernamefold1fold2file.pdf' (relative URL, which obviously is not correct)
The culprit seems to be the escape character backslash.
Any ideas how to solve this within webfocus? I cannot get this done on the DB side.
I have used a different technique to get this done for HTML O/P
COMPUTE LINK/A540 = IF &WFMT EQ 'HTML' THEN '
' || LINK || '';
Which gets rendered as required by the browser. However this approach does not work with the PDF output.
I believe there should be a more sane and practical solution which works both for HTML and PDF(Something like the STRREP function, But this also doesn't seem to work as desired, can't figure where the problem is).