New Blog Post: RESTful Reporting

Getting SQL Command not properly ended. Error.

edited September 2011 in DADE
I have two queries, one is manual that gets a Key violation error when run
with the other query, but not when run alone.
These are connecting to an Oracle DB. The manual query has a NOT IN clause,
is this the problem?
Using RB 12.5.



  • edited September 2011

    Are you using Parameterized linking or Manual linking? Generally a Key
    Violation Error occurs when trying to update a table. Are you trying to
    alter a table from DADE?

    Try control clicking over the detail dataset and see the resulting
    generated SQL and check it for errors.

    Best Regards,

    Nico Cizik
    Digital Metaphors
  • edited September 2011
    Thanks for the reponse.
    I think I'm doing the Manual linking, clicking on the link icon and
    matching the fields.
    Since the manual query that has the "NOT IN" clause I'm not able to view the
    Magic SQL.
    Neither of the queries are doing any updates, just reading from two
    different tables.
    Both queries work when not linked.

    Is there a way to do a "NOT IN" without reverting to the manual query?


  • edited September 2011
    Hi Dave,

    Using the Query Designer, you can set the search expression to "Not In
    List" in order to use the NOT IN command in your query.

    Best Regards,

    Nico Cizik
    Digital Metaphors
This discussion has been closed.