ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

Deploying a Java archive
Like for any application, WINDEV allows you to create a setup program for a Java application......
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.
SQLConnect (Example)
Usage example of the SQLConnect function
SQLGetTextMemo (Function)
Retrieves the content of a Text Memo column found in the query result, for the current line.
Managing databases in the WINDEV Java applications
This document presents the different access modes to databases from a WINDEV Java application......
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.
SQLReqExists (Function)
Checks the existence of a query.
Prototype overload/Overload
The procedures and the methods of classes can have several syntaxes....
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.
SQLListSource (Function)
Lists the data sources declared on a local site.
SQLChangeConnection (Function)
Modifies the current connection.
Describing a query
Once a query is created, all the characteristics of this query can be modified at any time......
5. Which type of server to choose?
SQLNext (Function)
Positions on the next row of the query result.
SQLPrevious (Function)
Positions on the previous row of the query result.
SQLFirst (Function)
Positions on the first row of the query result.
SQLGetMemo (Function)
Retrieves the content of a Memo column from the query result, for the current row.
SQLLast (Function)
Sets the position on the last row of the query result.