Kbase 16377: What is new in V8.1 Report Builder ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
What is new in V8.1 Report Builder ?
This knowledgebase lists what is new in V8.1 Report Builder.
When v8.0A introduced OUTER JOINS the syntax changed for both
INNER and OUTER joins in the SQL statement that is created by
Report Builder. This new syntax is slower than the original
syntax used in v7.3 which is logged as bug 96-05-28-028.
In v8.1 Report Builder will use the v7 syntax for the SQL
statement in report that contains ONLY INNER joins.
If a report contains INNER and OUTER joins, the new v8.0A syntax
will be used for both types of joins.
Example:
v7.3 syntax
-----------
select
Customer.Cust-Num, Invoice.Invoice-Num
from
Customer, Invoice
where
Customer.Cust-Num = Invoice.Cust-Num
v8.0A syntax
------------
select
Customer.Cust-Num, nvoice.Invoice-Num
from
Customer Customer INNER JOIN Invoice Invoice ON
Customer.Cust-Num = Invoice.Cust-Num
Progress Software Technical Support Note # 16377