Good luck with this ;o) Yes, 8i is still unsupported, pretty much because it doesn't follow ANSI Join syntax.
Mark On Tue, Dec 2, 2008 at 3:56 AM, Dan Vega <[EMAIL PROTECTED]> wrote: > > Right > I am still kinda new so I didnt feel like spending a ton of > time trying to fix transfer to work with 8 but its looking like I > might have to do that. Everything in Transfer works fine so far on 8 > except when I update my config to use relationships. Any thoughts? > > Here is the Join Syntax for 8 > > select p.part_id, s.supplier_name > from part p, supplier s > where p.supplier_id = s.supplier_id (+); > > 9+ > select p.part_id,s.supplier_name > from part as p > left outer join supplier as s ON s.supplier_id = p.supplier_id > > > On Dec 1, 11:41 am, "Dan Wilson" <[EMAIL PROTECTED]> wrote: >> Dan, >> Are you talking about the (+) syntax? >> >> I've refactored that syntax out to use the Join Keywords in Oracle 9 & 10, >> though I can't remember if that is valid for 8i. I'm just asking for my own >> benefit... >> >> DW >> >> On Mon, Dec 1, 2008 at 11:14 AM, Dan Vega <[EMAIL PROTECTED]> wrote: >> >> > Is this still unsupported? I have a database that is 8i and didnt >> > realize it was not supported until I was half way through a project. >> > Everything works fine until you get into doing JOINS. Oracle 8i has >> > some funny syntax to create joins and changed over in 9. If its not >> > supported has anyone updated transfer to support this? >> >> -- >> "Come to the edge, he said. They said: We are afraid. Come to the edge, he >> said. They came. He pushed them and they flew." >> >> Guillaume Apollinaire quotes > > > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
