ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

SQL functions for accessing the external databases
List of SQL functions used to access the external databases...
Synonym (Property)
The Synonym property is used to define synonyms in a programmatically defined full-text index.
Stemming (Property)
The Stemming property is used to enable stemming and to define the language used for stemming in a full-text index defined through programming.
<Source>.InfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
SourceKey (Property)
The SourceKey property sets the characteristics of a link.
Query technical documentation
The query editor automatically creates a technical documentation for each query......
StopWord (Property)
The StopWord property is used to define stopwords in a full-text index defined through programming.
The different types of browse available in SQL
Two types of browse can be used to browse the result of a query run by SQLExec......
HDeleteServerTrigger (Function)
Deletes a server trigger.
HDeleteLink (Function)
Deletes an integrity rule between two data files on the server.
HInfoLock (Function)
Returns information about the lock set on a data file, on one or all the records in a data file.
HDescribeServerTrigger (Function)
Adds or modifies a server trigger.
HInfoServer (Function)
Returns the specified information about the server.
HNoDatabaseAccess (Function)
Denies all new connections to a database or to all databases.
HEndNoDatabaseAccess (Function)
Re-allows the access (which means the connection) to one or more databases accessible via a connection.
HListDatabase (Function)
Lists the Client/Server databases associated with a connection....
WDLog: Restoring a data file from its log
WDLog is used to apply to a backup of a data file the different operations saved in the log of this file......
HTransactionList (Function)
Returns the list of current or interrupted transactions on the server for the specified connection.
<Source>.ExecuteQueryAsynchronous (Function)
Executes a SELECT query asynchronously.
<Source>.JSONToRecord (Function)
Imports JSON data into the current record.
<Source>.RestorePosition (Function)
Restores the context of a previously saved file (HSavePosition): current record, filter, pointers.
<Source>.DeactivateAutoFilter (Function)
Disables an automatic filter on the linked files when browsing an XML file.
<Source>.RecordToXML (Function)
Retrieves the structure and the value of the current record and exports them into a character string in XML format.
<Source>.Seek (Function)
Positions on the first record of the data file whose value for a specific item is greater than or equal to a sought value (generic search by default).
HInfoAnalysis (Function)
Returns information about an analysis (WDD file).