ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

HFSQL management functions
List of functions for HFSQL management...
ListDeleteAll (Function)
Clears a List Box, ListView or Combo Box control populated programmatically.
HError (Function)
Returns the number of the last error triggered by the HFSQL engine.
HErrorLock (Function)
Used to check whether a lock error occurred.
HErrorStatusModification (Function)
Returns the status of a record during a modification conflict.
SQLTable (Function)
Transfers the result of a query to a Table control populated programmatically (a List Box or Combo Box control), with the possibility of Partial Fetch (the result is retrieved by blocks of rows).
SQLNext (Function)
Positions on the next row of the query result.
SQLReqExists (Function)
Checks the existence of a query.
SQLPrevious (Function)
Positions on the previous row of the query result.
SQLFirst (Function)
Positions on the first row of the query result.
SQLSeek (Function)
Positions on the specified result row of the query.
SQLModify (Function)
Modifies the content of a row in the query result.
TreeListItem (Function)
Lists the "children" of a node and the "child" elements of these "children" in a TreeView control.
SQLGetTextMemo (Function)
Retrieves the content of a Text Memo column found in the query result, for the current line.
SQLGetMemo (Function)
Retrieves the content of a Memo column from the query result, for the current row.
SQLGetCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
SQLExecWDR (Function)
Runs the SQL code of a query created in the query editor.
SQLExec (Function)
Names and runs an SQL query.
SQLDisconnect (Function)
Closes the current connection and frees the memory used by the connection.
SQLLast (Function)
Sets the position on the last row of the query result.
SQLColumn (Function)
Returns the characteristics of all the columns (or items): for a given table. for a given query....
SQLCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
SQLChangeConnection (Function)
Modifies the current connection.
Programming the looper attributes
All the looper attributes can be handled by programming......
Context menu associated with Table controls and their columns (AAF)
WINDEV applications automatically include a context menu for Table controls, TreeView Table controls and their columns......