Delphi / Oracle NESTED SELECT

High!

A newby-question with Delphi 1.xx / Oracle 7:

1. I execute SQL with TQUERY (OPEN)
2. Its runnig with simple Statements, but problems with german Umlaute.
3. Then I use a SUBQUERY in the Where-Clause SELECT * FROM T WHERE T.A IN (SELECT B FROM X)
4. Error "NESTED SELECT-Statement" not allowed.

SQL-Passthrumode is set to NoAutocommit (tried also other modes).

Can anybody help me? Perhaps also with the "Uml=E4ute"?
(We use WE8ISO8859P1 in Oracle, but not WEUxxxxx, i think this should be
identical in Client and Server).

danke!

Hans-Juergen Schmitz
(Hospital for Heart Surgery, University of Regensburg)
Received on Tue Nov 05 1996 - 00:00:00 CST