Environment of the query editor Select query description window The description window of a select query includes several sections...... Query creation mode: independent or embedded query The query editor proposes two methods for creating a query...... Description window of a combining query The description window of a combining query consists of several sections...... Modifying the query content The queries are used to easily select the records coming from one or more files, matching one or more selection criteria, ...... SQL view An SQL view is a virtual data source defined by an SQL query...... Report based on a data file A report based on a data file is used to print the records coming from a single data file (HFSQL Classic or Client/Server, accessed via a Native Access, ...... Table, List Box and Combo Box controls bound to queries A Table, List Box or Combo Box control can be used to display the content of a data file or query...... SQL commands available in an SQL query WINDEV allows you to easily run queries in SQL code...... Linking a Table control to a data file or query A Table control can be used to display the content of a data file or query...... Operating mode of HFSQL application A HFSQL application can operate in network mode or in Client/Server mode...... How to create an SQL query to get a sum? This help page explains how to create a Sum query with the query editor.... Query and project Example for creating a select query This help page explains how to create two select queries...... How to create an SQL query to count? This help page explains how to create a count query with the query editor.... NULL values in HFSQL WINDEV, WEBDEV and WINDEV Mobile allow you to manage the NULL value in the items of HFSQL data files and for all the other types of accesses (Native, OLE DB, ...... User Groupware and LDAP The LDAP protocol is increasingly used by the companies...... 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.... The user version of query editor : Specific features This help page presents the specific features of the user version of query editor...... Query based on query Queries can be based on items from another query...... HPrepareSQLQuery (Function) Initializes a query written in SQL language and declares this query to the database server in order to optimize the next executions of this query. Managing the remote accesses The remote accesses are used to create a temporary network connection...... How to create an SQL query to get a TOP 10? This help page presents the method for creating an SQL query used to get the first 10 records...... Management errors specific to Native Connectors When an HFSQL function fails (returns False for example), the corresponding error number is returned by HError...... Database access: summary WINDEV and WEBDEV support different SQL query execution modes depending on how the database was accessed.......