ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Editors / Query editor / SQL
  • Overview
  • How to?
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Cross-database queries
ODBCOLE DBNot available with these kinds of connection
Overview
An SQL query can run on different server databases: HFSQL, Oracle, SQL Server, etc.
You can join queries that fetch data from different databases.
This means that data can be stored on different databases. You have the ability to extract and aggregate data from any source.
This feature is very useful for managing existing Information Systems.
How to?
To better understand the operating mode of the cross-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 an 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 cross-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.
Note: Cross-database queries cannot be run with "SQL query" variables. It is necessary to use "Data Source" variables.
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 12/09/2024

Send a report | Local help