Subject | Explicit join doesn´t work with IB_Query |
---|---|
Author | Carlos Daniel |
Post date | 2011-05-03T18:15:25Z |
Hi friends,
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???
Thanks for all
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???
Thanks for all