ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

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......
SQL functions for accessing the external databases
List of SQL functions used to access the external databases...
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.
HInfoAnalysis (Function)
Returns information about an analysis (WDD file).
<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).
<Source>.SavePosition (Function)
Stores the current file context: current record, filter, pointers.
<Source>.RecordToJSON (Function)
Retrieves the structure and value of the current record and exports them into a string in JASON format.
<Source>.Mode (Function)
Changes the mode and the method for locking data files.
HDBDescribeField (Function)
Describes through programming each item found in the structure of an xBase file described by HDBDescribeFile.
<Source>.State (Function)
Used to find out the state of a record.
HSubstDir (Function)
Associates the data directory specified in the analysis with a directory found on disk.