Hi Set,


I fix my code, see above... there is not null values in my tables...

When i edit on the ib_edit i can see in the grid the correct value, but when a give "post" on ib_query, the value return to old value... i am looking for a sample with "explicit join" and IB_Query, but all sample from IBO are using "implicit join".

Carlos Daniel

SELECT proc.PK_PROC
, proc.FG_CATEGORIA
, cat.DESCRICAO AS CAT_DESC
, proc.CODIGO
, proc.DESCRICAO
, proc.LOG_OPERADOR_I
, proc.LOG_OPERADOR_E
, proc.DATA_INC
, proc.DATA_ALT
, proc.CARENCIA
, proc.PERIODICIDADE
, proc.RETORNO
, proc.UTILIZACAO
, proc.REMUNERACAO
, proc.CO_PARTICIP
, proc.BLOQUEADO
, proc.OBSERVACOES
FROM PROCEDIMENTOS proc
left join categorias cat
on proc.fg_categoria = cat.pk_categoria