I have a container field and I am using the GetFileAsContainer function in a SetField statement to insert a PDF file. I keep getting an error every time I enter the path to the file. The statement looks like this: GetFileAsContainer( e:invoices$$filename)&".pdf"

I tried using quotes forward and back slashes, filewin: prefix...you name it and I still get a table not found error. What is the proper syntax for the path to file statement.

Help

Make sure that you have the whole path other than the field/variable name in quotes, and that the full file is within the GetFileAscontainer function parameters.

For example, you would set the calculation to be:

GetFileAsContainer( "c:/testfolder1/" & $$var1 & "logo.gif" )

or 

GetFileAsContainer( "c:/testfolder1/myfolder/" & $$filename)

if the "$$filename" variable includes the ".gif", ".pdf" or other extension.  If it does not, you can use 

GetFileAsContainer( "c:/testfolder1/myfolder/" & $$filename & ".pdf")

Also, please post all future ScriptMaster questions in the ScriptMaster forum of the 360Works section.

Edited August 3, 200916 yr by Guest

is this command embedding your PDF inside your data file? Does anyone know how to use this command to Reference the PDF instead?

This can be done with the "Insert File" script step with the "store only a reference" box checked.