PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Overview
  • How to proceed?
  • Managing HFSQL thumbnails
  • WLanguage properties associated with the HFSQL thumbnails
  • Notes
  • Size of control displaying the image and size of thumbnail
  • Number of thumbnails
  • Limitations
  • Version 9 and earlier
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Overview
To optimize the display of images in your application or in your site, you have the ability to use HFSQL thumbnails.
A HFSQL thumbnail corresponds to an image automatically generated from an image stored in a HFSQL binary memo. One or more thumbnails of different sizes can be generated for each HFSQL binary memo item.
For example, the "ProductImage" item allows you to generate two HFSQL thumbnails:
  • a small thumbnail used in a Looper control,
  • a larger thumbnail used in the product forms.
The thumbnail that best suits the control used to display the image will be automatically selected by the HFSQL engine.
Notes:
  • WEBDEV - Server code We advise you to display the thumbnails in a Thumbnail control (and not in an Image control).
  • The thumbnails are not available when accessing a database via Remote access.
Linux To use the HFSQL thumbnails in Linux, the libfreetype6 library (libfreetype.so.6) must be installed on the current computer.
Versions 17 and later
WINDEV MobileiPhone/iPad This feature is now available for the iPhone/iPad applications.
New in version 17
WINDEV MobileiPhone/iPad This feature is now available for the iPhone/iPad applications.
WINDEV MobileiPhone/iPad This feature is now available for the iPhone/iPad applications.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
How to proceed?

Managing HFSQL thumbnails

To manage the HFSQL thumbnails:
  1. In the data model editor, select the data file containing the HFSQL binary memo item.
  2. Double-click the data file to display the description of items.
  3. Select the requested item.
  4. Check "Automatic management of thumbnails" and click the "Edit" button.
  5. Specify the width and height (in pixels) of each thumbnail to generate.
  6. Validate.
Note: The HFSQL thumbnails of an item are automatically generated:

WLanguage properties associated with the HFSQL thumbnails

The following WLanguage properties are used to manage the HFSQL thumbnails:
Versions 10 and later
InfoThumbnailGeneration
New in version 10
InfoThumbnailGeneration
InfoThumbnailGeneration
..InfoThumbnailGeneration is used to find out whether the thumbnails of an item have been successfully generated.
Versions 10 and later
MaxThumbnailHeight
New in version 10
MaxThumbnailHeight
MaxThumbnailHeight
..MaxThumbnailHeight is used to find out and modify the maximum height of an item thumbnail.
Versions 10 and later
MaxThumbnailWidth
New in version 10
MaxThumbnailWidth
MaxThumbnailWidth
..MaxThumbnailWidth is used to find out and modify the maximum width of an item thumbnail.
Versions 10 and later
NbDescribedThumbnail
New in version 10
NbDescribedThumbnail
NbDescribedThumbnail
..NbDescribedThumbnail is used to find out the number of thumbnails described for an item.
Versions 10 and later
NbThumbnail
New in version 10
NbThumbnail
NbThumbnail
..NbThumbnail is used to find out the number of thumbnails generated for an item.
Versions 10 and later
Thumbnail
New in version 10
Thumbnail
Thumbnail
..Thumbnail is used to:
  • find out the value of an item thumbnail. This item was defined in the data model editor or by programming.
  • find out and modify the image associated with a Thumbnail control.
Notes

Size of control displaying the image and size of thumbnail

The thumbnail that best suits the size of the control used to display the image will be automatically selected by the HFSQL engine.
If the size of the control used to display the image exceeds the size of the largest thumbnail, the image displayed in the control will correspond to the initial image found in the HFSQL binary memo.

Number of thumbnails

In most cases, one or two thumbnails are defined for each HFSQL binary memo. However, several thumbnails can be defined when the image is displayed in several controls of different sizes.
Note: The larger the number of thumbnails per item is, the larger the size of the corresponding HFSQL binary memo will be.
Limitations
The thumbnails are available:
  • in HFSQL Classic and in HFSQL Mobile: for the items found in a data file, in a view or in a query.
  • in HFSQL Client/Server: for the items found in a data file only.
Linux The thumbnails are available in HFSQL Client/Server on the items of a data file.

Version 9 and earlier

The HFSQL thumbnails are not available in version 9 and earlier. Therefore, the records written by a HFSQL 9 (or earlier) engine cannot contain any HFSQL thumbnail.
The table below presents the use of binary memos and thumbnails in an application in version 9 (or earlier) and in an application in version 19 that uses the same data files:
Application (or site) in version 9 and earlierApplication (or site) in version 19
New record written by a HFSQL engine version 9 or earlierImage displayed: Binary memoImage displayed: Binary memo
New record written by a HFSQL engine version 10 and laterImage displayed: Binary memoImage displayed: Thumbnail
Record written by a HFSQL engine version 9 (or earlier) and modified in version 19 (the value of the binary memo item is modified)Image displayed: Binary memoImage displayed: Thumbnail
Minimum required version
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment