Hello,
I am using Firebird-1.5.2.4731, IBO4_5_B and Delphi 7.
I need to obtain an updatable recordset from 2 tables, I've tried 2
options, but I couldn't get it.

1) First option: I get this error message = Column unknowm DOC_LOTE
SELECT O.DIO_DOCNUM,O.DIO_VALOR,
(SELECT D.DOC_LOTE FROM DOCUMENTO D WHERE D.DOC_NUM = O.DIO_DOCNUM)
AS DOC_LOTE
FROM DIR_OBR O
WHERE O.DIO_DOCNUM > 0 AND DOC_LOTE IS NOT NULL

2) Second option: returns rows correctly, I show it on a TIB_Grid,
but it is not updatable (I don't known if it's not updatable due to
FireBird or IBO)
SELECT O.DIO_DOCNUM,O.DIO_VALOR,D.DOC_LOTE
FROM DIR_OBR O INNER JOIN DOCUMENTO D ON D.DOC_NUM = O.DIO_DOCNUM
WHERE O.DIO_DOCNUM > 0 AND D.DOC_LOTE IS NOT NULL

How can I do it? Thanks a lot.