I Try to insert in query with a Infopower Grid but when i change my record in the grid the change are cancel and he never goes in the after post Event here is my SQL
Select dr.RowID,
dr.NO_DOCUMENT_REFERENCE,
dr.NO_REVISION_DOC_REF,
dr.NO_PAGE,
dr.NO_TYPE_DOCUMENT_REFERENCE,
dr.IND_EMIS,
dr.DATE_EMISSION,
dr.IND_DISTRIBUE,
dr.DATE_DISTRIBUTION,
-- dr.NO_BM| | ' Pg: ' | | dr.NO_PAGE As NO_DOC,
e.NO_ELEMENT,
:IND_ACTIVE As IND_ACTIVE

From DOCUMENT_REFERENCE dr,
ELEMENT e,
ELEMENT_DESSIN ed,
TR_TYPE_DOCUMENT_REFERENCE tdr

Where 1 = :IND_ACTIVE
And e.NO_ELEMENT = :NO_ELEMENT
And e.IND_REVISION_COURANTE = 1
And ed.NO_ELEMENT = e.NO_ELEMENT
And ed.NO_REVISION_CONTRAT = e.NO_REVISION_ELEMENT
And dr.NO_DOCUMENT_REFERENCE = ed.NO_DOCUMENT_REFERENCE
And dr.IND_REVISION_COURANTE = 1
And dr.IND_EMIS = :IND_EMIS
And tdr.NO_TYPE_DOCUMENT_REFERENCE = dr.NO_TYPE_DOCUMENT_REFERENCE


The properties are : CachedUpdates : true
LockingMode : lockImmediate


------------------