I have a script that does the following:
1. creates a new record in a log table (TableA)
2. downloads a file via the Insert from URL script step and stores that in a container field in the new record (regular container field - not external storage)
3. commits the record
4. sets a local variable $attachment to the container field value
It then deletes the newly created record and changes context to create some additional records in a different table (TableB). It then sets a container field with the $attachment variable value, e.g.
Set Field [TableB::attachment ; $attachment ]
I"m getting an error at this step - error 10 (Requested data is missing). I can see the variable is showing in the Data Viewer (showing the file name of the container) but for some reason it appears to not retain the container data when I attempt to populate other container fields with the same container file.
I'm wondering if deleting the record that it was originally stored in also deletes the storage of the container in the variable as well? Haven't done a similar process before so this is all new to me.