Here is my Problem
I have this SQL :

SELECT 1 AS IND_INCLUS,
dld.QUANTITE,
dra.DESCRIPTION_FR,
badl.NO_BON_COMMANDE_AUX AS NO_BON_COMMANDE,
badl.NO_DETAIL_BON_COMMANDE_AUX AS NO_DETAIL_BON_COMMANDE,
badl.NO_BON_COMMANDE AS NO_BON_COMMANDE_PARENT,
badl.NO_DETAIL_BON_COMMANDE AS NO_DETAIL_BON_COMMANDE_PARENT,
badl.DATE_PREVUE AS DATE_PREVUE_PARENT,
badl.RowID
FROM BON_AUX_DATE_LIVRAISON badl,
DETAIL_BON_COMMANDE dbc,
DATE_LIVRAISON_DBC dld,
DETAIL_REQUETE_ACHAT_BON_COMM drabc,
DETAIL_REQUETE_ACHAT dra
WHERE badl.NO_BON_COMMANDE_AUX = :NO_BON_COMMANDE
AND badl.NO_BON_COMMANDE = dbc.NO_BON_COMMANDE
AND badl.NO_DETAIL_BON_COMMANDE = dbc.NO_DETAIL_BON_COMMANDE
AND badl.NO_BON_COMMANDE = dld.NO_BON_COMMANDE
AND badl.NO_DETAIL_BON_COMMANDE = dld.NO_DETAIL_BON_COMMANDE
AND badl.DATE_PREVUE = dld.DATE_PREVUE
AND badl.NO_BON_COMMANDE = drabc.NO_BON_COMMANDE
AND badl.NO_DETAIL_BON_COMMANDE = drabc.NO_DETAIL_BON_COMMANDE
AND drabc.NO_REQUETE_ACHAT = dra.NO_REQUETE_ACHAT
AND drabc.NO_DETAIL_REQUETE_ACHAT = dra.NO_DETAIL_REQUETE_ACHAT

UNION ALL

SELECT 0 AS IND_INCLUS,
dld.QUANTITE,
dra.DESCRIPTION_FR,
bc.NO_BON_COMMANDE AS NO_BON_COMMANDE,
1 AS NO_DETAIL_BON_COMMANDE,
dld.NO_BON_COMMANDE AS NO_BON_COMMANDE_PARENT,
dld.NO_DETAIL_BON_COMMANDE AS NO_DETAIL_BON_COMMANDE_PARENT,
dld.DATE_PREVUE AS DATE_PREVUE_PARENT,
badl.RowID
FROM BON_COMMANDE bc,
DATE_LIVRAISON_DBC dld,
DETAIL_REQUETE_ACHAT_BON_COMM drabc,
DETAIL_REQUETE_ACHAT dra,
BON_AUX_DATE_LIVRAISON badl
WHERE bc.NO_BON_COMMANDE = :NO_BON_COMMANDE
AND dld.NO_BON_COMMANDE = bc.NO_BON_COMMANDE_PARENT
AND drabc.NO_BON_COMMANDE = dld.NO_BON_COMMANDE
AND drabc.NO_DETAIL_BON_COMMANDE = dld.NO_DETAIL_BON_COMMANDE
AND drabc.NO_REQUETE_ACHAT = dra.NO_REQUETE_ACHAT
AND drabc.NO_DETAIL_REQUETE_ACHAT = dra.NO_DETAIL_REQUETE_ACHAT
AND bc.NO_BON_COMMANDE = badl.NO_BON_COMMANDE (+)
AND NOT EXISTS ( SELECT 1
FROM BON_AUX_DATE_LIVRAISON badl
WHERE badl.NO_BON_COMMANDE = dld.NO_BON_COMMANDE
AND badl.NO_DETAIL_BON_COMMANDE = dld.NO_DETAIL_BON_COMMANDE
AND badl.DATE_PREVUE = dld.DATE_PREVUE )
ORDER BY IND_INCLUS DESC


Intergrated in a Grid where the field IND_INCLUS is a Check Box

When the preson check it it insert a record in the table BON_AUX_DATE_LIVRAISON

Actuali in my ApplyRecord I have this Code

If Sender.FieldByName('IND_INCLUS').NewValue = 1
Then
SetVariable ('IACTION','I')
Else
SetVariable ('IACTION','D');
But the newvalue is never change even if i click in the check box

------------------
david.lorenzo@cognicase.ca