PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • How to proceed?
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Multi-database queries
ODBCOLE DBNot available with these kinds of connection
Overview
A query (typed in SQL code) can operate on different databases: HFSQL, Oracle, SQL Server, ...
You can perform a join between a query on a database of one type and a query on a database of another type.
Therefore, the data can be found in different databases. You have the ability to extract and aggregate data from any source.
This feature is very useful for managing existing Information Systems.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
How to proceed?
To better understand the operating mode of the multi-database queries, let's look at a simple example:
  1. On an Oracle database, the following query (named MyQry1) is run by HExecuteSQLQuery. This query is used to select the record numbers of the customers.
    SELECT Customer.CUUniqueKey+10 AS CUUniqueKey10 FROM Customer
  2. On a HFSQL database, the following query (named MyQry2) is run by HExecuteSQLQuery. This query is used to select the record numbers of the customers and their order number.
    SELECT CUUNIQUEKEY,Orders.OrderNumber AS ORDERNUM FROM ORDERS
  3. The multi-database query executed is as follows:
    SELECT * FROM MyQry1,MyQry2
    WHERE MyQry2.CUUniqueKey=MyQry1.CUUniqueKey10
    AND (MyQry2.ORDERNUM = '37348' OR MyQry1.CUUniqueKey10=80)

    This query is run itself by HExecuteSQLQuery.
Minimum required version
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment