Thank you for replying. I've installed the latest build of dotConnect and now run into a different problem that previously worked fine, I'm adding my code so you can see what happens
Code: Select all
SELECT Project1.RUN_NUMBER,
Project1.ORDER_NO,
Project1.START_WEIGHT_STEEPING,
Project1.END_WEIGHT_STEEPED_DRIED,
Project1.STEEPING_REMARK,
Project1.END_WEIGHT,
Project1.SAMPLE_TO_LAB,
Project1.CREATION_DATE,
Project1.LAST_MODIFIED,
Project1.OPERATOR,
Project1.STEEPING_START,
Project1.STEEPING_END,
Project1.DRYING_START,
Project1.DRYING_END,
Project1.STEEPING_DEVICE_ID,
Project1.DRYING_STEEPED_DEVICE_ID,
Project1.DRYING_PRIMED_DEVICE_ID,
Project1.PRIMING_START,
Project1.PRIMING_END,
Project1.DRYING_REMARK,
Project1.PRIMING_REMARK,
Project1.PRIMING_START_WATER_ADDED,
Project1.C3 AS C1,
Project1.RUN_NUMBER1,
Project1.ORDER_NO1,
Project1.PRIMING_DEVICE_NR,
Project1.DEVICE_NAME,
Project1.CREATION_DATE1,
Project1.LAST_MODIFIED1,
Project1.OPERATOR1,
Project1.C2,
Project1.RUN_NUMBER2,
Project1.ORDER_NO2,
Project1.PRIMING_DEVICE_NR1,
Project1.PRIMING_REGISTRATION_NR,
Project1.START_WEIGHT,
Project1.SEED_TEMP,
Project1.SAMPLES_NR,
Project1.CREATION_DATE2,
Project1.LAST_MODIFIED2,
Project1.OPERATOR2,
Project1.C1 AS C3,
Project1.ORDER_NO3,
Project1.RUN_NUMBER3,
Project1.PRIMING_DEVICE_NR2,
Project1.PRIMING_REGISTRATION_NR1,
Project1.SAMPLE_SEQUENCE,
Project1.SAMPLE_VALID,
Project1.WET_WEIGHT,
Project1.DRY_WEIGHT,
Project1.CREATION_DATE3,
Project1.LAST_MODIFIED3,
Project1.OPERATOR3
FROM (SELECT Extent1.ORDER_NO,
Extent1.RUN_NUMBER,
Extent1.START_WEIGHT_STEEPING,
Extent1.END_WEIGHT_STEEPED_DRIED,
Extent1.STEEPING_REMARK,
Extent1.END_WEIGHT,
Extent1.SAMPLE_TO_LAB,
Extent1.CREATION_DATE,
Extent1.LAST_MODIFIED,
Extent1.OPERATOR,
Extent1.STEEPING_START,
Extent1.STEEPING_END,
Extent1.DRYING_START,
Extent1.DRYING_END,
Extent1.STEEPING_DEVICE_ID,
Extent1.DRYING_STEEPED_DEVICE_ID,
Extent1.DRYING_PRIMED_DEVICE_ID,
Extent1.PRIMING_START,
Extent1.PRIMING_END,
Extent1.DRYING_REMARK,
Extent1.PRIMING_REMARK,
Extent1.PRIMING_START_WATER_ADDED,
Join2.ORDER_NO AS ORDER_NO1,
Join2.RUN_NUMBER AS RUN_NUMBER1,
Join2.PRIMING_DEVICE_NR,
Join2.DEVICE_NAME,
Join2.CREATION_DATE AS CREATION_DATE1,
Join2.LAST_MODIFIED AS LAST_MODIFIED1,
Join2.OPERATOR AS OPERATOR1,
Join2.ORDER_NO1 AS ORDER_NO2,
Join2.RUN_NUMBER1 AS RUN_NUMBER2,
Join2.PRIMING_DEVICE_NR1 AS PRIMING_DEVICE_NR1,
Join2.PRIMING_REGISTRATION_NR,
Join2.START_WEIGHT,
Join2.SEED_TEMP,
Join2.SAMPLES_NR,
Join2.CREATION_DATE1 AS CREATION_DATE2,
Join2.LAST_MODIFIED1 AS LAST_MODIFIED2,
Join2.OPERATOR1 AS OPERATOR2,
Join2.ORDER_NO2 AS ORDER_NO3,
Join2.RUN_NUMBER2 AS RUN_NUMBER3,
Join2.PRIMING_DEVICE_NR2 AS PRIMING_DEVICE_NR2,
Join2.PRIMING_REGISTRATION_NR1 AS PRIMING_REGISTRATION_NR1,
Join2.SAMPLE_SEQUENCE,
Join2.SAMPLE_VALID,
Join2.WET_WEIGHT,
Join2.DRY_WEIGHT,
Join2.CREATION_DATE2 AS CREATION_DATE3,
Join2.LAST_MODIFIED2 AS LAST_MODIFIED3,
Join2.OPERATOR2 AS OPERATOR3,
CASE
WHEN Join2.ORDER_NO IS NULL THEN TO_NUMBER(NULL)
WHEN Join2.ORDER_NO1 IS NULL THEN TO_NUMBER(NULL)
WHEN Join2.RUN_NUMBER2 IS NULL THEN TO_NUMBER(NULL)
ELSE 1
END
AS C1,
CASE
WHEN Join2.ORDER_NO IS NULL THEN TO_NUMBER(NULL)
WHEN Join2.ORDER_NO1 IS NULL THEN TO_NUMBER(NULL)
ELSE 1
END
AS C2,
CASE
WHEN Join2.ORDER_NO IS NULL THEN TO_NUMBER(NULL)
ELSE 1
END
AS C3
FROM JIT.PRIMING_RUN Extent1
LEFT OUTER JOIN
(SELECT Extent2.ORDER_NO,
Extent2.RUN_NUMBER,
Extent2.PRIMING_DEVICE_NR,
Extent2.DEVICE_NAME,
Extent2.CREATION_DATE,
Extent2.LAST_MODIFIED,
Extent2.OPERATOR,
Join1.ORDER_NO1,
Join1.RUN_NUMBER1,
Join1.PRIMING_DEVICE_NR1,
Join1.PRIMING_REGISTRATION_NR,
Join1.START_WEIGHT,
Join1.SEED_TEMP,
Join1.SAMPLES_NR,
Join1.CREATION_DATE1,
Join1.LAST_MODIFIED1,
Join1.OPERATOR1,
Join1.ORDER_NO2,
Join1.RUN_NUMBER2,
Join1.PRIMING_DEVICE_NR2,
Join1.PRIMING_REGISTRATION_NR1,
Join1.SAMPLE_SEQUENCE,
Join1.SAMPLE_VALID,
Join1.WET_WEIGHT,
Join1.DRY_WEIGHT,
Join1.CREATION_DATE2,
Join1.LAST_MODIFIED2,
Join1.OPERATOR2
FROM JIT.PRIMING_DEVICE Extent2
LEFT OUTER JOIN
(SELECT Extent3.ORDER_NO,
Extent3.RUN_NUMBER,
Extent3.PRIMING_DEVICE_NR,
Extent3.PRIMING_REGISTRATION_NR,
Extent3.START_WEIGHT,
Extent3.SEED_TEMP,
Extent3.SAMPLES_NR,
Extent3.CREATION_DATE,
Extent3.LAST_MODIFIED,
Extent3.OPERATOR,
Extent4.ORDER_NO AS ORDER_NO2,
Extent4.RUN_NUMBER AS RUN_NUMBER2,
Extent4.PRIMING_DEVICE_NR
AS PRIMING_DEVICE_NR2,
Extent4.PRIMING_REGISTRATION_NR
AS PRIMING_REGISTRATION_NR1,
Extent4.SAMPLE_SEQUENCE,
Extent4.SAMPLE_VALID,
Extent4.WET_WEIGHT,
Extent4.DRY_WEIGHT,
Extent4.CREATION_DATE AS CREATION_DATE2,
Extent4.LAST_MODIFIED AS LAST_MODIFIED2,
Extent4.OPERATOR AS OPERATOR2
FROM JIT.PRIMING_REGISTRATION Extent3
LEFT OUTER JOIN
JIT.PRIMING_REGISTRATION_SAMPLE Extent4
ON (((Extent3.ORDER_NO =
Extent4.ORDER_NO)
AND (Extent3.RUN_NUMBER =
Extent4.RUN_NUMBER))
AND (Extent3.PRIMING_DEVICE_NR =
Extent4.PRIMING_DEVICE_NR))
AND (Extent3.PRIMING_REGISTRATION_NR =
Extent4.PRIMING_REGISTRATION_NR)) Join1
ON ((Extent2.ORDER_NO = Join1.ORDER_NO1)
AND (Extent2.RUN_NUMBER = Join1.RUN_NUMBER1))
AND (Extent2.PRIMING_DEVICE_NR =
Join1.PRIMING_DEVICE_NR1)) Join2
ON (Extent1.ORDER_NO = Join2.ORDER_NO)
AND (Extent1.RUN_NUMBER = Join2.RUN_NUMBER)
WHERE (Extent1.ORDER_NO = :p__linq__0)
AND (Extent1.RUN_NUMBER = :p__linq__1)) Project1
ORDER BY Project1.ORDER_NO ASC,
Project1.RUN_NUMBER ASC,
Project1.C3 ASC,
Project1.PRIMING_DEVICE_NR ASC,
Project1.ORDER_NO1 ASC,
Project1.RUN_NUMBER1 ASC,
Project1.C2 ASC,
Project1.PRIMING_REGISTRATION_NR ASC,
Project1.ORDER_NO2 ASC,
Project1.RUN_NUMBER2 ASC,
Project1.PRIMING_DEVICE_NR1 ASC,
Project1.C1 ASC;
In this query the field JOIN1.PRIMING_DEVICE_NR1 is queried but this field does not exist in the JOIN1 query so I'm getting the error: