If the image is inserted "by reference", GetValue ( ContainerField ; 1 ) will return the pixel x pixel dimensions of the inserted image. To see all the data entered when an image or file is inserted "by reference", you can place a calculation field defined to return text with the name of the container field as its only term next to your container field.
GetValue(PhotoTableInFM::PhotoContainerInFM; 1 ) return the photoPath,only !
PhotoTableInFM::PhotoContainerInFM is a container in FM database
OH I SEE MY PBM:
IF I right click the container and do insert image by ref then the GetValue(PhotoTableInFM::PhotoContainerInFM; 1 ) retrun my dimmension
BUT! in my case I'm doing in another way, from the database.
the container im the DM is created as: "PhotoContainerInFM, container, auto-enter calculation existing value",
and the calculated value of this field = Photo::PhotoContainerInFM
so when i use this i cannot get my pic dimmensions. and whu this? caue Photo::PhotoContainerInFM is reading from PhotoPath (i join here the other questions I posted :) )
so it's a weird dilemma
One option would be to use a script that uses this path to re-insert the photo (by reference) to get the full set of data normally found in the container field when it is inserted as a picture. That could involve a massive scripted update the first time around and significant delays during import of large numbers of new records with links to photos, but it would work.
yes, exactely !
how can i make this script?
another wy is to process the script only for the record thatthe user want browse, cause i don't want my database to be so big i nterm of size
Reinserting the picture file with store by reference enabled should add very little to the total size of your file as this simply inserts a few more lines of text into the container field--one line being the size information that we want.
Set Variable [$path ; value: //put expression for path to image file here. Either your original file path field or the container field can be used here]
Go to Field [YourTable::ContainerField ] // field must be present on current layout and focus must be set on this field for next step to work.
Insert Picture [Reference ; "$path"]
you are the best, i'll try it now
use & instead of +.
In a test file, I was able to just reference the filepath row of text from the container field and it worked without modification.
Then you don't need to append "C:" to the beginning of it.
The use of \ instead of / may be the problem.
Substitute ( PhotoPath ; "\\" ; "/" )
\ is a special "escape" character in FileMaker strings so you have to use it twice to get it to evaluate in the quoted string as a single \ character.
i replaced \ by /
now i have the error:
the file 24.jpg could not be found and is required to complete this operation
my photopath = C:/Users/Wissam/Documents/CPEL-Archive/ARPIC/DB Bakup/MEDIUMtest/24.jpg
Is 24.jpg the name of the file?
Is it found at the location indicated by this file path?
Is 24.jpg the exact file name (no spaces)?
yes, the name is 24