This is not due to Witango changing it is due to you changing to a database that has owners of table with in the database.
VCS is the account that created the tables. Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Bill Conlon [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 10:14 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Dev Studio: ODBC joins It's not the column, but the fact that the database name is prepended. So the Select is organizations.name but the join is to vcs.organizations.id Note the database 'vcs' pre-pended. >Typically there is a drop down list of fields in the join window. Witango >doesn't always select the right field for the foreign key. > >John >> >> I'm in the process of migrating from Tango 3.5/Butler to >> witango5-linux/mySQL. I'm a little curious about how the key fields are >> defined for joins in the search action. >> >> Here's a portion of the db to illustrate >> >> Database vcs >> >> Table users >> userid >> organizations_id >> >> Table organizations >> id >> name >> >> Previously, I would drag the foreign key "users.organizations_id" and the >> primary key "organizations.id" into the join tab, and the quoted columns >> would be inserted. >> >> Now, when I drag those columns, the join is made to >> "vcs.users.organizations_id" and "vcs.organizations.id" -- note the >> prepended database name. Curiously, the database name is NOT prepended >> to the column name in the Select tab. >> >> I'm using Openlink ODBC on the Mac Dev Studio. Is this a new "feature" >> to allow joins to disparate databases or is something else going on? The >> fact that I can't just convert my tafs without re-doing all the joins has >> me worried that the ODBC setup isn't right. >> >> Bill Conlon >> >> To the Point >> 345 California Avenue Suite 2 >> Palo Alto, CA 94306 >> >> office: 650.327.2175 >> fax: 650.329.8335 >> mobile: 650.906.9929 >> e-mail: mailto:[EMAIL PROTECTED] >> web: http://www.tothept.com >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf >_______________________________________________________________________ _ >TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > Bill Conlon To the Point 345 California Avenue Suite 2 Palo Alto, CA 94306 office: 650.327.2175 fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
