Andrew Jensen ha scritto:
Hi,
Just an FYI.
I have been compliling a series of tests for support of the HSQL
built-in functions under the query designer. ( I finally got all of
them listed in the HSQL users manual finished ) The results of the
tests can be found at
http://www.paintedfrogceramics.com/OpenOffice/hsql_functions.ods as
you can see it is getting darn close to full coverage. The last test
queries where run with release OOOD680_M1.
The only two functions that I would have expected to work in the
designer that don't are CONVERT and EXTRACT. Not sure if that was an
oversite and I should open an Issue for these? The CASE statement(s) I
didn't really expect to be available.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi Andrew,
very useful work. Please, let me tell something about CASE statements. I
made many trials with them and can confirm that CASE WHEN and CASE v1
WHEN don't work in query design, whilst CASEWHEN works for me. Here is
an SQL statement I'm using since a few months:
SELECT "TipoDoc", "NumDoc", CASEWHEN( "TipoDoc" = 'FAD', "Imp",
CASEWHEN( "TipoDoc" = 'PAI', "Imp", CASEWHEN( "TipoDoc" = 'PAE',
"FCIVA", CASEWHEN( "TipoDoc" = 'PGE', "FCIVA", 0 ) ) ) ) AS
"ImportoNetto", CASEWHEN( "TipoDoc" = 'PAE', "FCIVA", CASEWHEN(
"TipoDoc" = 'PAI', "Imp", 0 ) ) * "AliqPrev" / 100 AS "Previdenza",
CASEWHEN( "TipoDoc" = 'PAE', "FCIVA", CASEWHEN( "TipoDoc" = 'PAI',
"Imp", 0 ) ) * "AliqRitAcc" / 100 AS "Ritenuta" FROM "Cronologico"
"Cronologico"
I created this query in Query Desing.
Best regards,
Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
