Hi Bill, When I want to join (Using MSSQL) across databases I use the Direct DBMS in Witango. Works just fine. I figure if I can do it in a direct DMBS that a standard select statement should do it as well. I mean, it's just generating the SQL code so if it can link between tables in the same database it should be able to link between tables between databases. Just a request that would make my world a bit easier in some cases. Not a critical request.
-----Original Message----- From: William M Conlon [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 25, 2007 5:20 PM To: [email protected] Subject: Re: Witango-Talk: Studio Feature Request Hi Gene, Your's is a separate feature request, unrelated to mine. But ... mySQL will not JOIN across databases. I certainly don't know the SQL standard very well -- does it permit the JOIN clause to refer to different databases? Bill On Sep 25, 2007, at 2:02 PM, Wolf, Gene wrote: > How about the ability to use a standard search action and join tables > from multiple databases just like joining tables from the same > database? > > > -----Original Message----- > From: William M Conlon [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 25, 2007 2:46 PM > To: Witango-Talk > Subject: Witango-Talk: Studio Feature Request > > How about an Array builder? > > Specify the name, scope, number of rows and columns, and you get a > spreadsheet like interface with a grid so you can quickly enter and > edit the array values. A radio button lets you select output as an > Action of as metatags to create an array variable and all the > elements. > > > Bill > > William M. Conlon, P.E., Ph.D. > To the Point > 2330 Bryant Street > Palo Alto, CA 94301 > vox: 650.327.2175 (direct) > 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/developer/maillist.taf > ______________________________________________________________________ > __ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
