Native SQLite Connector: Programming with SQL functions The use of SQL functions to handle SQLite data does not require importing the data file structure into the analysis.... SQLite: Programming with HFSQL functions To use an SQLite database with Native Connector (also called Native Access), the structure of SQLite tables must be imported into the data model editor.... SQL statements The main SQL statements allowed in the SQL queries managed by WINDEV and WEBDEV are as follows...... SQL query (WLanguage type) The "SQL query" type is used to write an SQL query in the WLanguage code. How to create and run an SQL query through programming? This help page explains how to create and run an SQL query through programming.... Mathematical SQL functions The mathematical SQL functions that can be used on the queries written in SQL code are as follows...... SQL view An SQL view is a virtual data source defined by an SQL query...... SQL: Managing joins (INNER JOIN, OUTER JOIN) To select records coming from several data files, joins must be used in the SQL query...... SQL functions that can be used in SQL queries The following SQL functions can be used on the queries written in SQL code (classified by theme)...... Native SQL Server Connector: Programming with HFSQL functions To use an SQL Server database with Native Connector, the structure of SQL Server tables must be imported into the data model analysis...... Native SQL Server Connector for WINDEV and WEBDEV WINDEV and WEBDEV support an optional Native SQL Server Connector (also called Native SQL Server Access)...... WDSQL: Converting the structure of an HFSQL database WDSQL is used to convert the structure of an HFSQL database into SQL script...... <Source>.ExecuteSQLQueryAsynchronous (Function) Executes an SQL query asynchronously. HExecuteSQLQueryAsynchronous (Function) Executes an SQL query asynchronously. SQLExec (Function) Names and runs an SQL query. ODBCSQLCode (Property) ODBCSQLCode is used to: Find out the SQL code of the "query performed on a connection" (data source of report). Modify the SQL code of the "query performed on a connection" (data source of report).... How to create an SQL query to get a sum? This help page explains how to create a Sum query with the query editor.... SQL commands available in an SQL query WINDEV allows you to easily run queries in SQL code...... How to create an SQL query to count? This help page explains how to create a count query with the query editor.... Native SQL Server Connector: Programming with SQL functions The SQL functions can be used to handle the SQL Server database...... SQL : ORDER BY clause: Organizing the result of a query The ORDER BY clause is used to sort the records selected by an SQL query...... SQLExecWDR (Function) Runs the SQL code of a query created in the query editor. WDSQL: Running an SQL query WDSQL is used to run all the SQL queries created by WDSQL...... SQL selection conditions To specify the selection conditions in an SQL query, you can use...... CalculatedItemExpression (Property) The CalculatedItemExpression property is used to: Find out the SQL expression that defines the value of a calculated item. This item was defined in the data model editor or through programming. Define the SQL expression returning the value of a calculated item (when describing the item through programming)....