I can buy that it's the username, not the database name that is prepended, since I have a user 'vcs' that has access to the vcs database. But I still don't get why ONLY the joins are so delineated. The regular selected columns don't have the username pre-pended.
And moreover, why should the username have anything to do with the SQL statements? Shouldn't the username/password attributes go with the access method, not with SQL SELECT statement, as it seems like this makes the appfile very unportable. >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 > 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
