MySql and views

how to work around them

[mika_jussi]

I have "inherited" an MsAccess database which I have converted to MySql. The problem is the views used in the MsAccess-database. Is there any way to work around the views in MySql? I am really new to MySql, so this is very unclear to me. The programs using the database are all written in asp. The rest of the connections are working, now the final thing that needs to be resolved is altering the views to work with the rest.

[coopster]

Welcome to WebmasterWorld, mika_jussi!

Are running your own servers? Views [dev.mysql.com] are being implemented in the 5.0 version of MySQL Server. Particularly MySQL 5.0.1.

[mika_jussi]

Hi there coopster,

sadly I've got everything running on a commercial server, so I'll just have to wait for the next version of MySql for that.

[coopster]

Well, there are workarounds, and the size of the task is directly relative to the complexity of the views as well as how they are being used. For example, if the views are merely being used for simple column display and you are doing this for the web, just write your query statements accordingly.

[mika_jussi]

Thanks for your help, coopster. I did get some further in my task that untill now seemed almost impossible. I got the query working fine, I guess, at least I didn't get any error messages on that. The problem I hit this time was as follows: There are further queries that work with the results that the view has been giving - a little something that doesn't work when i'm putting in the view as a query statement.

I hit a manual on in-line views, something I thought could solve some of the problem. Could using in-line views be a solution? If not, are there other ways to recommend?