Subject RE: [IBO] Explicit join doesn´t work with IB_Query
Author Support List
> I made this code on my ib_iquery
>
> SELECT PK_PROC
> , FG_CATEGORIA
> , CATEGORIAS.DESCRICAO AS CAT_DESC
> , CODIGO
> , PROCEDIMENTOS.DESCRICAO
> , PROCEDIMENTOS.LOG_OPERADOR_I
> , PROCEDIMENTOS.LOG_OPERADOR_E
> , PROCEDIMENTOS.DATA_INC
> , PROCEDIMENTOS.DATA_ALT
> , CARENCIA
> , PERIODICIDADE
> , RETORNO
> , UTILIZACAO
> , REMUNERACAO
> , CO_PARTICIP
> , BLOQUEADO
> , PROCEDIMENTOS.OBSERVACOES
> FROM PROCEDIMENTOS
> left join categorias on procedimentos.fg_categoria =
> categorias.pk_categoria
>
> there is a ib_grid with in the project, when a edit and change the
> information on interface (ib_edit), after post the information came to old
> value, i need execute a refresh method from ib_query to see the new
> values... i active the buffersync bsAfterEdit and bsAftherInsernt....
>
> ***** big detail---> i don´t have this problem if a change the code to
> implicit join (see above)
>
> does anybody here has the same problem???

I have not seen this before. It looks like it could be a bug.

Will you please save me some time and make me a simple sample app that
demonstrates this problem?

Thanks,
Jason LeRoy Wharton
www.ibobjects.com