Manipulating WHERE statement at runtime, Inner/Outer Joins

rbuser

My application should be able to manipulate the WHERE statement of the
DADE
query without displaying a dialog.
SELECT * FROM table1 WHERE field1 = :fieldvalue;

Is it possible to create a Query like:
SELECT * FROM table1
LEFT OUTER JOIN table2 ON talbe1.id = table2.id
WHERE table2.id IS NUL;

Thank you for your assistance
Martin Sommerhalder

Enrionment:
Delphi 7.0 Build 8.1
RBuilder 9.01 Enterprise

nardmoseley

Use the TdaSQLBuilder to manipulate the TdaSQL object associated with a
dataview. See the RBuilder.hlp topic for TdaSQLBuilder. From there you can
access related topics that contain code examples.


--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com