Tech Tip: Query by picture weight
PRODUCT: 4D | VERSION: 15.x | PLATFORM: Mac & Win
Published On: June 30, 2017
The Query Editior provides a way to query picture field by it's weight as shown below:
This can also by done programatically with QUERY BY FORMULA:
1. Weighs at least
QUERY BY FORMULA ([Table];Picture size([Table]Field)>=n)
2. Weights a maximum of
QUERY BY FORMULA ([Table];Picture size([Table]Field)<=n)
n - number that can be bytes, Kbytes, Mbytes, & Gbytes
Example of finding a picture of atleast 1024 bytes:
QUERY BY FORMULA([Table_1];Picture size([Table_1]Field_picture)>=1024) |