Left outer join in Report Builder 7.02 and Delphi 7

rbuser

We have two version of Report builder for Delphi 4.0 is 6.03.
In this version when I've a join on join table and add that table to
available table list the sol query will look like this

SELECT customer.TaxRate TaxRate_2, customer.Zip
FROM "orders.db" orders
LEFT OUTER JOIN "customer.db" customer ON
(customer.CustNo = orders.CustNo)

But When I do that in SQL Anywhere database and it looks like



Delphi 7 and SQL Any where database with nativeDB driver.




SELECT *
FROM EXE.CIItem CIItem, EXE.CILayer CILayer
WHERE (CILayer.CIItemID = CIItem.CIItemID)
This above query works fine for inner joins but if a have to add left outer
join this query will not work because eventhogh data dictionary has
dajtleftOuter it still put's the table as inner join.

Any help will be appreciated in this matter.

nardmoseley

The Designer.DataSettings.SQLType and DatabaseType properties are used
control the SQL syntax that is generated.

For Delphi design-time this is can be set via the File | DataSettings dialog
of the Designer's Data workspace.

For the end-user Designer, this can be set via the TppDesigner.Datasettings
property.

For SQLAnywhere set SQLType to sqSQL2 and DatabaseType to dtSybaseASA





--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com