Home DADE
New Blog Posts: Merging Reports - Part 1 and Part 2

Getting SQL Command not properly ended. Error.

edited September 2011 in DADE
Hi,
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.

Dave

Comments

  • edited September 2011
    Dave,

    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
    http://www.digital-metaphors.com
  • edited September 2011
    Nico,
    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?

    Dave


  • 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
    http://www.digital-metaphors.com
This discussion has been closed.