You may want to consider switching to PostgreSQL which supports views, as> Here's what I'm thinking, just looking to see if anyone has done this or
> - I have a MySQL DB and I create an ODBC datasource for it on my windows
> - I then open MS Access and link the tables from my datasource
> - Access provides a graphical relationship builder, so I build relations
> - Access also provides a graphical query builder that uses the stored
> - So I build a query, view the SQL and use the SQL code in some mysql_
> - Maybe next I instead save the queries in a query table so I can get them
> via simple name, like 'All_Customers'
> Sort of ogous to MS SQL Views?
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?
> P.S. I've also seen mention of some graphical query builders. Can anyone
> recommend a good FREE one?
> PHP General Mailing List ([url]http://www.php.net/[/url])
> To unsubscribe, visit: [url]http://www.php.net/unsub.php[/url]
Dean E. Weimer