only support outer joins in one direction. I.e. They might only support a
left outer join but not a right one. However, you can always switch the order
of the tables in the join definition to change the direction of an outer join. :)
Stefan
At 07:51 AM 2/4/2003 -0500, you wrote:
========================================================I played around with OpenBase last spring. If memory serves me correctly, there was limited support for outer joins.Bill's suggestion was a good one, you might want to find the syntax for what you're trying to do (if it exists), put it into a Direct DBMS action and then work backwords to see if there is a way of doing it inside of a Witango action. Hope this helps, Steve Smith Oakbridge Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.oakbridge.ca > -----Original Message----- > From: Christian Platt [mailto:[EMAIL PROTECTED]] > Sent: February 4, 2003 1:30 AM > To: [EMAIL PROTECTED] > Subject: Witango-Talk: Outer Joins > > > Ji list, i am missing a "*" symbol for outer joins in the search action. > Instead i find left "*=" and right "=*" outer join, which my database > (Openbase) does not understand. Is that partt of tango or the > iODBC Driver? > > Christian > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
Database WebWorks: Dynamic web sites through database integration
http://www.DatabaseWebWorks.com
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body