locked
Please any body tell me what is wrong with this query? RRS feed

  • Question

  • User-1148373670 posted

    hi All,

    please identify that what is mistake in this query:

    string CountQuery = @"Select COUNT(DD_DICTATIONID) from as_dictationdtls
    INNER JOIN AS_PATIENTDTLSCOMMON on DD_TRANSCRIPTID = PC_TRANSCRIPTID
    where DD_OWNER = :GlobalID and DD_DICTATIONDATE >= :StartDate and DD_DICTATIONDATE <= :EndDate
    AND DD_DOCSTATUS >= 100)";
    Exception is::ORA-00933: SQL command not properly ended
    please solve my issue.
    thanks in advance
    Monday, September 26, 2011 2:28 AM

Answers

  • User904860486 posted
    AND DD_DOCSTATUS >= 100)

    I think you dont need ) at the end of the query as there is no corresponding (. So try removing this and run your query.
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 26, 2011 3:18 AM

All replies

  • User904860486 posted
    AND DD_DOCSTATUS >= 100)

    I think you dont need ) at the end of the query as there is no corresponding (. So try removing this and run your query.
    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 26, 2011 3:18 AM
  • User-1148373670 posted

    thanks buddy

    u r write.

    Monday, September 26, 2011 3:20 AM