Subject Re: [IBO] Re: Explicit join d oesn´t work with IB Query
Author Helen Borrie
At 02:02 AM 6/05/2011, you wrote:

> 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

1. Set KeyLinksAutodefine to False.

2. Set correct KeyLinks - include all fields that contribute to a unique row in the dataset.

3. If you want this dataset to be "updatable" (which by its nature, it is not) then set RequestLive to True AND do one of two things, either:

a) Set one table to be the KeyRelation. Observe that only one table can be subjected to update or delete operations by this means.

b) If you need to make the insert, update and delete methods operate on two or more of the tables, parameterised stored procedures will be required. Refer to the InsertSQL, EditSQL and DeleteSQL properties.

Helen