PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WEBDEV 25 feature!
  • Overview
  • New WLanguage functions
  • Improved WLanguage functions
  • Improved WLanguage properties
  • New advanced types of WLanguage
  • Improved advanced WLanguage types
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
In version 25, new functions, new properties and new data types have been introduced and some of them have been improved.
New WLanguage functions
WEBDEV - Server codeWindows The new WLanguage functions in server code are as follows:
ChangeSourcePageDynamically changes the page displayed in an Internal Page control
CheckAllFalseReturns True if all the elements of an array are False.
CheckAllTrueReturns True if all the elements of an array are True.
CheckAnyFalseReturns True if at least one element of an array is False.
CheckAnyTrueReturns True if at least one element of an array is True.
ContinentGetReturns the Continent variable that corresponds to one of the following values:
  • a continent constant (2-character continent code),
  • a continent caption.
ContinentListReturns the list of continents.
CountryGetReturns the Country variable corresponding to an ISO code or to the country caption according to ISO 3166-1.
CountryListReturns the list of all countries or countries of a given continent according to ISO 3166-1.
DateToDayOfWeekReturns the day of the week corresponding to a given date.
dbgConnectUsed to connect a remote debugger to an application, service, Webservice, etc.
EncryptGenerateRSAKeyGenerates an RSA private/public key pair.
ExecuteRefreshUIImmediately runs the event "Request for refreshing the display" of the window, page, internal window, internal page, control template or supercontrol.
ExecuteRefreshUIParentImmediately runs the event "Request for refreshing the display" of the parent.
ExtractStringBetweenAllows you to:
  • extract a substring between two given separators from a character string.
  • browse through substrings between two given separators in a character string.
fContentTypeReturns the type of file according to the MIME standard (Multipurpose Internet Mail Extensions).
fDirRenameRenames a directory.
FTPGetFileTransfers a file from an FTP (File Transfer Protocol) server to the current computer.
gpwBiometricAuthenticationEnables biometric authentication for the connected user or retrieves the current status for the connected user.
grSunburstAddDataAdds a data to a Sunburst chart.
grSunburstGetDataRetrieves a numeric value from a Sunburst chart.
grSunburstPullOutPulls out a section (or all the sections) in a Sunburst chart.
grSunburstRootSectionChanges or specifies the path of the root in a Sunburst chart.
grSunburstSectionColorChanges the color of a section in a Sunburst chart.
grSunburstStartAngleSpecifies the start angle of the first section in a Sunburst chart.
HUpdateLinkUpdates on the server all the links of an HFSQL Client/Server data file.
iInitInternalReportInitializes the parameters of an internal report used by a report.
InDeviceOwnerModeIndicates whether the Android application is in "Device owner" mode.
InKioskModeIndicates whether the Android application is in kiosk mode.
iSetAdditionalXMPAdds XMP tags to the metadata of the generated PDF file.
JSONToStringConverts the content of a JSON variable to a JSON string.
MongoAggregationPipelineUsed to retrieve documents resulting from Map-Reduce operations in several steps.
PageChangeLayoutApplies a specific layout to a page.
PageCurrentLayoutReturns the subscript of the current layout:
  • in the current page.
  • in the specified page.
PicMergeLayerMerges the layers of a WDPic image.
PicResizeResizes a WDPic image.
PicRotationRotates a WDPic image.
PicSaveSaves the image found:
  • in an Image Editor control.
  • Versions 25 and later
    in a WDPic variable.
    New in version 25
    in a WDPic variable.
    in a WDPic variable.
RequestRefreshUIAsks to run the "Request for refreshing the display" event of the window, internal window, page, internal page, control template or supercontrol.
RequestRefreshUIParentAsks to run the "Request for refreshing the display" process of parent.
StringToJSONConverts a JSON string into a JSON variable.
TableCollapseExpandCollapses or expands an element in a Table or TreeView Table control.
XMLSignSigns an XML document.
The new WLanguage functions (prefixed syntax) in Server code are as follows:
<Array type>.AllFalseReturns True if all the elements of an array are False.
<Array type>.AllTrueReturns True if all the elements of an array are True.
<Array type>.AnyFalseReturns True if at least one element of an array is False.
<Array type>.AnyTrueReturns True if at least one element of an array is True.
<Chart>.SunburstAddDataAdds a data to a Sunburst chart.
<Chart>.SunburstGetDataRetrieves a numeric value from a Sunburst chart.
<Chart>.SunburstPullOutPulls out a section (or all the sections) in a Sunburst chart.
<Chart>.SunburstRootSectionChanges or specifies the path of the root in a Sunburst chart.
<Chart>.SunburstSectionColorChanges the color of a section in a Sunburst chart.
<Chart>.SunburstStartAngleSpecifies the start angle of the first section in a Sunburst chart.
<Connection variable>.ActivateServerTriggerRe-enables a server trigger that was disabled by HDeactivateServerTrigger.
<Connection variable>.AddGroupAdds a group of users.
<Connection variable>.AddLinkAdds an integrity rule between two files on the server.
<Connection variable>.AddScheduledBackupAdds a scheduling for full backup (with or without differential backup) on the server defined by the connection.
<Connection variable>.AddScheduledOptimizationAdds an optimization task of HFSQL Client/Server data files.
<Connection variable>.AddSchedulingCreates a scheduled task on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
<Connection variable>.AddTaskAdds a scheduled task on the server defined by the connection.
<Connection variable>.AddUserAdds a user to a database.
<Connection variable>.BackupMakes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
<Connection variable>.CancelBackupCancels a current backup.
<Connection variable>.CheckServerUpdateChecks for the latest version of the HFSQL server that can be automatically updated.
<Connection variable>.CloseConnectionCloses a connection to a database.
<Connection variable>.ConnectionQualityReturns the quality level of connection: the higher the level is, the faster the connection will be.
<Connection variable>.CopyFileCopies an HFSQL data file (.fic, .ndx and .mmo files if they exist):
  • from the HFSQL server to the server (to perform a backup for example).
  • from the HFSQL server to the client (to perform a local backup for example).
  • from the client to the HFSQL server (to update the data files for example).
  • from an HFSQL server to antoher HFSQL server.
<Connection variable>.DeactivateServerTriggerDisables a HFSQL Client/Server server trigger on a server.
<Connection variable>.DeleteBackupDeletes a backup previously performed by HBackup.
<Connection variable>.DeleteDatabaseDeletes a database located on an HFSQL server.
<Connection variable>.DeleteDirectoryDeletes a directory from an HFSQL Client/Server database.
<Connection variable>.DeleteFileDeletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if they exist) from the server.
<Connection variable>.DeleteGroupDeletes (from the server) a group of users associated with a connection.
<Connection variable>.DeleteLinkDeletes an integrity rule between two data files on the server.
<Connection variable>.DeleteParameterDeletes a parameter previously saved by HSaveParameter.
<Connection variable>.DeleteQueryDeletes a query (used by stored procedures) from an HFSQL server.
<Connection variable>.DeleteScheduledBackupDeletes a scheduled backup from an HFSQL Client/Server server.
<Connection variable>.DeleteScheduledOptimizationDeletes a scheduled optimization task from HFSQL Client/Server data files.
<Connection variable>.DeleteSchedulingDeletes a scheduled task found on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
<Connection variable>.DeleteServerTriggerDeletes a server trigger.
<Connection variable>.DeleteSetDeletes a set of stored procedures from an HFSQL server.
<Connection variable>.DeleteTaskDeletes a scheduled task from an HFSQL Client/Server server.
<Connection variable>.DeleteUserDeletes a user associated with a connection to the HFSQL server.
<Connection variable>.DescribeServerTriggerAdds or modifies a server trigger.
<Connection variable>.DisconnectClientDisplays a message on the client Computers and disconnects the application.
<Connection variable>.DuplicateDatabaseDuplicates the database associated with a connection on a HFSQL server.
<Connection variable>.EndNoDatabaseAccessRe-allows the access (which means the connection) to one or more databases accessible via a connection.
<Connection variable>.ExecuteProcedureRuns a stored procedure.
<Connection variable>.ExecuteScheduledBackupForces the execution of a scheduled backup.
<Connection variable>.ExecuteSchedulingImmediately runs a scheduled task regardless of its schedule:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
<Connection variable>.FileExistFinds out if a file exists, i.e. if it has been physically created (HCreation or HCreationIfNotFound).
<Connection variable>.InfoBackupReturns information about one or more backups performed on an HFSQL Client/Server server.
<Connection variable>.InfoDatabasePropertyUsed to find out the properties of a database on an HFSQL server.
<Connection variable>.InfoDatabaseRightsAllows you to find out the rights granted to a user or to a group on a database.
<Connection variable>.InfoFileReturns the characteristics of an HFSQL Classic or Client/Server data file.
<Connection variable>.InfoFilePropertyAllows you to find out the properties of a data file located in an HFSQL server.
<Connection variable>.InfoFileRightsAllows you to find out the rights granted to a user or to a group on a HFSQL Client/Server data file.
<Connection variable>.InfoGroupReturns information about the specified group of users.
<Connection variable>.InfoServerReturns the specified information about the server.
<Connection variable>.InfoServerPropertyAllows you to find out the properties of an HFSQL server.
<Connection variable>.InfoServerRightsAllows you to find out the rights granted to a user or group of users on a server.
<Connection variable>.InfoTaskReturns the characteristics of a scheduled task in a hScheduledTask variable].
<Connection variable>.InfoUserUpdates the variables for user management with the information regarding the specified user.
<Connection variable>.InfoViewReturns information about a materialized view.
<Connection variable>.InfoViewRightsAllows you to find out the rights granted to a user or to a group on a SQL view or on a materialized view.
<Connection variable>.ListDatabaseLists the Client/Server databases associated with a connection.
<Connection variable>.ListGroupReturns the list of groups of users defined for a connection.
<Connection variable>.ListParameterReturns the list of parameters saved from the stored procedures on the server.
<Connection variable>.ListScheduledBackupLists the full and differential backups that have been scheduled on HFSQL Client/Server.
<Connection variable>.ListScheduledOptimizationLists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
<Connection variable>.ListSchedulingLists the scheduled tasks defined on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
<Connection variable>.ListStoredElementReturns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
<Connection variable>.ListTaskLists the scheduled tasks of an HFSQL Client/Server server for a given connection.
<Connection variable>.ListUserReturns the list of users defined for a connection.
<Connection variable>.LoadParameterReads a parameter that was saved from a stored procedure by HSaveParameter.
<Connection variable>.ManageServerUpdateUsed to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates.
<Connection variable>.ManageTaskEnables or disables a scheduled task on an HFSQL Client/Server server.
<Connection variable>.ModifyDatabasePropertyModifies the properties of a database located on an HFSQL server.
<Connection variable>.ModifyDatabaseRightsModifies the rights granted to a user or to a group for a HFSQL Client/Server database.
<Connection variable>.ModifyFilePropertyModifies the properties of an HFSQL file located on a server.
<Connection variable>.ModifyFileRightsModifies the rights granted to a user or group on an HFSQL Client/Server data file.
<Connection variable>.ModifyGroupModifies the group information according to the elements found in the corresponding variables for group management.
<Connection variable>.ModifyScheduledBackupModifies a backup scheduling.
<Connection variable>.ModifyScheduledOptimizationModifies a scheduled optimization task on the HFSQL server defined by the connection.
<Connection variable>.ModifySchedulingModifies a scheduled task on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
<Connection variable>.ModifyServerPropertyModifies the properties of an HFSQL server.
<Connection variable>.ModifyServerRightsModifies the rights granted to a user or to a group on a HFSQL server.
<Connection variable>.ModifyTaskModifies a scheduled task on the HFSQL server defined by the connection.
<Connection variable>.ModifyUserModifies the information about a user according to the elements found in the corresponding variables for user management.
<Connection variable>.ModifyViewRightsModifies the rights granted to a user or to a group on a SQL view or on a materialized view.
<Connection variable>.NoDatabaseAccessDenies all new connections to a database or to all databases.
<Connection variable>.NotifAddCCRecipientAdds recipients for the notifications sent via the Control Centers (WDBal messaging tool).
<Connection variable>.NotifAddEmailRecipientAdds recipients for the notifications sent by email.
<Connection variable>.NotifConfigureSpecifies and configures the server used to send notifications by the HFSQL server.
<Connection variable>.NotifDeleteCCRecipientDeletes the recipients of a notification sent via the Control Centers (WDBal messaging tool).
<Connection variable>.NotifDeleteEmailRecipientDeletes the recipients of an email notification.
<Connection variable>.NotifListCCRecipientReturns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool).
<Connection variable>.NotifListEmailRecipientReturns the list of recipients for a notification by email.
<Connection variable>.OpenConnectionOpens a connection to a specific database.
<Connection variable>.OperationInProgressReturns the list of automatic operations in progress on an HFSQL server.
<Connection variable>.PriorityFinds out and modifies the priority of the calling application.
<Connection variable>.PriorityClientModifies the priority of a client application.
<Connection variable>.RefreshQueryCreates or refreshes a query on an HFSQL server.
<Connection variable>.RefreshSetCreates or updates a set of procedures on an HFSQL server.
<Connection variable>.RefreshViewAsks to recalculate the content of a materialized view.
<Connection variable>.RegenerateFileRegenerates a data file from its log.
<Connection variable>.RestoreBackupUsed to restore:
  • an immediate backup (performed by HBackup or via the HFSQL Control Center),
  • a scheduled backup (described by HAddScheduledBackup or via the HFSQL Control Center.
<Connection variable>.RetrieveBackupRetrieves locally the content of a compressed backup (in ZIP format) performed on a HFSQL server.
<Connection variable>.RetrieveLogCreates a text file containing the server logs between two given dates.
<Connection variable>.RSAddConfigAdds a replication between two HFSQL server onto the master server.
<Connection variable>.RSDeleteConfigDeletes a replication between two HFSQL servers.
<Connection variable>.RSExecuteImmediately runs a recurring replication between HFSQL servers: the replication is triggered before the scheduling.
<Connection variable>.RSInfoReads the replication configuration for an HFSQL server that takes part in one or more replications.
<Connection variable>.RSInitConfigures a HFSQL server in order for this server to be a master server or a subscriber server for a replication between HFSQL servers.
<Connection variable>.RSListConfigLists the replications available on a master HFSQL server.
<Connection variable>.RSModifyConfigModifies some parameters of an existing replication between two HFSQL servers.
<Connection variable>.RSWaitForDataProcessAllows you to wait for:
  • the replication data on the master server to be sent to the subscriber server.
  • the replication data received on the subscriber server to be entirely applied.
<Connection variable>.SaveParameterSaves a persistent value on the HFSQL server.
<Connection variable>.SendMessageToClientDisplays a message on the client computers.
<Connection variable>.ServerMaintenanceChecks and optimizes the system tables of a HFSQL server.
<Connection variable>.SetIntegrityEnables or disables the management of an integrity constraint on a file link.
<Connection variable>.SetServerUsed to find out and modify some settings of HFSQL Client/Server server.
<Connection variable>.SimulateNetworkSimulates the operating mode of HFSQL Client/Server on an ADSL or 3G network.
<Connection variable>.StartServerUpdateUsed to immediately start the automatic server update.
<Connection variable>.StopServerStops an HFSQL server.
<Connection variable>.TransactionStarts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
<Connection variable>.TransactionCancelIf a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction.
<Connection variable>.TransactionEndValidates the current transaction:
  • the modifications performed on the data file since the start of transaction (HTransactionStart) are validated.
  • the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
  • the records locked in read-only by the transaction are unlocked.
<Connection variable>.TransactionIsolationConfigures the isolation mode of transactions for a connection to an HFSQL server.
<Connection variable>.TransactionListReturns the list of current or interrupted transactions on the server for the specified connection.
<Connection variable>.TransactionStartStarts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
<Connection variable>.UpdateViewCreates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server.
<Connection>.InfoLockReturns information about the lock set on a data file, on one or all the records in a data file.
<Table>.CollapseExpandCollapses or expands an element in a Table or TreeView Table control.
<WDPic variable>.MergeLayerMerges the layers of a WDPic image.
<WDPic variable>.ResizeResizes a WDPic image.
<WDPic variable>.RotationRotates a WDPic image.
<WDPic variable>.SaveSaves the image contained in a WDPic variable.
WEBDEV - Server codeLinux The new WLanguage functions for WEBDEV in Linux are as follows:
ChangeSourcePageDynamically changes the page displayed in an Internal Page control
CheckAllFalseReturns True if all the elements of an array are False.
CheckAllTrueReturns True if all the elements of an array are True.
CheckAnyFalseReturns True if at least one element of an array is False.
CheckAnyTrueReturns True if at least one element of an array is True.
ContinentGetReturns the Continent variable that corresponds to one of the following values:
  • a continent constant (2-character continent code),
  • a continent caption.
ContinentListReturns the list of continents.
CountryGetReturns the Country variable corresponding to an ISO code or to the country caption according to ISO 3166-1.
CountryListReturns the list of all countries or countries of a given continent according to ISO 3166-1.
DateToDayOfWeekReturns the day of the week corresponding to a given date.
dbgConnectUsed to connect a remote debugger to an application, service, Webservice, etc.
EncryptGenerateRSAKeyGenerates an RSA private/public key pair.
ExecuteRefreshUIImmediately runs the event "Request for refreshing the display" of the window, page, internal window, internal page, control template or supercontrol.
ExecuteRefreshUIParentImmediately runs the event "Request for refreshing the display" of the parent.
ExtractStringBetweenAllows you to:
  • extract a substring between two given separators from a character string.
  • browse through substrings between two given separators in a character string.
fContentTypeReturns the type of file according to the MIME standard (Multipurpose Internet Mail Extensions).
fDirRenameRenames a directory.
FTPGetFileTransfers a file from an FTP (File Transfer Protocol) server to the current computer.
gpwBiometricAuthenticationEnables biometric authentication for the connected user or retrieves the current status for the connected user.
grSunburstAddDataAdds a data to a Sunburst chart.
grSunburstGetDataRetrieves a numeric value from a Sunburst chart.
grSunburstPullOutPulls out a section (or all the sections) in a Sunburst chart.
grSunburstRootSectionChanges or specifies the path of the root in a Sunburst chart.
grSunburstSectionColorChanges the color of a section in a Sunburst chart.
grSunburstStartAngleSpecifies the start angle of the first section in a Sunburst chart.
HUpdateLinkUpdates on the server all the links of an HFSQL Client/Server data file.
iInitInternalReportInitializes the parameters of an internal report used by a report.
InDeviceOwnerModeIndicates whether the Android application is in "Device owner" mode.
InKioskModeIndicates whether the Android application is in kiosk mode.
iSetAdditionalXMPAdds XMP tags to the metadata of the generated PDF file.
JSONToStringConverts the content of a JSON variable to a JSON string.
MongoAggregationPipelineUsed to retrieve documents resulting from Map-Reduce operations in several steps.
PageChangeLayoutApplies a specific layout to a page.
PageCurrentLayoutReturns the subscript of the current layout:
  • in the current page.
  • in the specified page.
PDFExtractPageReturns an Image type variable containing a page from a PDF file.
PDFIsProtectedChecks whether the PDF file requires a password in order to be read.
PDFMergeMerges several existing PDF files into a single PDF file. The files are merged one after another. The paths of PDF files can be found in an array.
PDFMergeWithPasswordMerges several existing and password-protected PDF files into a single PDF file.
PDFNumberOfPagesReturns the total number of pages found in a PDF file.
PDFPasswordProtects a PDF document with a password.
PDFToTextExtracts the text found in a PDF file.
RequestRefreshUIAsks to run the "Request for refreshing the display" event of the window, internal window, page, internal page, control template or supercontrol.
RequestRefreshUIParentAsks to run the "Request for refreshing the display" process of parent.
sCloseCloses the specified serial port, parallel port or infrared port.
sEscapeRuns different functions that directly affect the bits of serial port, parallel port or infrared port, independently of the communication protocol.
sInEntryQueueRetrieves the number of pending bytes in the input buffer of a specified serial port or infrared port.
SOAPAddSAMLAssertionAdds a SAML assertion to a Webservice request.
SOAPAddXMLSignatureAdds an XML signature to a Webservice request.
sOpenOpens and initializes:
  • a serial port.
  • a parallel port.
  • an infrared port.
sParameterDefines or modifies the parameters for configuring the specified serial port, parallel port or infrared port.
sReadReads a character string in the entry buffer of the specified serial port.
SSHConnectShellStarts a new SSH session of "Shell" type.
SSHDisconnectShellCloses an SSH session that was opened by SSHConnectShell.
SSHReadReads the data found on the output buffer of the SSH session.
SSHWriteWrites data into the specified SSH session.
StringToJSONConverts a JSON string into a JSON variable.
sWriteWrites a character string into the output buffer of the specified serial port, parallel port or infrared port.
TableCollapseExpandCollapses or expands an element in a Table or TreeView Table control.
XMLSignSigns an XML document.
The new WLanguage functions (prefixed syntax) for WEBDEV in Linux are as follows:
<Array type>.AllFalseReturns True if all the elements of an array are False.
<Array type>.AllTrueReturns True if all the elements of an array are True.
<Array type>.AnyFalseReturns True if at least one element of an array is False.
<Array type>.AnyTrueReturns True if at least one element of an array is True.
<Chart>.SunburstAddDataAdds a data to a Sunburst chart.
<Chart>.SunburstGetDataRetrieves a numeric value from a Sunburst chart.
<Chart>.SunburstPullOutPulls out a section (or all the sections) in a Sunburst chart.
<Chart>.SunburstRootSectionChanges or specifies the path of the root in a Sunburst chart.
<Chart>.SunburstSectionColorChanges the color of a section in a Sunburst chart.
<Chart>.SunburstStartAngleSpecifies the start angle of the first section in a Sunburst chart.
<Connection variable>.ActivateServerTriggerRe-enables a server trigger that was disabled by HDeactivateServerTrigger.
<Connection variable>.AddGroupAdds a group of users.
<Connection variable>.AddLinkAdds an integrity rule between two files on the server.
<Connection variable>.AddScheduledBackupAdds a scheduling for full backup (with or without differential backup) on the server defined by the connection.
<Connection variable>.AddScheduledOptimizationAdds an optimization task of HFSQL Client/Server data files.
<Connection variable>.AddSchedulingCreates a scheduled task on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
<Connection variable>.AddTaskAdds a scheduled task on the server defined by the connection.
<Connection variable>.AddUserAdds a user to a database.
<Connection variable>.BackupMakes a backup copy of the content of an HFSQL server: all databases on the server, one or more databases, one or more data files.
<Connection variable>.CancelBackupCancels a current backup.
<Connection variable>.CheckServerUpdateChecks for the latest version of the HFSQL server that can be automatically updated.
<Connection variable>.CloseConnectionCloses a connection to a database.
<Connection variable>.ConnectionQualityReturns the quality level of connection: the higher the level is, the faster the connection will be.
<Connection variable>.CopyFileCopies an HFSQL data file (.fic, .ndx and .mmo files if they exist):
  • from the HFSQL server to the server (to perform a backup for example).
  • from the HFSQL server to the client (to perform a local backup for example).
  • from the client to the HFSQL server (to update the data files for example).
  • from an HFSQL server to antoher HFSQL server.
<Connection variable>.DeactivateServerTriggerDisables a HFSQL Client/Server server trigger on a server.
<Connection variable>.DeleteBackupDeletes a backup previously performed by HBackup.
<Connection variable>.DeleteDatabaseDeletes a database located on an HFSQL server.
<Connection variable>.DeleteDirectoryDeletes a directory from an HFSQL Client/Server database.
<Connection variable>.DeleteFileDeletes the HFSQL data files (.fic, .ndx, .ftx and .mmo files if they exist) from the server.
<Connection variable>.DeleteGroupDeletes (from the server) a group of users associated with a connection.
<Connection variable>.DeleteLinkDeletes an integrity rule between two data files on the server.
<Connection variable>.DeleteParameterDeletes a parameter previously saved by HSaveParameter.
<Connection variable>.DeleteQueryDeletes a query (used by stored procedures) from an HFSQL server.
<Connection variable>.DeleteScheduledBackupDeletes a scheduled backup from an HFSQL Client/Server server.
<Connection variable>.DeleteScheduledOptimizationDeletes a scheduled optimization task from HFSQL Client/Server data files.
<Connection variable>.DeleteSchedulingDeletes a scheduled task found on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
<Connection variable>.DeleteServerTriggerDeletes a server trigger.
<Connection variable>.DeleteSetDeletes a set of stored procedures from an HFSQL server.
<Connection variable>.DeleteTaskDeletes a scheduled task from an HFSQL Client/Server server.
<Connection variable>.DeleteUserDeletes a user associated with a connection to the HFSQL server.
<Connection variable>.DescribeServerTriggerAdds or modifies a server trigger.
<Connection variable>.DisconnectClientDisplays a message on the client Computers and disconnects the application.
<Connection variable>.DuplicateDatabaseDuplicates the database associated with a connection on a HFSQL server.
<Connection variable>.EndNoDatabaseAccessRe-allows the access (which means the connection) to one or more databases accessible via a connection.
<Connection variable>.ExecuteProcedureRuns a stored procedure.
<Connection variable>.ExecuteScheduledBackupForces the execution of a scheduled backup.
<Connection variable>.ExecuteSchedulingImmediately runs a scheduled task regardless of its schedule:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
<Connection variable>.FileExistFinds out if a file exists, i.e. if it has been physically created (HCreation or HCreationIfNotFound).
<Connection variable>.InfoBackupReturns information about one or more backups performed on an HFSQL Client/Server server.
<Connection variable>.InfoDatabasePropertyUsed to find out the properties of a database on an HFSQL server.
<Connection variable>.InfoDatabaseRightsAllows you to find out the rights granted to a user or to a group on a database.
<Connection variable>.InfoFileReturns the characteristics of an HFSQL Classic or Client/Server data file.
<Connection variable>.InfoFilePropertyAllows you to find out the properties of a data file located in an HFSQL server.
<Connection variable>.InfoFileRightsAllows you to find out the rights granted to a user or to a group on a HFSQL Client/Server data file.
<Connection variable>.InfoGroupReturns information about the specified group of users.
<Connection variable>.InfoServerReturns the specified information about the server.
<Connection variable>.InfoServerPropertyAllows you to find out the properties of an HFSQL server.
<Connection variable>.InfoServerRightsAllows you to find out the rights granted to a user or group of users on a server.
<Connection variable>.InfoTaskReturns the characteristics of a scheduled task in a hScheduledTask variable].
<Connection variable>.InfoUserUpdates the variables for user management with the information regarding the specified user.
<Connection variable>.InfoViewReturns information about a materialized view.
<Connection variable>.InfoViewRightsAllows you to find out the rights granted to a user or to a group on a SQL view or on a materialized view.
<Connection variable>.ListDatabaseLists the Client/Server databases associated with a connection.
<Connection variable>.ListGroupReturns the list of groups of users defined for a connection.
<Connection variable>.ListParameterReturns the list of parameters saved from the stored procedures on the server.
<Connection variable>.ListScheduledBackupLists the full and differential backups that have been scheduled on HFSQL Client/Server.
<Connection variable>.ListScheduledOptimizationLists the scheduled optimization tasks of HFSQL Client/Server data files for a connection.
<Connection variable>.ListSchedulingLists the scheduled tasks defined on a HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
<Connection variable>.ListStoredElementReturns the list of elements stored on an HFSQL server (sets of procedures, stored procedures or queries).
<Connection variable>.ListTaskLists the scheduled tasks of an HFSQL Client/Server server for a given connection.
<Connection variable>.ListUserReturns the list of users defined for a connection.
<Connection variable>.LoadParameterReads a parameter that was saved from a stored procedure by HSaveParameter.
<Connection variable>.ManageServerUpdateUsed to manage the automatic update of HFSQL Client/Server servers by specifying the check frequency regarding the availability of updates.
<Connection variable>.ManageTaskEnables or disables a scheduled task on an HFSQL Client/Server server.
<Connection variable>.ModifyDatabasePropertyModifies the properties of a database located on an HFSQL server.
<Connection variable>.ModifyDatabaseRightsModifies the rights granted to a user or to a group for a HFSQL Client/Server database.
<Connection variable>.ModifyFilePropertyModifies the properties of an HFSQL file located on a server.
<Connection variable>.ModifyFileRightsModifies the rights granted to a user or group on an HFSQL Client/Server data file.
<Connection variable>.ModifyGroupModifies the group information according to the elements found in the corresponding variables for group management.
<Connection variable>.ModifyScheduledBackupModifies a backup scheduling.
<Connection variable>.ModifyScheduledOptimizationModifies a scheduled optimization task on the HFSQL server defined by the connection.
<Connection variable>.ModifySchedulingModifies a scheduled task on an HFSQL server:
  • stored procedure,
  • backup,
  • optimization,
  • refresh of materialized view.
<Connection variable>.ModifyServerPropertyModifies the properties of an HFSQL server.
<Connection variable>.ModifyServerRightsModifies the rights granted to a user or to a group on a HFSQL server.
<Connection variable>.ModifyTaskModifies a scheduled task on the HFSQL server defined by the connection.
<Connection variable>.ModifyUserModifies the information about a user according to the elements found in the corresponding variables for user management.
<Connection variable>.ModifyViewRightsModifies the rights granted to a user or to a group on a SQL view or on a materialized view.
<Connection variable>.NoDatabaseAccessDenies all new connections to a database or to all databases.
<Connection variable>.NotifAddCCRecipientAdds recipients for the notifications sent via the Control Centers (WDBal messaging tool).
<Connection variable>.NotifAddEmailRecipientAdds recipients for the notifications sent by email.
<Connection variable>.NotifConfigureSpecifies and configures the server used to send notifications by the HFSQL server.
<Connection variable>.NotifDeleteCCRecipientDeletes the recipients of a notification sent via the Control Centers (WDBal messaging tool).
<Connection variable>.NotifDeleteEmailRecipientDeletes the recipients of an email notification.
<Connection variable>.NotifListCCRecipientReturns the list of recipients of a notification sent via the Control Centers (WDBal messaging tool).
<Connection variable>.NotifListEmailRecipientReturns the list of recipients for a notification by email.
<Connection variable>.OpenConnectionOpens a connection to a specific database.
<Connection variable>.OperationInProgressReturns the list of automatic operations in progress on an HFSQL server.
<Connection variable>.PriorityFinds out and modifies the priority of the calling application.
<Connection variable>.PriorityClientModifies the priority of a client application.
<Connection variable>.RefreshQueryCreates or refreshes a query on an HFSQL server.
<Connection variable>.RefreshSetCreates or updates a set of procedures on an HFSQL server.
<Connection variable>.RefreshViewAsks to recalculate the content of a materialized view.
<Connection variable>.RegenerateFileRegenerates a data file from its log.
<Connection variable>.RestoreBackupUsed to restore:
  • an immediate backup (performed by HBackup or via the HFSQL Control Center),
  • a scheduled backup (described by HAddScheduledBackup or via the HFSQL Control Center.
<Connection variable>.RetrieveBackupRetrieves locally the content of a compressed backup (in ZIP format) performed on a HFSQL server.
<Connection variable>.RetrieveLogCreates a text file containing the server logs between two given dates.
<Connection variable>.RSAddConfigAdds a replication between two HFSQL server onto the master server.
<Connection variable>.RSDeleteConfigDeletes a replication between two HFSQL servers.
<Connection variable>.RSExecuteImmediately runs a recurring replication between HFSQL servers: the replication is triggered before the scheduling.
<Connection variable>.RSInfoReads the replication configuration for an HFSQL server that takes part in one or more replications.
<Connection variable>.RSInitConfigures a HFSQL server in order for this server to be a master server or a subscriber server for a replication between HFSQL servers.
<Connection variable>.RSListConfigLists the replications available on a master HFSQL server.
<Connection variable>.RSModifyConfigModifies some parameters of an existing replication between two HFSQL servers.
<Connection variable>.RSWaitForDataProcessAllows you to wait for:
  • the replication data on the master server to be sent to the subscriber server.
  • the replication data received on the subscriber server to be entirely applied.
<Connection variable>.SaveParameterSaves a persistent value on the HFSQL server.
<Connection variable>.SendMessageToClientDisplays a message on the client computers.
<Connection variable>.ServerMaintenanceChecks and optimizes the system tables of a HFSQL server.
<Connection variable>.SetIntegrityEnables or disables the management of an integrity constraint on a file link.
<Connection variable>.SetServerUsed to find out and modify some settings of HFSQL Client/Server server.
<Connection variable>.SimulateNetworkSimulates the operating mode of HFSQL Client/Server on an ADSL or 3G network.
<Connection variable>.StartServerUpdateUsed to immediately start the automatic server update.
<Connection variable>.StopServerStops an HFSQL server.
<Connection variable>.TransactionStarts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
<Connection variable>.TransactionCancelIf a transaction is in progress, cancels all the operations performed on the data files in transaction since the start of transaction.
<Connection variable>.TransactionEndValidates the current transaction:
  • the modifications performed on the data file since the start of transaction (HTransactionStart) are validated.
  • the transaction file is deleted (if the transaction is the last transaction in progress for a network application)
  • the records locked in read-only by the transaction are unlocked.
<Connection variable>.TransactionIsolationConfigures the isolation mode of transactions for a connection to an HFSQL server.
<Connection variable>.TransactionListReturns the list of current or interrupted transactions on the server for the specified connection.
<Connection variable>.TransactionStartStarts a transaction on the data files (HFSQL or accessed via Native Access) and creates the transaction file.
<Connection variable>.UpdateViewCreates or updates the description of an SQL view or materialized view from the analysis to an HFSQL server.
<Connection>.InfoLockReturns information about the lock set on a data file, on one or all the records in a data file.
<sshSession variable>.ConnectShellStarts a new SSH session of "Shell" type.
<sshSession variable>.DisconnectShellCloses an SSH session that was opened by SSHConnectShell.
<sshSession variable>.ReadReads the data found on the output buffer of the SSH session.
<sshSession variable>.WriteWrites data into the specified SSH session.
<Table>.CollapseExpandCollapses or expands an element in a Table or TreeView Table control.
<wsRequest variable>.AddSAMLAssertionAdds a SAML assertion to a Webservice request.
<wsRequest variable>.addXMLSignatureAdds an XML signature to a Webservice request.
PHP The new WLanguage functions for PHP are as follows:
DateToDayOfWeekReturns the day of the week corresponding to a given date.
fDirRenameRenames a directory.
grSunburstAddDataAdds a data to a Sunburst chart.
grSunburstGetDataRetrieves a numeric value from a Sunburst chart.
grSunburstPullOutPulls out a section (or all the sections) in a Sunburst chart.
grSunburstRootSectionChanges or specifies the path of the root in a Sunburst chart.
grSunburstSectionColorChanges the color of a section in a Sunburst chart.
grSunburstStartAngleSpecifies the start angle of the first section in a Sunburst chart.
InBackgroundModeIndicates whether the code is run when the application is in background.
InDeviceOwnerModeIndicates whether the Android application is in "Device owner" mode.
InKioskModeIndicates whether the Android application is in kiosk mode.
The new WLanguage functions (prefixed syntax) for PHP are as follows:
<Chart>.SunburstAddDataAdds a data to a Sunburst chart.
<Chart>.SunburstGetDataRetrieves a numeric value from a Sunburst chart.
<Chart>.SunburstPullOutPulls out a section (or all the sections) in a Sunburst chart.
<Chart>.SunburstRootSectionChanges or specifies the path of the root in a Sunburst chart.
<Chart>.SunburstSectionColorChanges the color of a section in a Sunburst chart.
<Chart>.SunburstStartAngleSpecifies the start angle of the first section in a Sunburst chart.
WEBDEV - Browser code The new WLanguage functions for WEBDEV in browser code are as follows:
AgeReturns the age according to the date of birth.
ArcTan2Returns the arc tangent 2 of the values passed in parameter.
BrowserPrintPrints the page currently displayed in the browser.
BufferToHexaConverts a buffer into a displayable hexadecimal string (for example: "4A 5B 00").
CalendarSelectReturns the date selected in a Calendar control.
CalendarSelectCountReturns the number of days selected in a Calendar control.
CharactTypeReturns information about the type of character.
CharactTypeCountReturns the number of characters matching the information of a given type.
CharactUnicodeReturns the character corresponding to the specified Unicode code.
ChronoEndStops a stopwatch and returns the time passed (in milliseconds) since the start of timing (call to ChronoStart).
ChronoPausePauses a stopwatch in order to measure the time spent on a process.
ChronoResetStops and resets an existing stopwatch to zero.
ChronoResumeRestarts a stopwatch that was stopped by ChronoEnd or ChronoPause.
ChronoStartStarts a stopwatch to find out the duration of a process (in milliseconds) and resets an existing stopwatch.
ChronoValueIndicates the time passed (in milliseconds) since the call to ChronoStart.
CommonLengthReturns the number of characters common to two characters strings (from the beginning or from the end).
ContinentGetReturns the Continent variable that corresponds to one of the following values:
  • a continent constant (2-character continent code),
  • a continent caption.
ContinentListReturns the list of continents.
ConversionConverts a value from a unit to another one.
CountryGetReturns the Country variable corresponding to an ISO code or to the country caption according to ISO 3166-1.
CountryListReturns the list of all countries or countries of a given continent according to ISO 3166-1.
CSVToArrayFills a one- or two-dimensional array of the specified type with the character string in CSV format passed in parameter.
CurrentMonthReturns the current month.
CurrentYearReturns the current year in integer format.
DateTimeLocalToTimeZoneConverts a local date and time into the date and time of a time zone.
DateTimeLocalToUTCConverts a date and a time expressed in local time (time zone, summer time, winter time) into a date and time expressed in universal time (UTC).
DateTimeTimeZoneToLocalConverts a date and a time expressed in a time zone into local date and time.
DateTimeToEpochConverts a local date-time to the Epoch format (number of time units from 01/01/1970 at 00h00 UTC).
DateTimeToRealConverts a date and time into an 8-byte real.
DateTimeUTCToLocalConverts a date and a time expressed in universal time (UTC) into a date and time expressed in local time (time zone, summer time, winter time).
DateTimeValidChecks the validity of a date/time included between January 01 0001 at 0 hour 0 minute 0 second 0 hundredth of a second and December 31 9999 at 23 hours 59 minutes 59 seconds 99 hundredths of a second.
DateToDayReturns the day corresponding to a given date.
DateToDayInAlphaReturns the spelled-out day of the week corresponding to the specified date.
DateToDayOfWeekReturns the day of the week corresponding to a given date.
DateToMonthInAlphaSpells out the month corresponding to the specified date.
DateToWeekNumberReturns the number of the week corresponding to the specified date.
DayNumberInAlphaReturns the name of the day of the week according to its number.
dBorderDraws a border.
DecimalToSexagesimalReturns the sexagesimal angle (in base 60) corresponding to a decimal angle.
dPolylineDraws a line composed of several segments.
dRoundedRectangleDraws a rounded rectangle:
  • in an Image control,
  • in an Image variable,
  • in a WDPic variable (on the background layer),
  • in a picLayer variable.
EasterReturns the date of Easter for the specified year according to the western Christian calendar.
EpochToDateTimeConverts a date and a time in Epoch format (number of time units since 01/01/1970 at 00h00 UTC) into a local date-time.
ExtractLineExtracts a specific line from a character string.
FactorialReturns the factorial of an integer number.
FirstDayOfMonthReturns the first day of the month.
FirstDayOfWeekReturns the date of first day of the week (which means Monday).
FirstDayOfYearReturns the date of the first day of the year.
geoAzimuthReturns the direction represented by a position in relation to another one.
geoDistanceReturns the distance between the two positions. This distance is expressed in meters by default.
GetColorAllows you to get a set of harmonious colors without having to use a table of colors.
GetGUIDCalculates a globally unique identifier (named "GUID"), whose size is:
  • equal to 16 bytes, which means 32 hexadecimal characters.
  • equal to 32 bytes, which means 64 hexadecimal characters.
GetIdentifierCalculates a unique identifier (integer) for an executable or for a session.
GetUUIDCalculates a 128-bit Universal Unique Identifier ("UUID").
GetUUID256Calculates a 256-bit Universal unique identifier ("UUID").
grBarColorInitializes the color of a specific bar in a Column or Stacked Column chart.
grCategoryColorInitializes the category color for a chart whose type is:
  • Pie,
  • Column,
  • Bubble chart,
  • Waterfall.
grCategoryLabelInitializes the label of data category (or section) in a chart.
grPieStartAngleIndicates the start angle of first section in a Pie chart, Semi-circular chart or Donut chart.
grPointColorInitializes the color of a specific point in one of the following chart types:
  • Line,
  • Scatter,
  • Bubble chart.
grSeriesColorInitializes the color of a series or the color of a section.
grSunburstRootSectionChanges or specifies the path of the root in a Sunburst chart.
grTooltipDisplays and formats:
  • the tooltip associated with each section of a chart (section of a pie chart, column of a column chart, etc.). Also allows you to find out the characteristics of the tooltip associated with each chart section.
  • a custom tooltip, associated with a point.
HashCheckStringChecks the Hash of a character string for a specific type of algorithm.
HashStringCalculates the Hash of a character string according to a specific algorithm.
HexaToBufferConverts a string representing bytes in hexadecimal into a binary buffer.
HiWordReturns the two high bytes of an integer.
InAutomaticTestModeUsed to find out whether an automatic test is currently run or not.
InDeviceOwnerModeIndicates whether the Android application is in "Device owner" mode.
InKioskModeIndicates whether the Android application is in kiosk mode.
InLinuxModeIndicates whether the code is run in Linux mode or not.
InMacCatalystModeIndicates whether the application is running in Mac Catalyst mode (running an iPad application on a Mac).
InVGAModeIndicates whether the application is run in VGA mode on a mobile device.
InWebModeIndicates whether the current process is run:
  • from a WINDEV executable.
  • from the WEBDEV runtime engine (AWP).
JSONToStringConverts the content of a JSON variable to a JSON string.
LastDayOfMonthReturns the date of the last day for the specified month.
LastDayOfWeekReturns the date of the last day of the week corresponding to a given date.
LeapYearIndicates whether the specified year is a leap year or not.
LooperAddInProgressModifies or returns the visibility status of internal wait window when adding additional elements into an infinite Looper control.
LoWordReturns the two low bytes of an integer.
MakeIntegerBuilds a 4-byte integer from two 2-byte integers.
MatAddAdds two matrices of same dimensions (same number of rows and same number of columns).
MatCopyCreates the copy of a matrix.
MatCreateCreates a matrix containing 0 row and 0 column.
MatDeleteDeletes an existing matrix.
MatDeterminantCalculates the determinant of a square matrix (the number of rows is equal to the number of columns).
MatErrorIdentifies the type of the last error caused by a Matxxx function (functions for matrix management).
MatExistChecks the existence of a matrix in memory.
MatFillInitializes all the elements found in a matrix of a given size.
MatFloatAddAdds a value to each matrix element.
MatFloatMultiplyMultiplies each matrix element by a value.
MatInvertInverts a square matrix.
MatMultiplyMultiplies two matrices.
MatNbColumnReturns the number of columns found in a matrix.
MatNbLineReturns the number of rows found in a matrix.
MatReadReads the value of a matrix element.
MatReadColumnReads the value of all the elements found in a matrix column.
MatReadLineReads the value of all elements found in a matrix row.
MatStackCompresses the memory footprint occupied by a matrix.
MatTransposeCalculates the transposed matrix.
MatWriteWrites an element into a matrix.
MeanCalculates the mean of several elements:
  • elements found in an array,
  • numeric values, ...
MonthNumberInAlphaReturns the name of the month according to its number.
NoCharacterReturns a character string without the specified characters found on the left and on the right.
NoLeftCharacterReturns a character string without the specified characters found on the left of the initial string.
NoRightCharacterReturns a character string without the specified characters found on the right of the initial string.
NumberInWordsTransforms a number into a character string corresponding to the number "written in words".
RealToDateTimeCoverts a 8-byte real into a date and time.
RGBToHTMLReturns the HTML color corresponding to the RGB color.
RoundDownReturns the value of a numeric value rounded to the nearest lower integer.
RoundUpReturns the value of a numeric value rounded to the nearest greater integer.
sComputeCrc16Checks a character string before and after transmission between WINDEV applications and WEBDEVsites.
sComputeCrc32Calculates the Cyclical Redundancy Check (CRC) of buffer.
SexagesimalToDecimalReturns the decimal angle corresponding to a sexagesimal angle.
StatAverageCalculates the arithmetic, geometric or harmonic mean for a series of values.
StatAverageDeviationCalculates the average deviation of values in relation to their arithmetic mean.
StatCorrelationCalculates the coefficient of correlation between two series of values.
StatCovarianceCalculates the covariance between two series of values.
StatErrorReturns the error number for the last error caused by a Statxxx function (statistical functions).
StatMaxCalculates the maximum value for a series of values.
StatMinCalculates the minimum value for a series of values.
StatStandardDeviationCalculates the standard deviation for a series of values.
StatStandardDeviationPCalculates the standard deviation for a full series of values.
StatSumCalculates the sum for a series of values.
StatVarianceCalculates the variance for a series of values.
StatVariancePCalculates the variance for a full series of values.
StringDeleteDeletes:
  • all the occurrences of a sub-string inside a string.
  • a section of string inside a string. The part of string to remove is identified by its position and length.
StringEndsWithChecks whether a character string ends:
  • with a specific character string.
  • with one of the character strings found in a list.
StringIncrementIncrements a number found at the beginning or at the end of a character string.
StringInsertInserts a string into another character string at a given position.
StringReverseReverses the characters of a string.
StringSplitExtracts all the sub-strings from a character string according to a one or more string separators.
StringStartsWithChecks whether a character string starts:
  • with a specific character string.
  • with one of the character strings found in a list.
StringToArrayFills a one- or two-dimensional array of the specified type with the character string passed in parameter.
StringToJSONConverts a JSON string into a JSON variable.
SumCalculates the sum of the array elements.
SysDateTimeReturns or modifies the system date (date and time of the day defined for the current computer).
TableAddInProgressModifies or returns the visibility status of internal wait window when adding additional elements into an infinite Table control.
TableCollapseExpandCollapses or expands an element in a Table or TreeView Table control.
TextToHTMLConverts a text string into an HTML string (the CR characters are replaced by <BR>, the accented characters are replaced by their equivalent in HTML, ...).
ToClipboardWrites text or image information into the system clipboard.
TruncateTruncates the right part of a string or buffer.
URLExtractPathReturns the different elements of a URL: protocol, user, password, domain, port, resource path, resource name, resource extension, request and fragment.
WordCountReturns the number of words in a string.
WordToArrayFills an array with the words of a string.
XMLChildExistSpecifies whether the current tag has children corresponding to the sought type (tag, attribute, ...).
XMLDeleteDeletes the current element (as well as the entire branch) from an XML document.
XMLExecuteXPathRuns an XPATH query:
  • in an XML document.
  • in an xmlDocument variable.
XMLExtractDocumentCreates a new XML document from an existing XML document.
XMLExtractStringExtracts the content of a tag found in an XML document.
XMLInsertDocumentInserts the current XML tag found in an XML document into another XML document.
XMLInsertElementInserts an XML element (tag or attribute) into an XML document.
XMLModifyModifies the content of the current element found in the XML document.
XMLNamespaceReturns the prefix of the namespace associated with the current tag in an XML document.
XMLNamespaceURIReturns the URI of the namespace associated with the current tag in an XML document.
XMLPathReturns the current position in the document in XPATH format.
XMLReadReturns the value of an XML element or the value of the attribute for an XML element.
XMLRenameRenames the current element (tag or attribute) in an XML document.
XMLRestorePositionRestores the previously saved context of an XML document.
XMLResultReturns the result of a calculation XPath query.
XMLSavePositionStores the current position in the XML document.
XMLToTextConverts a character string in XML format into a standard character string.
XMLWriteCreates or modifies the value of an XML element or the value of the attribute for an XML element.
The new WLanguage functions (prefixed syntax) for WEBDEV in browser code are as follows:
<Chart>.BarColorInitializes the color of a specific bar in a Column or Stacked Column chart.
<Chart>.CategoryColorInitializes the category color for a chart whose type is:
  • Pie,
  • Column,
  • Bubble chart,
  • Waterfall.
<Chart>.PieStartAngleIndicates the start angle of first section in a Pie chart, Semi-circular chart or Donut chart.
<Chart>.PointColorInitializes the color of a specific point in one of the following chart types:
  • Line,
  • Scatter,
  • Bubble chart.
<Chart>.SeriesColorInitializes the color of a series or the color of a section.
<Chart>.TooltipDisplays and formats:
  • the tooltip associated with each section of a chart (section of a Pie chart, column of a Column chart, etc.). Also allows you to find out the characteristics of the tooltip associated with each chart section.
  • a custom tooltip, associated with a point.
<Date type>.ToDayReturns the day corresponding to a given date.
<Date type>.ToDayInAlphaReturns the spelled-out day of the week corresponding to the specified date.
<Date type>.ToMonthInAlphaSpells out the month corresponding to the specified date.
<Date type>.ToWeekNumberReturns the number of the week corresponding to the specified date.
<DateTime type>.ToEpochConverts a local date-time to the Epoch format (number of time units from 01/01/1970 at 00h00 UTC).
<DateTime type>.ToRealConverts a date and time into an 8-byte real.
<Table>.CollapseExpandCollapses or expands an element in a Table or TreeView Table control.
Improved WLanguage functions
WEBDEV - Server codeWindowsLinux The following functions have been modified in this version:
OrganizerSelectMinusNew syntax used to manage appointments via an Appointment variable.
OrganizerSelectPlusNew syntax used to manage appointments via an Appointment variable.
OrganizerDeleteAppointmentNew syntax used to manage appointments via an Appointment variable.
StringToDateNew constants to manage new masks.
CompileAbility to declare and use internal procedures.
CookieWriteNew constant to create "SameSite" cookies.
DateToStringNew constants to manage new masks.
DecodeNew constant to perform 64 encoding/decoding without CR (Carriage Return).
EncodeNew constant to perform 64 encoding/decoding without CR (Carriage Return).
ExecuteCodeAbility to declare and use internal procedures.
fCreateNew constant to automatically delete a file when it is closed.
gImageNew syntax to use an Image variable.
grAxisVisibleModification of the parameter used to manage the visibility of the axis.
grCreateManagement of Sunburst chart.
grCategoryLabelNew syntax to know the label of a data category in a chart.
grParameterManagement of Sunburst chart.
grTypeManagement of Sunburst chart.
HashStringNew constants to take into account new types of hash algorithms.
HashFileNew constants to take into account new types of hash algorithms.
HashCheckStringNew constants to take into account new types of hash algorithms.
HashCheckFileNew constants to take into account new types of hash algorithms.
iSequencingAddPDFNew constant to configure the print size.
iPrintDoc
  • New syntax to print a document from a binary memo.
  • New constant to configure the print size.
iPrintPDFNew constant to configure the print size.
iPrintSignatureNew constant to take into account the format of the signature.
iParameterNew constant to modify the PDF report generation mode.
PDFSignNew parameter to take into account the format of the signature.
NetworkConnectNew parameter to manage connection persistence.
WEBDEV - Browser code The following functions have been modified in this version:
CookieWriteNew constant to create "SameSite" cookies.
dArcThe <Line width> parameter is now available.
EncodeNew constant to perform 64 encoding/decoding without CR (Carriage Return).
DecodeNew constant to perform 64 encoding/decoding without CR (Carriage Return).
grAxisVisibleModification of the parameter used to manage the visibility of the axis.
grCategoryLabelNew syntax to know the label of a data category in a chart.
PHP The following functions have been modified in this version:
CookieWriteNew constant to create "SameSite" cookies.
EncryptStandardThe cryptAES256 constant is now available.
DecryptStandardThe cryptAES256 constant is now available.
grCreateManagement of Sunburst chart.
grParameterManagement of Sunburst chart.
grTypeManagement of Sunburst chart.
HashStringNew constants to take into account new types of hash algorithms.
HashFileNew constants to take into account new types of hash algorithms.
HashCheckStringNew constants to take into account new types of hash algorithms.
HashCheckFileNew constants to take into account new types of hash algorithms.
Improved WLanguage properties
WEBDEV - Server codeWindowsLinux The following properties have been modified in this version:
AnimationDurationIt is now possible to assign a Duration variable or a duration written in clear text (for example '1s' ou '10 s') to this property.
New advanced types of WLanguage
WEBDEV - Server codeWindows Here are the new WLanguage types for WEBDEV applications:
ContinentThe Continent type is used to find out the characteristics of a continent.
CountryThe Country type is used to find out the characteristics of a country.
picLayerThe picLayer type allows you to define all the advanced characteristics of a layer of an image loaded in a WDPic variable.
picTextThe picText type allows you to define all the advanced characteristics of a Text layer.
saasVisitThe saasVisit is used to find out all the characteristics of a SaaS user's visit.
WEBDEV - Server codeLinux Here are the new WLanguage types for WEBDEV applications in Linux:
ContinentThe Continent type is used to find out the characteristics of a continent.
CountryThe Country type is used to find out the characteristics of a country.
saasVisitThe saasVisit is used to find out all the characteristics of a SaaS user's visit.
sshSessionThe sshSession type is used to define the characteristics of a connection to an SSH server.
xmlSignatureThe xmlSignature type is used to define the advanced characteristics of an XML signature.
xmlSignatureInformationKeyX509The xmlSignatureInformationKeyX509 type is used to define the information that must be included in the KeyInfo section of the XML signature.
xmlSignatureReferenceThe xmlSignatureReference type is used to add a reference section into the XML signature.
Improved advanced WLanguage types
WEBDEV - Server codeWindowsLinux The following advanced types have been improved for WEBDEV applications:
hBackupDescription..WebhookAfter, new property to trigger a REST service after a backup.
hRSConfigNew ..Spare property used to define a Spare server.
httpRequestNew properties to manage the maximum data upload and download speeds.
WDPicNew properties to manage image layers and size.
Minimum version required
  • Version 25
Comments
Click [Add] to post a comment