Can't update join queries (ORACLE)

From: Ulysses Neto (lissinho_at_sysplan.com.br)
Date: 05/28/04 

Date: Fri, 28 May 2004 11:54:42 -0300

Hi, everyone !!

We are updating our application (Delphi 5 with ADO) to make it able to
connect Oracle databases. Today, it works ok with MS SQLServer and MS
Access.
We are having problems to update join queries. For example:
TADOQuery with this SQL text:

select gucodigo, gureferencia, clinome
from guia left join cliente on guia.clicodigo = cliente.clicodigo

It returns the records ok but when we alter "GuReferencia" field's content
and call "ADOQuery1.Post" it returns the following error:

Multiple-step operation generated errors. Check each status value.

Looking in ADOConnection Erros collection, it has only one error with the
same message as above.
With SQL Server and Access we don't have this problem. If we change the SQL
text to:

select gucodigo, gureferencia, clinome
from guia, cliente
where guia.clicodigo = cliente.clicodigo

it works fine, but we can't use this because it only returns records of the
table "guia" that has a value in "clicodigo" field with a respective record
in "cliente" table.

Thanks in advance for your attention.