PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
New WINDEV, WINDEV Mobile 25 feature!
  • Overview
  • New WLanguage functions
  • Improved WLanguage functions
  • New WLanguage properties
  • 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
Windows Mobile The new WLanguage functions for Windows Mobile are as follows:
AAFEnableRe-enables an Automatic Application Feature (AAF) previously disabled by AAFDisable.
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.
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.
InDeviceOwnerModeIndicates whether the Android application is in "Device owner" mode.
InKioskModeIndicates whether the Android application is in kiosk mode.
JSONToStringConverts the content of a JSON variable to a JSON string.
StringToJSONConverts a JSON string into a JSON variable.
TableCollapseExpandCollapses or expands an element in a Table or TreeView Table control.
The new WLanguage functions (prefixed syntax) for Windows Mobile are as follows:
<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.
Android The new WLanguage functions for Android are as follows:
AAFEnableRe-enables an Automatic Application Feature (AAF) previously disabled by AAFDisable.
ChangeThemeIs used to change, by programming, the theme (dark or light) used by the mobile application.
ConfirmAsynchronousDisplays a non-blocking message in a standard dialog box with the answers "Yes", "No", "Cancel" and calls a WLanguage procedure with the user's response.
DateToDayOfWeekReturns the day of the week corresponding to a given date.
DecryptAsymmetricDecrypts a buffer with a private/public key algorithm with RSA encryption.
DecryptAsymmetricEnveloppedPerforms the asymmetric encryption of an envelope that has been encrypted with EncrypteAsymmetricEnvelopped.
DialogAsynchronousDisplays a non-blocking message box and calls a WLanguage procedure with the value of the button clicked by the user.
EncryptAsymmetricEncrypts a buffer using an asymmetric encryption algorithm (RSA) that requires a public key and a private key.
EncryptAsymmetricEnveloppedPerforms an asymmetric encryption of an envelope.
ErrorAsynchronousDisplays a custom error message in a non-blocking system error window.
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.
fDirRenameRenames a directory.
GetThemeIs used to find out the current theme of a mobile application.
gpwAddUserAdds a user into the database of user groupware.
gpwAddUserToGroupAdds a user to a group of the user groupware database.
gpwAuthLoginAllows you to connect to the User Groupware using authentication with an account such as Facebook, Google, Microsoft, etc.
gpwBiometricAuthenticationEnables biometric authentication for the connected user or retrieves the current status for the connected user.
gpwDisconnectUserDisconnects the current user from the user groupware
gpwGetUserInfoRetrieves information about the current user (application that is using the user groupware).
gpwListOAuthParametersRetrieves the list of OAuth parameters defined for the user groupware, i.e. the list of providers (Google, Facebook, etc.) to which it is possible to connect via the user groupware. These parameters are defined via the user groupware administration site.
gpwOpenOpens the login window or page of user groupware.
gpwRemoteConnectAllows connecting to the application via the user groupware Webservice.
gpwResetPasswordResets the password of a registered user.
grSaveImageSaves the image of a chart in an Image variable.
iAddAttachmentAdds an attachment in a PDF file generated by a PDF print export.
iAddBookmarkAdds a bookmark in the report viewer or when exporting to PDF.
iChangeSubReportSourceModifies by programming the report associated with a sub-report in a composite report.
iCloseReportStops printing the current report immediately.
iColumnEndForces a column break in a multi-column report.
iColumnNumReturns the number of the current column in a multi-column report.
iCurrentFileReturns the name of the file currently generated.
iEndReportForces the report print to stop.
iForceComplementForces the printing of a Body Complement block.
iInitInternalReportInitializes the parameters of an internal report used by a report.
iInitReportQueryInitializes the query linked to the report (for a query with parameters).
iInitReportQueryConnectionInitializes the query linked to the report.
iListNestedReportsReturns:
  • the list of nested reports currently printed (reports run by iPrintReport in one of the processes of the report currently printed).
  • the list of sequenced reports currently printed (iSequenceAdd).
InDeviceOwnerModeIndicates whether the Android application is in "Device owner" mode.
iNestedHeaderFooterPrints (or not) the page headers and footers of nested report.
InfoAsynchronousDisplays a non-blocking custom message in a system information window.
InKioskModeIndicates whether the Android application is in kiosk mode.
iPageEndForces the move to the next page during the report print.
iPrintBlockForces a report block to print.
iPrintBodyComplementForces a body complement block to print while specifying the height of complement block.
iPrintReportPrints a report created with the report editor.
iReportPrintingStatusReturns the status of the current print.
iResetNbPagesReinitializes the current number of pages, used in the preset controls such as "Number of pages" and "Page number and number of pages".
iSequencingAddAdds a report into a sequence of report prints.
iSequencingPrintPrints a sequence of reports.
KioskDisableDisables kiosk mode for the current application.
KioskEnableSwitches the current Android application to kiosk mode.
OKCancelAsynchronousDisplays 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.
PDFCloseCloses the PDF file loaded in memory in a pdfDocument variable.
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.
PDFOpenOpens a PDF document and loads it in a pdfDocument variable.
PDFReaderCloseCloses and frees the PDF file displayed in a PDF Reader control.
PDFReaderHighlightFinds a text in the document displayed by a PDF Reader control and highlights the occurrences of this text in the control.
PDFReaderOpenOpens a PDF file displayed in a PDF Reader control.
PDFReaderRotatePageRotates a page displayed in the PDF Reader control.
PDFReaderSeekFirstInitializes the search for a text in a PDF file displayed by the PDF Reader control and positions on the first occurrence found (from the current page).
PDFReaderSeekNextSets the position on the next result of a search in the content of a PDF Reader control.
PDFReaderSeekPreviousPositions on the previous result of a search initiated by PDFReaderSeekFirst in the content of a PDF Reader control.
PDFSaveSaves the content of a pdfDocument variable in a ".PDF" file.
PDFToTextExtracts the text found in a PDF file.
RandomCryptoBufferReturns a buffer to the specified size filled with random data, that can be used with the cryptographic technologies.
RandomCryptoIntegerReturns a random number that can be used with the cryptographic technologies.
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.
SOAPAddAttributeAdds an attribute to an automatic variable generated by the import of a Webservice.
SOAPAddHeaderAdds a header to the next SOAP function of a Webservice to run.
SOAPAddSAMLAssertionAdds a SAML assertion to a Webservice request.
SOAPGetHeaderRetrieves a header in the SOAP message received further to a call to a Webservice.
SOAPPrepareBuilds the SOAP request for calling a Webservice function.
SOAPToHTTPBuilds the HTTP request to call a function of a Webservice. This request can be modified to adapt it to the expectations of the Webservice, if necessary. It can then be sent using HTTPSend.
SSHCommandSends a command to an SSH server. The session is automatically started and closed as soon as the command is sent.
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.
SysThemeReturns the current theme used on the mobile device.
TableCollapseExpandCollapses or expands an element in a Table or TreeView Table control.
WarningAsynchronousDisplays a custom message in a non-blocking system warning window.
YesNoAsynchronousDisplays a message in a standard non-blocking dialog box with the answers "Yes" and "No" and calls a WLanguage procedure with the user's response.
The new WLanguage functions (prefixed syntax) for Android are as follows:
<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.
<Image variable>.BackgroundDeclares the default background color for the rectangles, circles, ... used in an Image variable.
<Image variable>.ChangeModeChanges the drawing mode used by the drawing functions (dLine, dRectangle, ....).
<Image variable>.DrawArcDraws a circle arc on an ellipse arc in an Image variable.
<Image variable>.DrawChordDraws the chord of a circle (intersection between an ellipse and a straight line) in an Image variable.
<Image variable>.DrawCircleDraws a circle or an ellipse in an Image variable.
<Image variable>.DrawLineDraws a line in an Image variable.
<Image variable>.DrawPointDraws a point in an Image variable.
<Image variable>.DrawPolygonDraws a polygon in an Image variable.
<Image variable>.DrawPolylineDraws a line composed of several segments in an Image variable.
<Image variable>.DrawRectangleDraws a rectangle in an Image variable.
<Image variable>.DrawRectangleGradientDraws a rectangle in an Image variable.
<Image variable>.DrawSliceDraws a section of a circle or an ellipse in an Image variable.
<Image variable>.DrawTextDraws a text in an Image variable.
<Image variable>.FontDeclares the font that will be used by dText in an Image variable.
<Image variable>.PenDeclares the default color and style for the lines, rectangles, circles, ... found in an Image variable.
<Image variable>.PixelColorIdentifies the color of a pixel contained in an Image variable.
<Image variable>.PixelOpacityIdentifies the opacity of a pixel in an image (in an Image variable) with an Alpha layer.
<Image>.BackgroundDeclares the default background color for the rectangles, circles, ... used in an Image control.
<Image>.ChangeModeChanges the drawing mode used by the drawing functions (dLine, dRectangle, ....).
<Image>.DrawArcDraws a circle arc or an ellipse arc in an Image control.
<Image>.DrawChordDraws the chord of a circle (intersection between an ellipse and a straight line) in an Image control.
<Image>.DrawCircleDraws a circle or an ellipse in an Image control.
<Image>.DrawLineDraws a line in an Image control.
<Image>.DrawPointDraws a point in an Image control.
<Image>.DrawPolygonDraws a polygon in an Image control,
<Image>.DrawPolylineDraws a line composed of several segments in an Image control.
<Image>.DrawRectangleDraws a rectangle in an Image control.
<Image>.DrawRectangleGradientDraws a rectangle in an Image control.
<Image>.DrawSliceDraws a circle or an ellipse section in an Image control.
<Image>.DrawTextDraws a text in an Image control.
<Image>.FontDeclares the font that will be used by dTexte in an Image control.
<Image>.PenDeclares the default color and style for the lines, rectangles, circles, ... found in an Image control.
<Image>.PixelColorIdentifies the color of a pixel in an Image control.
<Image>.PixelOpacityIdentifies the opacity of a pixel in an image (in an Image control) that manages the Alpha layer.
<PDF Reader>.CloseCloses and frees the PDF file displayed in a PDF Reader control.
<PDF Reader>.HighlightFinds a text in the document displayed by a PDF Reader control and highlights the occurrences of this text in the control.
<PDF Reader>.OpenOpens a PDF file displayed in a PDF Reader control.
<PDF Reader>.RotatePageRotates a page displayed in the PDF Reader control.
<PDF Reader>.SeekFirstInitializes the search for a text in a PDF file displayed by the PDF Reader control and positions on the first occurrence found (from the current page).
<PDF Reader>.SeekNextSets the position on the next result of a search in the content of a PDF Reader control.
<PDF Reader>.SeekPreviousPositions on the previous result of a search initiated by PDFReaderSeekFirst in the content of a PDF Reader control.
<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.
Android Widget The new WLanguage functions for developing in Android Widget mode are as follows:
DateToDayOfWeekReturns the day of the week corresponding to a given date.
DecryptAsymmetricDecrypts a buffer with a private/public key algorithm with RSA encryption.
DecryptAsymmetricEnveloppedPerforms the asymmetric encryption of an envelope that has been encrypted with EncrypteAsymmetricEnvelopped.
EncryptAsymmetricEncrypts a buffer using an asymmetric encryption algorithm (RSA) that requires a public key and a private key.
EncryptAsymmetricEnveloppedPerforms an asymmetric encryption of an envelope.
fDirRenameRenames a directory.
gpwBiometricAuthenticationEnables biometric authentication for the connected user or retrieves the current status for the connected user.
iInitReportQueryInitializes the query linked to the report (for a query with parameters).
iInitReportQueryConnectionInitializes the query linked to the report.
InDeviceOwnerModeIndicates whether the Android application is in "Device owner" mode.
InKioskModeIndicates whether the Android application is in kiosk mode.
iPrintReportPrints a report created with the report editor.
PDFCloseCloses the PDF file loaded in memory in a pdfDocument variable.
PDFOpenOpens a PDF document and loads it in a pdfDocument variable.
PDFSaveSaves the content of a pdfDocument variable in a ".PDF" file.
RandomCryptoBufferReturns a buffer to the specified size filled with random data, that can be used with the cryptographic technologies.
RandomCryptoIntegerReturns a random number that can be used with the cryptographic technologies.
SSHCommandSends a command to an SSH server. The session is automatically started and closed as soon as the command is sent.
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.
The new WLanguage functions (prefixed syntax) for the Android Widget mode are as follows:
<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.
iPhone/iPad The new WLanguage functions for iPhone/iPad are as follows:
AAFEnableRe-enables an Automatic Application Feature (AAF) previously disabled by AAFDisable.
AppleSignInCette fonction permet d’effectuer une authentification par " Connexion avec Apple" sur le matériel iOS 13 et plus. Une fenetre externe permet à l’utilisateur de s’authentifier avec ses identifiant AppleID.
ChangeThemeIs used to change, by programming, the theme (dark or light) used by the mobile application.
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.
ConfirmAsynchronousDisplays a non-blocking message in a standard dialog box with the answers "Yes", "No", "Cancel" and calls a WLanguage procedure with the user's response.
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.
DialogAsynchronousDisplays a non-blocking message box and calls a WLanguage procedure with the value of the button clicked by the user.
EncryptGenerateRSAKeyGenerates an RSA private/public key pair.
ErrorAsynchronousDisplays a custom error message in a non-blocking system error window.
ErrorWithTimeoutAsynchronousDisplays a custom error message in a non-blocking system error window for a given amount of time.
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.
ExeGetPIDReturns information about the current process.
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.
GalleryClosePopupCloses the automatic zoom popup for the image gallery.
GalleryDisplayPopupDisplays the automatic zoom popup for the Image Gallery control.
GetThemeIs used to find out the current theme of a mobile application.
gpwAddUserAdds a user into the database of user groupware.
gpwAddUserToGroupAdds a user to a group of the user groupware database.
gpwAuthLoginAllows you to connect to the User Groupware using authentication with an account such as Facebook, Google, Microsoft, etc.
gpwBiometricAuthenticationEnables biometric authentication for the connected user or retrieves the current status for the connected user.
gpwDisconnectUserDisconnects the current user from the user groupware
gpwGetUserInfoRetrieves information about the current user (application that is using the user groupware).
gpwListOAuthParametersRetrieves the list of OAuth parameters defined for the user groupware, i.e. the list of providers (Google, Facebook, etc.) to which it is possible to connect via the user groupware. These parameters are defined via the user groupware administration site.
gpwOpenOpens the login window or page of user groupware.
gpwRemoteConnectAllows connecting to the application via the user groupware Webservice.
gpwResetPasswordResets the password of a registered user.
grSaveImageSaves the image of a chart in an Image variable.
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.
InfoAsynchronousDisplays a non-blocking custom message in a system information window.
InfoWithTimeoutAsynchronousDisplays a custom message in a non-blocking system information window for a given amount of time.
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.
OKCancelAsynchronousDisplays 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.
PDFReaderCloseCloses and frees the PDF file displayed in a PDF Reader control.
PDFReaderHighlightFinds a text in the document displayed by a PDF Reader control and highlights the occurrences of this text in the control.
PDFReaderOpenOpens a PDF file displayed in a PDF Reader control.
PDFReaderRotatePageRotates a page displayed in the PDF Reader control.
PDFReaderSaveSaves the content of a PDF Reader to a file.
PDFReaderSeekFirstInitializes the search for a text in a PDF file displayed by the PDF Reader control and positions on the first occurrence found (from the current page).
PDFReaderSeekNextSets the position on the next result of a search in the content of a PDF Reader control.
PDFReaderSeekPreviousPositions on the previous result of a search initiated by PDFReaderSeekFirst in the content of a PDF Reader control.
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.
SOAPAddSAMLAssertionAdds a SAML assertion to a Webservice request.
SOAPAddXMLSignatureAdds an XML signature to a Webservice request.
SSHCommandSends a command to an SSH server. The session is automatically started and closed as soon as the command is sent.
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.
SysThemeReturns the current theme used on the mobile device.
TableCollapseExpandCollapses or expands an element in a Table or TreeView Table control.
TelemetrySendDataSends telemetry data immediately.
ToastDisplayIWOpens a toast whose content is based on an internal window.
URIGetInfoRetrieves information of a URI resource.
URISelectOpens a system window to select a resource coming:
  • from the device file system,
  • from the Cloud (Google Drive, Microsoft OneDrive, etc.)
  • or from one of the content managers installed on the device.
URIToBufferLoads in the background the content of a resource (image, text, etc.) identified by its URI in a buffer variable.
URIToFileSaves, in the background, the content of a resource (image, text, etc.) identified by its URI in an external file.
WarningAsynchronousDisplays a custom message in a non-blocking system warning window.
XMLSignSigns an XML document.
YesNoAsynchronousDisplays a message in a standard non-blocking dialog box with the answers "Yes" and "No" and calls a WLanguage procedure with the user's response.
The new WLanguage functions (prefixed syntax) for iPhone/iPad 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.
<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.
<Looper>.DisplayPopupDisplays the automatic zoom popup for the Image Gallery control.
<PDF Reader>.CloseCloses and frees the PDF file displayed in a PDF Reader control.
<PDF Reader>.HighlightFinds a text in the document displayed by a PDF Reader control and highlights the occurrences of this text in the control.
<PDF Reader>.OpenOpens a PDF file displayed in a PDF Reader control.
<PDF Reader>.RotatePageRotates a page displayed in the PDF Reader control.
<PDF Reader>.SeekFirstInitializes the search for a text in a PDF file displayed by the PDF Reader control and positions on the first occurrence found (from the current page).
<PDF Reader>.SeekNextSets the position on the next result of a search in the content of a PDF Reader control.
<PDF Reader>.SeekPreviousPositions on the previous result of a search initiated by PDFReaderSeekFirst in the content of a PDF Reader control.
<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.
Apple Watch The new WLanguage functions for Apple Watch are as follows:
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.
DateSysReturns or modifies the system date (date of the day defined on the current computer).
dbgConnectUsed to connect a remote debugger to an application, service, Webservice, etc.
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.
InDeviceOwnerModeIndicates whether the Android application is in "Device owner" mode.
InKioskModeIndicates whether the Android application is in kiosk mode.
TimeSysReturns or modifies the system time (current time defined for the current computer).
The new WLanguage functions (prefixed syntax) for Apple Watch 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.
Universal Windows 10 App The new WLanguage functions for Universal Windows 10 App are as follows:
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.
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.
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.
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.
TelemetrySendDataSends telemetry data immediately.
ToastDisplayIWOpens a toast whose content is based on an internal window.
The new WLanguage functions (prefixed syntax) for Universal Windows 10 App 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.
<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.
Improved WLanguage functions
Windows Mobile The following WLanguage functions have been improved:
StringToDateNew constants to manage new masks.
CompileAbility to declare and use internal procedures.
DateToStringNew constants to manage new masks.
ExecuteCodeAbility to declare and use internal procedures.
gImageNew syntax to use an Image variable.
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.
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.
EmulateMouseMouse position is no longer required. If the mouse position is not specified, the mouse action is performed in the middle of the window or control.
NetworkConnectNew parameter to manage connection persistence.
AndroidAndroid Widget The following functions have been improved in this version:
StringToDateNew constants to manage new masks.
EncryptStandardThe cryptAES256 constant is now available.
dArcThe <Image> parameter is now available.
DateToStringNew constants to manage new masks.
dCircleThe <Image> parameter is now available.
dChangeModeThe <Image> parameter is now available.
dChordThe <Image> parameter is now available.
DecryptStandardThe cryptAES256 constant is now available.
dBackgroundThe <Image> parameter is now available.
dLineThe <Image> parameter is now available.
dPixelColorThe <Image> parameter is now available.
dPixelOpacityThe <Image> parameter is now available.
dPointThe <Image> parameter is now available.
dFontThe <Image> parameter is now available.
dPolygonThe <Image> parameter is now available.
dSliceThe <Image> parameter is now available.
dRectangleThe <Image> parameter is now available.
dRectangleGradientThe <Image> parameter is now available.
dFillThe <Image> parameter is now available.
dPenThe <Image> parameter is now available.
dTextThe <Image> 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).
FBRequestThis function is now available in the simulator.
FBGetUserInformationThis function is now available in the simulator.
FBStartSessionThis function is now available in the simulator.
gImageNew syntax to use an Image variable.
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.
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.
TelemetryConfigureNew constants used to manage the method to send telemetry data.
iPhone/iPad The following WLanguage functions have been improved:
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.
DateToStringNew constants to manage new masks.
EncodeNew constant to perform 64 encoding/decoding without CR (Carriage Return).
ExecuteCodeAbility to declare and use internal procedures.
DecodeNew constant to perform 64 encoding/decoding without CR (Carriage Return).
FBRequestThis function is now available in the simulator.
FBGetUserInformationThis function is now available in the simulator.
FBStartSessionThis function is now available in the simulator.
gImageNew syntax to use an Image variable.
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.
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.
TableExpandThis function can now be used on Table control breaks.
TableCollapseThis function can now be used on Table control breaks.
TelemetryConfigureNew constants used to manage the method to send telemetry data.
Universal Windows 10 App The following WLanguage functions have been improved:
StringToDateNew constants to manage new masks.
CompileAbility to declare and use internal procedures.
DateToStringNew constants to manage new masks.
EncodeNew constant to perform 64 encoding/decoding without CR (Carriage Return).
ExecuteCodeAbility to declare and use internal procedures.
DecodeNew constant to perform 64 encoding/decoding without CR (Carriage Return).
gImageNew syntax to use an Image variable.
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.
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.
TelemetryConfigureNew constants used to manage the method to send telemetry data.
New WLanguage properties
Android The new WLanguage properties for the Android applications are as follows:
DisplayedSection..DisplayedSection is used to find out and modify the section of an image displayed in an Image control.
FilePath..FilePath is used to find out:
  • the name of xlsx file associated with a Spreadsheet control. This name is initialized by SpreadsheetLoad and SpreadsheetSave.
  • the name of file associated with an Image Editor control. This name is initialized by PicOpen and PicSave.
  • the name of PDF file associated with a PDF Reader control. This name is initialized by PDFReaderOpen.
  • the name of DOCX file associated with a Word Processing control. This name is initialized by DocOpen and DocSave.
NumberDisplayedPage..NumberDisplayedPage is used to find out and modify the number of the page currently displayed in the PDF Reader control or in the Word Processing control.
NumberPage..NumberPage is used to find out:
  • the number of pages in a "multi-page" image file. This image is displayed in an Image control or in the background of a Chart control.
  • the number of pages in a PDF file displayed in an Image control.
  • the number of pages found in a PDF file displayed in a PDF Reader control.
  • the number of pages found in a DOCX file displayed in a Word Processing control.
PageNumber..PageNumber is used to:
  • find out and modify the number of the page displayed in an image control ("multi-page" image files)
  • find out and modify the page number of a PDF file displayed in an image control of a window
  • find out and modify the page number of a PDF file displayed in report background.
Zoom..Zoom allows you to find out and modify the zoom value used:
  • in an Image control.
  • in a Map control.
  • in an Organization Chart control.
  • in a Table, TreeView Table, Pivot Table, Spreadsheet or List Box control.
  • in a Word Processing control.
  • in a PDF Reader control.
  • in a window.
iPhone/iPad The following are the new WLanguage properties for iPhone/iPad applications:
FilePath..FilePath is used to find out:
  • the name of xlsx file associated with a Spreadsheet control. This name is initialized by SpreadsheetLoad and SpreadsheetSave.
  • the name of file associated with an Image Editor control. This name is initialized by PicOpen and PicSave.
  • the name of PDF file associated with a PDF Reader control. This name is initialized by PDFReaderOpen.
  • the name of DOCX file associated with a Word Processing control. This name is initialized by DocOpen and DocSave.
NumberDisplayedPage..NumberDisplayedPage is used to find out and modify the number of the page currently displayed in the PDF Reader control or in the Word Processing control.
NumberPage..NumberPage is used to find out:
  • the number of pages in a "multi-page" image file. This image is displayed in an Image control or in the background of a Chart control.
  • the number of pages in a PDF file displayed in an Image control.
  • the number of pages found in a PDF file displayed in a PDF Reader control.
  • the number of pages found in a DOCX file displayed in a Word Processing control.
PageNumber..PageNumber is used to:
  • find out and modify the number of the page displayed in an image control ("multi-page" image files)
  • find out and modify the page number of a PDF file displayed in an image control of a window
  • find out and modify the page number of a PDF file displayed in report background.
Zoom..Zoom allows you to find out and modify the zoom value used:
  • in an Image control.
  • in a Map control.
  • in an Organization Chart control.
  • in a Table, TreeView Table, Pivot Table, Spreadsheet or List Box control.
  • in a Word Processing control.
  • in a PDF Reader control.
  • in a window.
Improved WLanguage properties
Android The following WLanguage properties for Android applications have been modified:
DisplayMaskNew constants to manage new masks.
iPhone/iPad The following WLanguage properties for iPhone/iPad applications have been modified:
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.
DisplayMaskNew constants to manage new masks.
New advanced types of WLanguage
Windows Mobile The new advanced types available for the Windows Mobile applications are as follows:
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.
Android The new advanced types available for the Android applications are as follows:
gpwOAuthParametersThe gpwOAuthParameters type allows you to define all the information needed for authentication to the user groupware via an application that uses the OAuth 2.0 standard.
gpwUserThe gpwUser type is used to describe and modify the characteristics of a user of WEBDEV or WINDEV user groupware.
pdfAttachmentThe pdfAttachment type is used to define all the advanced characteristics of an attachment in a PDF document.
pdfDocumentThe pdfDocument type is used to find out all the advanced characteristics of a PDF file loaded in memory.
pdfPageThe pdfPage type is used to define all the advanced characteristics of a page of a PDF document loaded in memory.
pdfTextElementThe pdfTextElement type is used to find out all the characteristics of a text element in a PDF page.
sshSessionThe sshSession type is used to define the characteristics of a connection to an SSH server.
wsRequestThe wsRequest type is used to define the advanced characteristics of a Webservice.
wsResponseThe wsResponse type is used to get:
  • the XML source code of the Webservice response.
  • the value of the different parts of the Webservice response (for the Webservices returning several responses).
Android Widget The new advanced types available for the applications in Android Widget mode are as follows:
pdfAttachmentThe pdfAttachment type is used to define all the advanced characteristics of an attachment in a PDF document.
pdfDocumentThe pdfDocument type is used to find out all the advanced characteristics of a PDF file loaded in memory.
pdfPageThe pdfPage type is used to define all the advanced characteristics of a page of a PDF document loaded in memory.
pdfTextElementThe pdfTextElement type is used to find out all the characteristics of a text element in a PDF page.
sshSessionThe sshSession type is used to define the characteristics of a connection to an SSH server.
iPhone/iPad The new advanced types available for the iPhone/iPad applications are as follows:
AppleIDUn justificatif d'identité résultant d'une authentification réussie de l'identifiant Apple.
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.
gpwOAuthParametersThe gpwOAuthParameters type allows you to define all the information needed for authentication to the user groupware via an application that uses the OAuth 2.0 standard.
gpwUserThe gpwUser type is used to describe and modify the characteristics of a user of WEBDEV or WINDEV user groupware.
pdfDocumentThe pdfDocument type is used to find out all the advanced characteristics of a PDF file loaded in memory.
pdfPageThe pdfPage type is used to define all the advanced characteristics of a page of a PDF document loaded in memory.
pdfTextElementThe pdfTextElement type is used to find out all the characteristics of a text element in a PDF page.
sshSessionThe sshSession type is used to define the characteristics of a connection to an SSH server.
URIThe URI (Uniform Resource Identifier) type makes it possible to identify a physical resource (e.g.: a file) or an abstract resource (e.g.: a web page).
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.
Universal Windows 10 App The new advanced types available for the applications in Universal Windows 10 App mode are as follows:
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.
Improved advanced WLanguage types
Windows Mobile The following advanced types have been improved for Windows Mobile applications:
hBackupDescription..WebhookAfter, new property to trigger a REST service after a backup.
Android The following advanced types have been improved for Android applications:
httpRequestNew properties to manage the maximum data upload and download speeds.
Notification..AlertOnce, new property to manage the display of the notification if it has already been displayed.
iPhone/iPad The following advanced types have been improved for iPhone/iPad applications:
hBackupDescription..WebhookAfter, new property to trigger a REST service after a backup.
httpRequestNew properties to manage the maximum data upload and download speeds.
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment