PDA

View Full Version : SQL Problems



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

Vincent Oorsprong
16-Aug-2010, 11:56 AM
Brigitte,

It is not possible to correct the SQL statement, we need to test this report and when duplicated it will be placed on the buglist.