3 Replies Latest reply on Sep 22, 2011 9:39 AM by philmodjunk

    getastext calculation yields strange result on imported images



      getastext calculation yields strange result on imported images



      I am creating a database that uses lots of images.

      I am about to import the images and will be using the "store as reference"option.
      There is also a calculation field which simply is - GetAsText ( photo )

      When I insert a picture individually, say by right-clicking and Insert Picture the calculation works and I get three lines of text

      However, when doing mass import via File -> Import Records -> Folder the GetAsText calculation gives me strange result which is just one line

      In both cases I am selecting import/store as reference.

      As I have further calculation fields that rely on the initial GetAsText calc, they don't all work as I am getting different results depending on which method used to import the picture.

      Is this normal, or is there something I am doing wrong?

      Thank you.

      I am using using FM Pro 11.0v1 on windows 7 Pro