Results 1 to 5 of 5

Thread: insert failure

  1. #1
    Join Date
    Apr 2004
    Posts
    10

    Unanswered: insert failure

    we got the following problem:
    during the execution of an applicative, for ex: a modification .......

    an insert failure is produced, this insert failure is produced on one specific table, we have already increase the extent of this table but the problem still contineous.

    how can we determine the causes of this failure to insert on a table.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,
    Please test the ISAM error. What is the error.

    Gustavo.

  3. #3
    Join Date
    Apr 2004
    Posts
    10
    Gustavo, the engine doesn´t give any isam error
    it looks like if the application to insert is erased, but indeed it doesn´t erase
    the reality would be it is not inserted

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi Eduardob

    Please, can you send me the SQL insert.

    Gustavo

  5. #5
    Join Date
    Apr 2004
    Posts
    10
    let m_status = 0

    FOR m_ix = 1 to 54
    if ga_ddeterm[m_ix].coddet is null then
    continue for
    end if
    if ga_ddeterm_pe[m_ix].coddet is null then
    continue for
    end if

    let gr_detcer.codlab = gr_ccertifi.codlab
    let gr_detcer.numero = gr_ccertifi.numero
    let gr_detcer.anio = gr_ccertifi.anio
    let gr_detcer.coddel = gr_ccertifi.coddel
    let gr_detcer.deljurinsc = g_deljurinsc
    let gr_detcer.nrocer = gr_ccertifi.nrocer
    let gr_detcer.coddet = ga_ddeterm[m_ix].coddet
    let gr_detcer.valobt = ga_ddeterm[m_ix].valobt
    let gr_detcer.feccer = g_fechahora
    let gr_detcer.senabm = g_senabm
    let gr_detcer.fecgra = g_fecha
    let gr_detcer.usrnom = g_usrnom
    let gr_detcer.senenv = " "
    let gr_detcer.orden = m_ix

    SET LOCK MODE TO WAIT
    insert into lb_detcer
    values (gr_detcer.*)

    if status != 0 then
    let m_status = status
    exit for
    go to f_tratam_galta01_analisis
    end if
    END FOR

    Gustavo here I send you the SQL insert, it´s a common sentence

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •