Archive for the ‘external file’ tag
A better widget for capturing the fully qualified external file name
I’ve updated the how to return a fully qualified BFILE
name from a function. The new function lets you select the fully qualified file name from a BFILE
column, like:
SELECT get_canonical_local_bfilename(item_photo) AS file_name FROM item WHERE item_id = 1021; |
In my test environment, it returns:
FILE_NAME ------------------------------------------ C:\JavaDev\BFileFramework\HarryPotter1.png |