>I am attempting to use sqlexec to compare local lookup table records with remote Oracle records. I am attempting to use the sql subquery "not in" clause to compare the local and remote records and retrieve those that do not exist in the local lookup tables. When I issue the command:
>
>lmrecs=sqlexec(mdbc,'select * from insurer where insurer_primary_key not in (sele insurer_pr from insurer_lookup)','temp')
>
>none of the records in the table are retrieved even though they do not exist in the local table. I have even cut and paste a working "not in" local subquery and this still does not return any records. Any suggestions?

The SQLEXEC() command is basically a string you pass to the back-end, which it then executes for you, and returns the result. The point is, the back-end knows nothing about your local table; it can't access it. Unless the Oracle DB has a table or view named "insurer_lookup", the command will fail. If the table/view DOES exist, it's likely not the same as your local one, so the results you would get would not be what you'd expect.

A simple but inelegant workaround would be to select all of the primary keys from the back-end to a local cursor, then run your SELECT locally with the two local cursors.