Mechtilde Stehmann <webmaster <at> rechtsanwalt-stehmann.de> writes:

> > Is it possible to create table views when using OOoDB 2 with MySQL? If 
> > not then
> > how do I query the result of a query?
> 
> Yes, it is. follow the help-manual


thanks for that, after I had sent the email I tried again and found that 
by altering the SQL it worked. Previously I had used the HSQL backend, 
which has a slightly different SQL syntax. When I re wrote the query the
view worked ok.

Now all I have to do is sort out the other progblem with MySQL db's which 
is that after not editing a file for a length of time (the file is open, 
just not touched). Closing it, then re-opening it, all the queries have 
gone!

Lewis



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to