I'm planning to put into my table a column with folder path, so it will be easy to open a folder with needed files in attributes table. Now I'm wondering if I could open not the folder, but all files in it.
It would be great to just get all pdf in directory, no matter how they are named (so I don't have to store filenames anywhere). But the schema is simple: all files have prefix and number from _1 to _7, eg. a_1.pdf, a_2.pdf, a_3.pdf... But sometimes one of those files is missing.
I tried to put all paths to varchar, as string like "C:\a_1.pdf;C:\a_2.pdf(...)" or as array but "open" doesn't work with more than one path. Any suggestions?