On 9/12/10 9:17 AM, ~consul wrote:
> I know that we can drap/drop a pdf file into the database so it resides
> within the database, but that will eventually make the file super large
> over time as it contains both the database and the pdf. A couple of
> years ago when I was in fmp6, I had about 30k records, and inserted 1pdf
> for about 3k records, and it caused instability and corruption of the
> file where random data in random records got lost.
> Or would fmp11 not have this same size limit?
>
> I was wondering if when you drag/drop you can just have the file
> location path?
> I am reading that it has to be in the Web folder in the fmp11adv for it
> to link in the container.
Have never had issues with PDF inserts. These days I usually create a
separate file for images and document tables, in addition to the main
data file (data separation model; user + 2 data files). That generally
allows emailing the main data file (smaller) if necessary.
drag and drop does not work for me
insert file as reference
create a calc (or auto enter text calc) field
GetAsText(<container_field>) to evaluate the path, example result:
file:a.pdf
filemac:/data/cortical/Desktop/a.pdf
> Would fmp11server help out?
the FM file can reside on the server if need be, and one can insert
referenced local files. If things change however (paths...) references
will of course be lost. So an auto enter text calc will retain the path
info, and manipulations can be undertaken...
>> Stay informed about: fmp11adv linking pdfs/folder with database 
FAQ
Search
Profile
Private Messages
Log in
