Dan,

Thanks, for your help, I'm using something similar to work around, but I'd to know why this is happening, it is true that I' m a novice here, but it is the 1st time I'm facing this kind of problem with insert. Do you have any idea what is causing this behavior?

Again thanks,

As I told you, I find a way to work around, but it is a far cry from a clean solution, I will review my code paying a special attention to these points, thanks for the tips.

<cfif Parm1 eq "IncluirItem">

                <!--- Incluir Item --->

    <cfif NOT IsNumeric(Form.itQuantidade)>

                <cfset mensaErro = "Cantidade inválida">

    <cfelse>

                                <cfset wPN = Trim(Form.itPartNumber)>

        <cfquery name="qCkPN" datasource="#application.BancoDados#">

            SELECT LMItemId FROM ListamaterialItens WHERE ListaMaterialId = #wListaMaterialId# AND ItemId = '#wPN#'

        </cfquery>

        <cfif qCkPN.recordCount eq 0>

            <cfquery datasource="#Application.BancoDados#">

                INSERT INTO ListaMaterialItens(ListaMaterialId,ItemId,NumeroNoDesenho,Descricao,Q uantidade,KitBasico,Observacao)

                      VALUES('#wListaMaterialId#','#wPN#','#Form.itNumeroDesenho#','#Form.i tDescricao#',#Form.itQuantidade#,'#Form.itKitbasico#', '#Form.itObservacao#')

            </cfquery>

            <!--- Atualiza Tabela Lm x Obs --->

            <cfif Form.itObservacao neq "">

                                                                <!--- Incluir Observação --->

                <cfquery name="qCkId" datasource="#Application.BancoDados#">

                    SELECT Observacao FROM ListaMaterialObs

                    WHERE ListaMaterialId = #wListaMaterialId# AND (Observacao = '#Form.itObservacao#')

                </cfquery>

                <cfif qCkId.RecordCount eq 0>

                    <cfquery name="qInsObs" datasource="#Application.BancoDados#">

                        INSERT INTO ListaMaterialObs(ListaMaterialId,Observacao)

                            VALUES('#wListaMaterialId#','#Form.itObservacao#')

                    </cfquery>

                </cfif>

            </cfif>

        </cfif>

   </cfif>

</cfif>