Alan I mistread sure my advise was for Sytze. And Ted yes I am with you when changing functional good running code. However Sytze has a problem with exactly that. So in this case it is my opinion to change completely and dont store anything in a General Field but change the code I am sure he will solve his problem that way. Koen
Op dinsdag 26 juli 2016 heeft Alan Bourke alanpbourke@fastmail.fm het volgende geschreven:
Alan,
Donot store anything in GeneralFields, and if you must than donot.
I don't. The original questioner did.
Just store the fullpath in of the .doc .xls or whatever file in your memo field.
I generally store a relative path beneath a defined root location and retrieve files when needed as root location + relative path.
Storing a full UNC path or (shudder) path with a drive letter is a bad idea because you'll have to re-path everything when the server changes or the data\external files are otherwise moved, or file shares change. If you do it the way described above you only have to change the root location definition in one place.
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]