ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

New Features brochure - Version 27: Common new features
New features in WINDEV/WEBDEV/WINDEV Mobile 27 presented in the New Features brochure....
Reports
A report provides a custom view of data......
New Features brochure - Version 28: Common new features
New features in WINDEV/WEBDEV/WINDEV Mobile 28 presented in the New Features brochure....
Select query: Displaying the first/last n records
The editor of Select queries is used to limit the number of records that will be displayed in the result of the query....
Brochure of new features: Common new features
New features in WINDEV/WEBDEV/WINDEV Mobile 28 presented in the New Features brochure....
Windows
The windows represent the main interface of a WINDEV application......
Query
The keyword "Query" is used to describe:
SQLTransaction (Function)
Begins, commits or rolls back a transaction: on the files of a database opened by SQLConnect, on the files of a database opened by a connection (OLE DB or Native Access/Native Connector) described in the data model editor or by HOpenConnection....
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).
Operations in a Select query : add and delete
The following paragraphs present......
SQLColumn (Function)
Returns the characteristics of all the columns (or items): for a given table. for a given query....
SQLLock (Function)
Used to lock: The entire data table, in read and write mode. Its data cannot be accessed by other computers. The records selected by the query. This data cannot be accessed by the other computers. This method can be used to update records for example....
Accessing a database in local mode (SQLite)
WEBDEV allows a site to create and access a database created by the browser on the computer of the Web user in browser code....
SQLColumnFormat (Function)
Returns the different types of columns supported: by the data source identified by SQLConnect by the database accessed by a specific connection (connection described in the analysis or described by HDescribeConnection or HOpenConnection)....
SQLClose (Function)
Declares the end of the query execution and frees the memory resources allocated during the execution of the query.
SQLGetTextMemo (Function)
Retrieves the content of a Text Memo column found in the query result, for the current line.
SQLModify (Function)
Modifies the content of a row in the query result.
SQLListTable (Function)
List all the tables that can be accessed by the connected database system.
SQLSeek (Function)
Positions on the specified result row of the query.
Prototype overload/Overload
The procedures and the methods of classes can have several syntaxes....
SQLReqExists (Function)
Checks the existence of a query.
SQLGetCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
SQLCol (Function)
Retrieves the content of the specified column from the query result, for the current line.
SQLFetch (Function)
Goes to the next row (i.e next record) of the query result.
SQLAssociate (Function)
Automatically associates each column of the query result with a control or with a variable of the application.