PC SOFT

ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • Overview
  • Specific columns
  • "Record number" column
  • "Magnifier" column
  • Special cases
  • Special case: Text Memo item
  • Special case: Binary Memo item
  • Special case: Composite keys
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
This help page presents the special display cases in WDMap:
  • The "Record number" and "Magnifier" columns.
  • The display of memo items and composite keys.
Remark: From version 19, HFSQL is the new name of HyperFileSQL.
Specific columns

"Record number" column

When viewing a HFSQL data file, the "Record number" column appears. The record number is used to identify and/or handle each one of the records found in a HFSQL data file.
Remark: You cannot:
  • Modify the record numbers.
  • Sort the record numbers (in ascending or descending order).
  • Move the "Record number" column.
  • Find a record number.

"Magnifier" column

The "Magnifier" column is used to view the linked data. For an order, you have the ability to view the order lines and the corresponding products.
To view the linked data:
  1. Click the "Magnifier" column. You get the list of linked files and the name of the item on which the link is performed.
  2. Select the file to view and validate. The list of records for the linked file corresponding to the item selected in the main file appears.
Special cases

Special case: Text Memo item

The option "Parameters .. Multiline memo column" is used to display:
  • The first line of the text memos. This option is used to optimize the view of all the file records.
  • The full content of the text memos. The corresponding columns become multiline. The height of the table rows is proportional to the size of memos.
To view the entire text memo and/or to modify the content of a text memo:
  1. Select the memo column of the requested record.
  2. Select "Edit .. Memo column".
  3. The content of the selected text memo appears in a specific window.
Remark: The content of a text memo can also be modified from the viewing table of WDMap.

Special case: Binary Memo item

WDMap allows you to change, export and play the binary memos.
To change the binary memo associated with the item:
  1. Double-click the cell containing the binary memo. The modification window of the binary memo is displayed.
  2. Click the "Import" button. A file picker is displayed.
  3. Select the new binary memo.
To export a binary memo to a new file:
  1. Double-click the cell containing the binary memo. The modification window of the binary memo is displayed.
  2. Click the "Export" button. A file picker is displayed.
  3. Enter the name of the file to generate. By default, the name and extension of the file associated with the binary memo are proposed.
To play a binary memo:
  1. Double-click the cell containing the binary memo. The modification window of the binary memo is displayed.
  2. Click the "Play" button.
    Remark: This button is active only if the memo can be run.

Special case: Composite keys

By default, the "composite key" items are not displayed in WDMap.
To display the "composite key" items, select "Display .. Display the composite keys".
The different values of a "composite key" item are separated by commas.
In the following example, the "composite key" item named DATECODENAME is made of the ORDDATE, ORDCODE and NAME items.
To avoid displaying the "composite key" items, select "Display .. Remove the composite keys".
Remark: To modify the value of a "composite key" item, modify the values of the different items found in the "composite key".
See also
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment