Bob- Monday, May 24, 2010, 9:00:59 PM, you wrote:
> I am not a MySQL expert but I have found that it is possible to > join different databases, each with various tables. Bob S.'s main issue here is that he's trying to join two different *types* of databases, a MySQL database and a SQLite database. That can't be done with an SQL statement because the SQL command is performed by the database itself. So if you send a SQL command to the MySQL database it's getting executed by the MySQL engine, not by rev. The MySQL engine has no knowledge of any other databases, and so it would fail. I think the only way around this is to issue two SQL commands, one to MySQL, one to SQLite, then take the recordsets and mangle them yourself, pretending that you're the cross-db-type engine. Could get ugly. -- -Mark Wieder mwie...@ahsoftware.net _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution