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
