Getting SQL Command not properly ended. Error.

rbuser

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

nicocizik

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.

rbuser

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

nicocizik

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.