Script to embed pictures

[adyf]

I have a container field in a table that contains pictures that are linked only. I would like to make the file more portable by having the pictures embedded instead of linked as I don't always have network access to the server where the pictures are stored. I have tried to run a loop script that copies and pastes from the original container field into a new one but it only copies the link. Insert picture function dialogue box only seems to give you the option of adding a file path and not a field itself. Is there a way of doing this or will I need to do it manually?

[eos]

In your looping script, use a variable as path for Insert Picture. For each loop iteration, set this variable dynamically to your stored file path.

[adyf]

use a variable as path for Insert Picture.

Thanks for your reply, could you give me a little more info on how to do this please? I haven't got round to using variables yet.

[eos]

Basically (meaning: without error trapping and the usual script paraphernalia) it looks like this:

Go to Record/Request [ First ]

Loop

Set Variable [ $path ; Value: yourTable::imagePathField ]

Go To Field [ yourTable::yourContainerField ]

Insert Picture [ "$path" ] // that's how it shows in the script, but you write/insert the variable name without quotes. Also make sure to uncheck the Store only a reference option

Go to Record/Request [ Next ; Exit after last ]

End Loop

Maybe best to experiment with a subset of a few records until you've got it right.

[adyf]

Basically (meaning: without error trapping and the usual script paraphernalia) it looks like this:

Go to Record/Request [ First ]

Loop

Set Variable [ $path ; Value: yourTable::imagePathField ]

Go To Field [ yourTable::yourContainerField ]

Insert Picture [ "$path" ] // that's how it shows in the script, but you write/insert the variable name without quotes. Also make sure to uncheck the Store only a reference option

Go to Record/Request [ Next ; Exit after last ]

End Loop

Maybe best to experiment with a subset of a few records until you've got it right.

Thanks for the detailed explanation, I'll try it at work tomorrow.