A query is used and works as desired in MySQL Query Browser. However if the same query is run in ooBASE the AS clause on existing columns is ignored. Furthermore dates are reflected in five digit numbers plus one IF containing CONCAT statement is returned as an OBJECT field... Is there a translation problem between MySql and ooBase? I have to point out the very exact same query if it is run on the mebeded HSQL database works like a charm. Everything displays as desired in the HSQL.
My SETUP:
JAVA 1.6.0_03
MySQL 5.1
MySQL connectorJava 5.0.8
[Solved] ooBASE MySQL Query
-
compuwatch
- Posts: 24
- Joined: Sat Jan 12, 2008 1:36 am
[Solved] ooBASE MySQL Query
Last edited by compuwatch on Wed Jan 30, 2008 2:30 am, edited 1 time in total.
Re: ooBASE MySQL Query
Turn off the design view, paste the same query string that works with the other tool and turn on "Menu:Edit>Run SQL command directly".
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
compuwatch
- Posts: 24
- Joined: Sat Jan 12, 2008 1:36 am
Re: [SOLVED] ooBASE MySQL Query
I followed a good advice (SLIDERULE) and de-constructed the issue. I had to downgrade to MySQL 5.0 and also use the corresponding Java connector. All works fine now. AS clause works and the issue with the OBJECT is gone as well.
As always,
HANS
As always,
HANS