|
| [WD20] Automatic Thumbnail on Image Field |
| Iniciado por guest, 21,jul. 2016 17:00 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 21,julio 2016 - 17:00 |
Is there a way to get a thumbnail of an image field from an SQL query?
IMG_Product = Product.Image // Gets full image even though the control is 135 x 90 pixels IMG_Product = Product.Image..Thumbnail // Works, gets the 320x320 auto thumbnail IMG_Product = dsResult.Image..Thumbnail // Doesn't work, gets no image
Also, is there a way to generate thumbnails for all of the Product records that already have an image?
EDIT: Just curious, has anyone had any major issues with automatic thumbnails?
Thanks! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 21,julio 2016 - 22:12 |
So far it seems like my looper is going to load a lot faster if I use my own image memo field. When I create a product I save the high quality image to Product.Image. Then I load the image in an off-window image control with the resolution I want for my thumbnail. Then I save it to a file with dSaveJpeg(). Finally I save that lower resolution file to Product.ImageThumbnail.
I get all Product.ImageThumbnail in my SQL query when loading my looper control. This seems to be faster than using automatic thumbnails. |
| |
| |
| | | |
|
| | | | |
| | |
|