ONLINE HELP
 WINDEV, WEBDEV AND WINDEV MOBILE

Version: 2025
HAdd (Example)
Usage example of the HAdd function
NewRecord (Property)
The NewRecord property is used to determine if the record is a new record or if it comes from the data file.
HErrorStatusModification (Function)
Returns the status of a record during a modification conflict.
<Source>.ErrorModification (Function)
Returns the value of a record item when a modification conflict occurs..
ImageInfoSave (Function)
Saves the modifications performed on the Exif tags of an image by ImageInfoModify.
Assignment of RETURN
The return value of the process currently run can be assigned...
<Source>.ErrorStatusModification (Function)
Returns the status of a record during a modification conflict.
<Source>.FreeQuery (Function)
Releases query resources (following use of HExecuteQuery or HExecuteSQLQuery functions).
HFreeQuery (Function)
Releases query resources (following use of HExecuteQuery or HExecuteSQLQuery functions).
HErrorModification (Function)
Allows you to:
  • return the value of a record item if a modification conflict occurs.
  • check if a modification conflict occurred.
CameraStatus (Function)
Returns the status of a Camera control.
AndroidiPhone/iPad Function kept for "Version-26-compatible" Camera controls.
ThreadResume (Function)
Resumes the execution of a thread that was interrupted by ThreadSuspend. Function not recommended.
How do I run a data file with a filter?
HLockRecNum (Function)
Locks a record and restricts the access to this record for all the other applications.
VideoStatus (Function)
Returns the status of a Camera control.
AndroidiPhone/iPad Function kept for "Version-26-compatible" Camera controls.
<Camera>.Status (Function)
Returns the status of a Camera control.
AndroidiPhone/iPad Function kept for "Version-26-compatible" Camera controls.
ThreadSuspend (Function)
Temporarily suspends the execution of the specified thread. Function not recommended.
HFlush (Function)
Forces the operating system of the computer where the data files are found to write data onto the disk.
<Source>.LockRecNum (Function)
Locks a record and restricts the access to this record for all the other applications.
HRecordToXML (Function)
Retrieves the structure and the value of the current record and exports them into a character string in XML format.
Linking a Table control to a data file or query
A Table control can be used to display the content of a data file or query...
<Camera>.VideoStop (Function)
Stops the video recording previously started by CameraVideoStart.
TableRecNum (Function)
Returns the number of the current record in a Table control based on a data file.
PhotoRunApp (Function)
Starts the native camera application of the device in order to take a photo.
URI (Variable type)
The URI (Uniform Resource Identifier) type identifies physical or abstract resources (e.g. files or Web pages).
<Source>.Seek (Function)
Positions on the first record of the data file whose value for a specific item is greater than or equal to a search value (generic search by default).
CameraVideoStop (Function)
Stops the video recording previously started by CameraVideoStart.
HLinkMemo (Example)
Usage example of the HLinkMemo function
HSeekFirst (Function)
Positions on the first file record whose value for a specific item is greater than or equal to a sought value.
<Source>.SeekFirst (Function)
Positions on the first file record whose value for a specific item is greater than or equal to a sought value.
<Table>.RecNum (Function)
Returns the number of the current record in a Table control based on a data file.
HCheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
<Source>.CheckUnaltered (Function)
Checks that one or all records in an unalterable data file have not been modified (e.g. with a hexadecimal editor).
HForward (Function)
Moves several records forward from the current position in the data file, according to a specified item.
<Source>.Forward (Function)
Moves several records forward from the current position in the data file, according to a specified item.
CameraVideoStart (Function)
Starts recording a video via a Camera control in an Android or iOS application.
HErrorIntegrity (Function)
Used to check whether an integrity error occurred.
<Camera>.VideoStart (Function)
Starts recording a video via a Camera control in an Android or iOS application.
Record (Variable type)
The Record type is used to save the values of a record.
<Source>.RecordToXML (Function)
Retrieves the structure and the value of the current record and exports them into a character string in XML format.
HSeek (Function)
Positions on the first record of the data file whose value for a specific item is greater than or equal to a search value (generic search by default).
HErrorDuplicates (Function)
Used to check whether a duplicate error occurred.
<Source>.LinkMemo (Function)
Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item.
HRecNum (Function)
Returns:
  • the number of the current record in the HFSQL data file.
  • the number of the current record in the HFSQL view.
<Destination>.CopyRecord (Function)
Copies:
  • the content of the current record (loaded in memory) to the current data file record.
  • the content of the Record variable to the current data file record.
<Source>.RecNum (Function)
Returns:
  • the number of the current record in the HFSQL data file.
  • the number of the current record in the HFSQL view.
iEndReport (Function)
Forces the report print to stop.
HReadLast (Example)
Usage example of the HReadLast function
fWriteLine (Example)
Usage example of the fWriteLine function
<Table>.Save (Function)
Updates or adds the record bound to the current row in the Table or TreeView Table control.
HLast (Function)
Sets the position on the last record of a data file according to a browse item.
MemAdd (Function)
Adds an element to a memory area.
<Source>.Last (Function)
Sets the position on the last record of a data file according to a browse item.
<Source>.RestorePosition (Function)
Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers.
HErrorLock (Function)
Used to check whether a lock error occurred.
HFound (Function)
Checks whether the current record corresponds to the current filter or search.
<Source>.Found (Function)
Checks whether the current record corresponds to the current filter or search.
HUnlockRecNum (Function)
Unlocks a record locked by:
  • HLockRecNum,
  • a read function used with a locking parameter (HRead associated with the hLockWrite or hLockReadWrite constant for example).
ImageInfoModify (Function)
Modifies the value of an Exif tag for the image used.
<Source>.RecordToString (Function)
Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
HOut (Function)
Used to find out whether the record on which you want to be positioned is located outside the data file, filter, view or query.
TableSave (Function)
Updates or adds the record bound to the current row in the Table or TreeView Table control.
HCopyRecord (Function)
Copies:
  • the content of the current record (loaded in memory) to the current data file record.
  • the content of the Record variable to the current data file record.
<xmlDocument variable>.BuildString (Function)
Retrieves and formats the content of an XML document.
Structure of log files (HFSQL Classic)
The following files are automatically created when logging an HFSQL Classic data file...
HModify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
VideoStartApp (Function)
Starts the device's native camera application to record a video or to take a photo.
<Source>.RetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
HDeclareExternal (Example)
Usage example of the HDeclareExternal function
XMLAddAttribute (Function)
Adds an attribute into an XML document.
<Source>.ListItem (Function)
Returns the list of items in a data file (query or view) recognized by the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
HSynchronizeReplica (Example)
Usage example of the HSynchronizeReplica function
XMLAddChild (Function)
Adds a child tag into an XML document.
HLinkMemo (Function)
Used to associate a file with a binary memo item or to cancel the existing link between a file and a binary item.
<Source>.ToPage (Function)
Automatically updates the controls of a page with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
<Source>.Modify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
WindowFromSource (Function)
Automatically initializes the controls of a window with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
HSeekLast (Function)
Sets the position on the last file record whose value for a specific item is less than or equal to a sought value.
<Source>.ReadSeek (Function)
Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search).
HRecordToString (Function)
Converts the content of the current record to string (in a data file, HFSQL view, query, etc.).
PageFromSource (Function)
Automatically updates the controls of a page with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
dbgEndMemoryDiff (Function)
Saves a memory dump containing the memory resources that have been allocated and that have not been freed since the previous call to dbgStartMemoryDiff.
<Source>.Add (Function)
Adds:
  • the record found in memory into the data file (query or view).
  • the record found in a Record variable into the data file (query or view).
SourceToPage (Function)
Automatically updates the controls of a page with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
HReadFirst (Function)
Positions on the first file record according to a browse item.
FileToPage (Function)
Automatically updates the controls of a page with:
  • the values of the bound items in the current record (loaded in memory) of the data file described in the data model editor. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
  • the values of the bound WLanguage variables. This operation is performed regardless of the state of the controls (grayed, inactive or invisible).
RequestRefreshUIElement (Function)
Requests the execution of the "Request for refreshing the display" event of the specified element (and gives back control without waiting for the execution of the event).
<Page>.FromSource (Function)
Automatically updates the controls of a page with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
<Element>.RequestRefreshUI (Function)
Requests the execution of the "Request for refreshing the display" event of the specified element (and gives back control without waiting for the execution of the event).
Handling HTML text in an Edit control
WEBDEV allows you to manipulate text in HTML via the "HTML format" option of the Edit controls and the HTML control.
OKCancel (Function)
Displays a message in a standard dialog box that proposes "OK" and "Cancel" and returns the user's choice.
URIToBuffer (Function)
Loads in the background the content of a resource (image, text, etc.) identified by its URI in a buffer variable.
HSavePosition (Function)
Stores the current file context (current record, filter, pointers).
XMLBuildString (Function)
Retrieves and formats the content of an XML document (created by XMLDocument and modified by the XML functions).
HReadSeekLast (Function)
Sets the position on the last record whose value for a specific item is less than or equal to a sought value (exact-match search).
<Source>.SavePosition (Function)
Stores the current context of a data file: current record, filter, read pointers.
<Source>.ToWindows (Function)
Automatically initializes the controls of a window with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
HRestorePosition (Function)
Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers.
NotifPushEnable (Function)
Enables the management of push notifications in a WINDEV Mobile application (Android or iOS).
RequestRefreshUI
Requests the execution of the "Request for refreshing the display" event (and gives back control without waiting for the execution of the event).
CameraRunApp (Function)
Starts the device's native camera application to record a video or to take a photo.
<Source>.SeekLast (Function)
Sets the position on the last file record whose value for a specific item is less than or equal to a sought value.
RequestUpdateUI (Function)
Requests the execution of the "Request for refreshing the display" event (and gives back control without waiting for the execution of the event). This function is kept for backward compatibility.
HReadSeek (Function)
Sets the position on the first record whose value for a specific item is greater than or equal to a sought value (generic search).
HFirst (Function)
Sets the position on the first record of a data file according to the specified browse item.
HFilter (Function)
Defines and enables a filter on a data file, view or query.
<Source>.Filter (Function)
Defines and enables a filter on a data file, view or query.
SourceToScreen (Function)
Automatically updates the controls in a window or page with:
  • the values of the bound items in the current record (loaded in memory) of the HFSL data file described in the data model editor.
  • the values of the bound WLanguage variables.
HAdd (Function)
Adds:
  • the record found in memory into the data file (query or view).
  • the record found in a Record variable into the data file (query or view).
HReadSeekFirst (Function)
Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search).
<Source>.ReadSeekFirst (Function)
Sets the position on the first record whose value for a specific item is strictly equal to a sought value (exact-match search).
HNext (Function)
Sets the position on the next data file record according to a browse item.
<Source>.Next (Function)
Sets the position on the next data file record according to a browse item.
HBackward (Function)
Moves backward several records from the current position in the data file, according to a specified item.
HPrevious (Function)
Sets the position on the previous record of the data file according to a browse item.
<Source>.Backward (Function)
Moves backward several records from the current position in the data file, according to a specified item.
<Source>.Previous (Function)
Sets the position on the previous record of the data file according to a browse item.
HRetrieveRecord (Function)
Returns the content of the current record (in a file, a view or a query, ...).
HCross (Function)
Crosses a record in a data file.
<Source>.Cross (Function)
Crosses a record in a data file.
SQLCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
HListItem (Function)
Returns the list of items:
  • found in a data file ( a query or a view) known to the HFSQL engine. The data files defined by HDeclare, HDeclareExternal and HDescribeFile are taken into account.
  • found in a Record variable.
<Source>.Write (Function)
Writes a record into a data file without updating the indexes corresponding to all keys used in the file.
HWrite (Function)
Writes a record into a data file without updating the indexes corresponding to all keys used in the file.
OKCancelAsynchronous (Function)
Displays a message in a standard non-blocking dialog box with the answers "OK" and "Cancel" and calls a WLanguage procedure with the user's response.
SQLGetCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
HDelete (Function)
Deletes a record from a data file (query or view).
<Source>.First (Function)
Sets the position on the first record of a data file according to the specified browse item.
<Source>.Delete (Function)
Deletes a record from a data file (query or view).
HReadPrevious (Function)
Sets the position on the previous record of a file according to a browse item.
<Source>.ReadPrevious (Function)
Sets the position on the previous record of a file according to a browse item.
HReadNext (Function)
Sets the position on the next data file record according to a browse item.
HReadLast (Function)
Sets the position on the last record of a data file according to a browse item.
<Source>.ReadLast (Function)
Sets the position on the last record of a data file according to a browse item.
HViewToFile (Example)
Usage example of the HViewToFile function
HModify (Example)
Usage example of the HModify function
HWatch (Function)
Trigger monitoring of write actions (add, modify or delete) performed on a data file present on an HFSQL server. In case of modification, a specific procedure can be triggered.
External language: Pascal programming
We are going to call the elements developed in WINDEV (project, windows, ...
WLanguage procedure called by CameraRunApp
WLanguage procedure ("callback") called when taking photos or recording videos via CameraRunApp.
<Source>.Watch (Function)
Trigger monitoring of write actions (add, modify or delete) performed on a data file present on an HFSQL server. In case of modification, a specific procedure can be triggered.
MarkdownToHTML (Function)
Converts a Markwdown string to an HTML buffer (encoded in UTF-8).
HDuplicateRecord (Function)
Duplicates the record read in a data file: the record found in memory is added into the data file (query or view).
dSaveImageJPEG (Function)
Saves an image:
  • in a JPEG file.
  • in memory.
HOnError (Example)
Usage example of the HOnError function
WLanguage procedure called by CameraVideoStart
WLanguage procedure ("callback") called when the video recording is completed.
EmulateInfo (Function)
Emulates the next call to Info and automatically clicks the "OK" button.
fWrite (Example)
Usage example of the fWrite function
EmulateYesNo (Function)
Emulates the next call to YesNo and automatically clicks the button specified as parameter.
EmulateOKCancel (Function)
Emulates the next call to OKCancel and automatically clicks the button passed as parameter.
EmulateConfirm (Function)
Emulates the next call to Confirm and automatically clicks the button passed as parameter.
Defining specific character sets in HFSQL data files
When an application displays or saves data in HFSQL data files, this data is typed in the current language...
hBackupDescription (Variable type)
The hBackupDescription type is used to programmatically describe an HFSQL Client/Server backup.
1
…
7