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
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.
fDirRenameModifie le nom d'un répertoire.
HUpdateLinkUpdates on the server all the links of an HFSQL Client/Server data file.
iInitInternalReportInitialise les paramètres d'un état interne
InDeviceOwnerModeIndicates whether the Android application is in "Device owner" mode.
InKioskModeIndicates whether the Android application is in kiosk mode.
iSetAdditionalXMPAjouter dans les métas donnés du fichier PDF généré des balises XMP.
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.
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
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.
New WLanguage properties
Improved WLanguage properties
New advanced types of WLanguage
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
Minimum version required
  • Version 25
This page is also available for…
Comments
Click [Add] to post a comment