MySQL and Calc sheets ...

gillesdeshays · General User Joined: 14 Jul 2005 Posts: 5

I have my old mysql database wich is now "connected" on OOo via ODBC ...

Everything works well ...

But i cannot find how to do what i need ....

I want to return in a cell, a text, extracted from a column in a table (anglais) of the database using LIKE fucntion ....

in my DB table i have a column called "transid" which contains a reference and an other called "expr" wich contains the english name of the reference ....

Refernce are like that : YY-X-XXXX-XXX where Y : letters and X : numbers

I need to "call" the english name (expr) in the DB which correspond to a reference in the calc sheet ...

On my calc sheet , the first column contains the refernce without the last 4 characters ( YY-X-XXXX ) and i want to use it to "call" the corresponding english name (expr) and return it in a cell ...

I tryied many many things without any success ...

the sql equivalent may be :
SELECT `expr` FROM `anglais` WHERE `transid` LIKE 'B12'
where B12 is a cell ....

But i can't make it works ....

Can somebody help me ? Wink

Thanks !

PS: i hope being enough clear .)

gillesdeshays · General User Joined: 14 Jul 2005 Posts: 5

mmmmmmmmmm .... doesn't inspire anybody .... Crying or Very sad

gillesdeshays · General User Joined: 14 Jul 2005 Posts: 5

Today i can tell that i really cannot understand how works the database with OOo ... !!!

I cannot find any tutorial to help me and i notice that there s many newbies like me which have many difficulties to export data from a dB to a cell ...

Sad