Kbase P112660: Is there a way to form a union of queries from two different tables to create a single table in a Pr
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/25/2006 |
|
Status: Unverified
GOAL:
Is there a way to form a union of queries from two different tables to create a single table in a ProDataSet?
FIX:
The 4GL does not directly support the functionality of a UNION in SQL. The best way to load data into a single temp-table within a ProDataSet from two different database tables is to not use the FILL method but instead simply walk through each table one at a time and use the CREATE and BUFFER-COPY commands to copy the data into the temp-table.