HExecuteSQLQuery (Function) Initializes a query written in SQL language and declares this query to the HFSQL engine. <Source>.ExecuteSQLQuery (Function) Initializes a query written in SQL language and declares this query to the HFSQL engine. 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. <Source>.PrepareSQLQuery (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. How to create a query with external join? In SQL language, an external join is used to exclude or include file records with or without correspondences in the linked files...... SQL: Managing joins (INNER JOIN, OUTER JOIN) To select records coming from several data files, joins must be used in the SQL query...... Select query description window The description window of a select query includes several sections...... Description window of a combining query The description window of a combining query consists of several sections...... Creating a query in SQL code The query editor allows you to create a query by typing SQL code...... Managing Hive databases Hive is a software layer of Hadoop used to run queries...... 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...... External language: Programming in COBOL We are going to call the elements developed in WINDEV (project, windows, analysis, ...... External language: Programming in Java We are going to call the elements developed in WINDEV (project, windows, analysis, ...... Overview of external languages External language: Programming in Pascal We are going to call the elements developed in WINDEV (project, windows, ...... External language: Programming in C# We are going to call the elements developed in WINDEV (project, windows, analysis, ...... 7. Multilingual applications in practice External language: Programming in C We are going to call the elements developed in WINDEV (project, windows, ...... Comparing the project messages The comparison between source and target text helps you find translation errors...... Creating an executable: Language of the executable When creating the executable, you have the ability to choose the languages that will be included in the executable...... Handling data files in PHP WEBDEV allows you to create a PHP site that handles data files...... External language: Programming in Fortran We are going to call the elements developed in WINDEV (project, windows, analysis, ...... Defining specific character sets in HFSQL data files When an application is used to display or save data in HFSQL files, this data is entered in the current language...... Managing the application language through programming A multilingual application is an application that can be distributed in several languages......