AnsweredAssumed Answered

Finding ALL Container File Sizes that are too big.

Question asked by blewvelvet on Aug 23, 2012
Latest reply on Aug 23, 2012 by philmodjunk

Title

Finding ALL Container File Sizes that are too big.

Post

Ok..so I'm trying to create a script that looks at each record's file containers and to keep only the records which may have one container that is larger than .6 MB in a found set.

It first constrains a found set of records that first removes my administrative records.

---------------------------------------Ok..so I

SHOW ALL RECORDS

CONSTRAIN FOUND SET (removing the admin records) - works great up till "If" below:

IF ((aPROJECTS::FILE SIZE Container Call Sheet D1 < .6)   &     
(aPROJECTS::FILE SIZE Container Call Sheet D2 < .6) &
(aPROJECTS::FILE SIZE Container Call Sheet D3 < .6) &
(aPROJECTS::FILE SIZE Container Call Sheet D4 < .6) &
(aPROJECTS::FILE SIZE Container Call Sheet D5 < .6) &
(aPROJECTS::FILE SIZE Container Call Sheet D6 < .6) &
(aPROJECTS::FILE SIZE Container Call Sheet D7 < .6) &
(aPROJECTS::FILE SIZE Container Call Sheet D8 < .6) &
(aPROJECTS::FILE SIZE Container Call Sheet D9 < .6) &
(aPROJECTS::FILE SIZE Container Call Sheet D10 < .6) &
(aPROJECTS::FILE SIZE Container Call Sheet D11 < .6) &
(aPROJECTS::FILE SIZE Container Call Sheet D12 < .6))

OMIT RECORD

ELSE  Go to Record....[Next; Exit after last]

End If

---------------------------------------

- in other words...if all of these container fields is less than .6 MB then OMIT and go to the next one.

I retyped this all so it may not be perfect...but is there anything funny here as to my addressing the file size in the "If" statement?
Should I be using "&" or "and"?

Each PDF container fields use a calculation of:  (Length(CONT CALLSHEET 1)/1024) / 1000   - to get to the .decimal number..the format is fixed number of decimals - 2

 

Screen_Shot_2012-08-23_at_11.48.54_AM.png

Outcomes