subject:"\[libreoffice\-users\] problem in sql query"

Re: [libreoffice-users] problem in sql query

2011-10-04 Thread planas

Hi On Tue, 2011-10-04 at 17:00 +0200, Daniele Palumbo wrote: > hi all > > i am using eloquence database, linked with base. > > this query is working: > SELECT TORD.NUMORD AS ORDINE, CONCAT( CONCAT( CONCAT( CONCAT( CONCAT( > TORD.GGORD, '/' ), TORD.MMORD ), '/' ), '20' ), TORD.AAORD ) AS > DA

[libreoffice-users] problem in sql query

2011-10-04 Thread Daniele Palumbo

hi all i am using eloquence database, linked with base. this query is working: SELECT TORD.NUMORD AS ORDINE, CONCAT( CONCAT( CONCAT( CONCAT( CONCAT( TORD.GGORD, '/' ), TORD.MMORD ), '/' ), '20' ), TORD.AAORD ) AS DATAORDINE, CONCAT( CONCAT( CONCAT( CONCAT( CONCAT( TORD.DCORGG, '/' ), TORD.DCO