> Here's what I'm thinking, just looking to see if anyone has done this or > similar. > > - I have a MySQL DB and I create an ODBC datasource for it on my windows > box > - I then open MS Access and link the tables from my datasource > - Access provides a graphical relationship builder, so I build relations > in > this > - Access also provides a graphical query builder that uses the stored > relationships > - So I build a query, view the SQL and use the SQL code in some mysql_ > PHP > functions > > - Maybe next I instead save the queries in a query table so I can get them > via simple name, like 'All_Customers' > Sort of analogous to MS SQL Views?
You may want to consider switching to PostgreSQL which supports views, as well as cascading updates among tables with foreign key constraints. However, since it requires cygwin to run on MS Windows it is not the best for cross platform solutions. > > Sound good, or is there a better way? > > TIA > -Shawn > > P.S. I've also seen mention of some graphical query builders. Can anyone > recommend a good FREE one? > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Thanks, Dean E. Weimer http://www.dwiemer.org/ [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
