Brigitte
16-Aug-2010, 11:33 AM
Hello,
I want to print a report with a Pervasice Database and ODBC. I habe two tables with two relations. One relation is between two number fields and the other is between two date fields.
If I run the report I get the error "...incompatible types in predicate". This is ok, because I can see a wrong command in the SQL.
SELECT "KDSRVLFS"."KDNR", "KDSRVLFS"."OBJEKT", "KDSRVLFS"."FOLGE", "KDSRVLFS"."MENGE1", "FORMULAR"."TOUR" FROM ("KDSRVLFS" "KDSRVLFS" INNER JOIN "FORMULAR" "FORMULAR" ON ("KDSRVLFS"."KDNR" = "FORMULAR"."KDNR") AND ("KDSRVLFS"."KDNR" = "FORMULAR"."EVT")) ORDER BY "KDSRVLFS"."KDNR"
The underlined field must should be "EVT" not "KDNR"
Is there any possibility to correct this SQL?
Brigitte
I want to print a report with a Pervasice Database and ODBC. I habe two tables with two relations. One relation is between two number fields and the other is between two date fields.
If I run the report I get the error "...incompatible types in predicate". This is ok, because I can see a wrong command in the SQL.
SELECT "KDSRVLFS"."KDNR", "KDSRVLFS"."OBJEKT", "KDSRVLFS"."FOLGE", "KDSRVLFS"."MENGE1", "FORMULAR"."TOUR" FROM ("KDSRVLFS" "KDSRVLFS" INNER JOIN "FORMULAR" "FORMULAR" ON ("KDSRVLFS"."KDNR" = "FORMULAR"."KDNR") AND ("KDSRVLFS"."KDNR" = "FORMULAR"."EVT")) ORDER BY "KDSRVLFS"."KDNR"
The underlined field must should be "EVT" not "KDNR"
Is there any possibility to correct this SQL?
Brigitte