Hello,
I'm doing experiments with OpenOffice.Org QIQ Edition and I found some
problems. Here is the first one:
The following query works:
SELECT "Cronologico"."TipoDoc", "Cronologico"."NumDoc",
"Onorari_Previdenza_e_Ritenuta"."ImportoNetto" +
"Onorari_Previdenza_e_Ritenuta"."Previdenza" AS "ImportoOperazione" FROM
"Onorari_Previdenza_e_Ritenuta" AS "Onorari_Previdenza_e_Ritenuta",
"Cronologico" AS "Cronologico" WHERE (
"Onorari_Previdenza_e_Ritenuta"."TipoDoc" = "Cronologico"."TipoDoc" AND
"Onorari_Previdenza_e_Ritenuta"."NumDoc" = "Cronologico"."NumDoc" )
"Cronologico" is a Table, "Onorari_Previdenza_e_Ritenuta" is a query. As
you can see, there is a calculated field named "ImportoOperazione". The
problem is there. When I close the query or simply switch off/on the
Query Design View, the SQL expression changes automatically, as follows:
SELECT "Cronologico"."TipoDoc", "Cronologico"."NumDoc",
"Cronologico"."Onorari_Previdenza_e_Ritenuta"."ImportoNetto" +
"Onorari_Previdenza_e_Ritenuta"."Previdenza" AS "ImportoOperazione" FROM
"Onorari_Previdenza_e_Ritenuta" AS "Onorari_Previdenza_e_Ritenuta",
"Cronologico" AS "Cronologico" WHERE (
"Onorari_Previdenza_e_Ritenuta"."TipoDoc" = "Cronologico"."TipoDoc" AND
"Onorari_Previdenza_e_Ritenuta"."NumDoc" = "Cronologico"."NumDoc" )
In the first line,
"Cronologico"."Onorari_Previdenza_e_Ritenuta"."ImportoNetto" is clearly
wrong.
Am I doing something wrong with calculated field, or it's a bug?
Thanks in advance,
Franco
