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.
<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.
HErrorStatusModification (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.
Creating the Table pages of the WEBDEV RAD pattern
Creating the Relation windows of a WINDEV RAD pattern
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?
<Camera>.Status (Function)
Returns the status of a Camera control.
AndroidiPhone/iPad Function kept for "Version-26-compatible" Camera controls.
Creating the Relation pages of a WEBDEV RAD pattern
VideoStatus (Function)
Returns the status of a Camera control.
AndroidiPhone/iPad Function kept for "Version-26-compatible" Camera controls.
Creating the Table windows of the WINDEV RAD pattern
ThreadSuspend (Function)
Temporarily suspends the execution of the specified thread. Function not recommended.
HLockRecNum (Function)
Locks a record and restricts the access to this record for all the other applications.
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...
<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).
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).
CameraVideoStop (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.
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.
fWriteLine (Example)
Usage example of the fWriteLine function
HErrorIntegrity (Function)
Used to check whether an integrity error occurred.
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
<Source>.RestorePosition (Function)
Restores the previously saved context of a file (function HSavePosition): record in progress, filter, playback pointers.
CameraVideoStart (Function)
Starts recording a video via a Camera control in an Android or iOS application.
MemAdd (Function)
Adds an element to a memory area.
Creating the Vision windows of the WINDEV RAD pattern
<Table>.Save (Function)
Updates or adds the record bound to the current row in the Table or TreeView Table control.
HErrorLock (Function)
Used to check whether a lock error occurred.
HLast (Function)
Sets the position on the last record of a data file according to a browse item.
Report based on a programmed data source
In a report on a programmed data source, the reading of the records that will be displayed in the report requires full programming in WLanguage...
<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).
<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.
<Source>.Last (Function)
Sets the position on the last record of a data file according to a browse item.
HFound (Function)
Checks whether the current record corresponds to the current filter or search.
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).
HReadFirst (Function)
Positions on the first file record according to a browse item.
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).
<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).
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.
<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.
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.
<Page>.FromFile (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).
<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).
Report based on a memory area
A report based on a memory area is used to print the records stored in a memory area...
XMLAddChild (Function)
Adds a child tag into an XML document.
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.
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).
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.).
HSynchronizeReplica (Example)
Usage example of the HSynchronizeReplica function
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.
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).
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.
<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.
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.
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).
Creating the Vision pages of the WEBDEV RAD pattern
RequestRefreshUI
Requests the execution of the "Request for refreshing the display" event (and gives back control without waiting for the execution of the event).
<Source>.Modify (Function)
Modifies the specified record or the record found in memory in the data file (query or view).
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).
<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).
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.
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.
How do I run through a data file?
WLanguage procedure called by HWatch
WLanguage procedure called by HWatch
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.
Creating the Form windows of a WINDEV RAD pattern
<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.
Creating the Form pages of a WEBDEV RAD pattern
POUR TOUT / POUR ALL instruction (data file browsing)
Training FOR ALL instruction can be used to perform different types of runs...
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.
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.
Referring to an element in a WLanguage event / process
<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.
HModify (Example)
Usage example of the HModify function
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
HDuplicateRecord (Function)
Duplicates the record read in a data file: the record found in memory is added into the data file (query or view).
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.
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.
fWrite (Example)
Usage example of the fWrite function
dSaveImageJPEG (Function)
Saves an image:
  • in a JPEG file.
  • in memory.
HOnError (Example)
Usage example of the HOnError function
<Image>.SaveJPEG (Function)
Saves an image:
  • in a JPEG file.
  • in memory.
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.
MarkdownToHTML (Function)
Converts a Markwdown string to an HTML buffer (encoded in UTF-8).
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.
The RepeatString Looper control: Customized synchronization
How to manage the synchronization between:
  • the page displayed in the browser. This page contains a RepeatString Looper control displaying records from an HFSQL data file.
  • the corresponding page context found on the server.
Creating the menus for the pages of the WEBDEV RAD pattern
ftpConnection (Variable type)
The ftpConnection type is used to define all the advanced characteristics of an FTP connection.
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