Ora 920-fejl
Jeg får pludselig ud af det blå en ora 920-fejlDet er en fejl der siger at mine operatorer skulle være forkert.
Det er i linien her at fejlen kommer (første linie i min where-clause):
WHERE (((PROBSUMMARYM1.PROBLEM_STATUS) Not Like "Closed")
Enkeltøjne og at putte %-tegn i, er prøvet.
Her er koden:
SELECT PROBSUMMARYM1.NUMBERPRGN,
PROBSUMMARYM1.PROBLEM_STATUS AS Status,
PROBSUMMARYM1.PRIORITY_CODE AS Priority,
PROBSUMMARYM1.DOWNTIME_START AS Opened,
PROBSUMMARYM1.BRIEF_DESCRIPTION AS Title,
PROBSUMMARYM1.CONTACT_NAME AS Name,
PROBSUMMARYM1.LOGICAL_NAME,
PROBSUMMARYM1.ASSIGNMENT,
PROBSUMMARYM1.OPEN_TIME AS Opened2
FROM PROBSUMMARYM1
WHERE (((PROBSUMMARYM1.PROBLEM_STATUS) Not Like "Closed")
AND ((PROBSUMMARYM1.DOWNTIME_START)<Date()-12)
AND ((PROBSUMMARYM1.ASSIGNMENT)="AC FLOWALARM")
AND ((PROBSUMMARYM1.OPEN_TIME)>Date()-31))
OR (((PROBSUMMARYM1.PROBLEM_STATUS) Not Like "Closed")
AND ((PROBSUMMARYM1.DOWNTIME_START)<Date()-12)
AND ((PROBSUMMARYM1.LOGICAL_NAME)="TOPAS"))
OR (((PROBSUMMARYM1.PROBLEM_STATUS) Not Like "Closed")
AND ((PROBSUMMARYM1.DOWNTIME_START)<Date()-12)
AND ((PROBSUMMARYM1.LOGICAL_NAME)="CUBUS"))
OR (((PROBSUMMARYM1.PROBLEM_STATUS) Not Like "Closed")
AND ((PROBSUMMARYM1.DOWNTIME_START)<Date()-12)
AND ((PROBSUMMARYM1.LOGICAL_NAME)="SOL"))
OR (((PROBSUMMARYM1.PROBLEM_STATUS) Not Like "Closed")
AND ((PROBSUMMARYM1.DOWNTIME_START)<Date()-12)
AND ((PROBSUMMARYM1.LOGICAL_NAME)="SCM"))
ORDER BY PROBSUMMARYM1.DOWNTIME_START DESC , PROBSUMMARYM1.OPEN_TIME DESC;