ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Version: 2025

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.
Parameter of a procedure/function
You have the ability to pass parameters to a procedure....
Calling a procedure/a function
Syntax for calling a local or global procedure.
SQLGetTextMemo (Function)
Retrieves the content of a Text Memo column found in the query result, for the current line.
SQLSeek (Function)
Positions on the specified result row of the query.
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.
SQLReqExists (Function)
Checks the existence of a query.
Local procedure
Two types of procedures are available......
Procedure/Function
A procedure is used to associate an identifier with a statement block......
SQLListSource (Function)
Lists the data sources declared on a local site.
Global procedure/function
A global procedure can be used in all the processes or events of the project....
Describing a query
Once a query is created, all the characteristics of this query can be modified at any time......
SQLPrevious (Function)
Positions on the previous 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.
SQLNext (Function)
Positions on the next row of the query result.
Report viewer: "Print" tab
The report viewer allows end users to view reports before printing them......
Items used in a select query
A query created in the query editor can contain several types of items......
ColorSaturation (Function)
Calculates the saturation of a color.
ColorLightness (Function)
Calculates the lightness of a color.
Automatic documentation of procedures and methods
To simplify the maintenance or the use of existing code by other developers, WINDEV proposes an automatic documentation for the procedures (or class methods)......
ColorHue (Function)
Calculates the hue of a color.