Results 1 to 3 of 3

Thread: error insert

  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Unanswered: error insert

    hi,

    I have an aplication development informix-4GL version 720 an the engine is informix-SE 7.24 where to do the follogind statement.

    let inserta = "insert into tabla values (?,?,?,?)
    prepare pp from inserta


    execute pp using x1,x2,x3,x4
    When I execute this statement the program show me the followind erorr

    -710 Table <table-name> has been dropped, altered or renamed.

    If anybody can help me with this problem thank you very much.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,

    When a user has open a table and another user alters this table, when wanting to accede, the first user to the table, gives east error.
    Please run update statistics after alter table.
    Or can be a bug.

    Gustavo.

  3. #3
    Join Date
    Jul 2003
    Location
    Beijing China
    Posts
    36
    database test
    main
    define i integer
    define str char(40)
    let str = "insert into tab1 values(?,?,?)"
    let str = str clipped
    prepare see from str
    for i = 1 to 100
    execute see using i,i,i
    end for
    end main

    Linux test 2.4.18-3 #1 Thu Apr 18 07:37:53 EDT 2002 i686 unknown
    IBM Informix Dynamic Server Version 9.40.UC2
    IBM INFORMIX-4GL Version 7.32.UC1
    IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC1


    suggestion:
    update statistics;
    upgrade informix product;
    MSN:jianghua1213@hotmail.com
    Beijing China
    http://www.91talk.net
    http://www.91talk.com

Posting Permissions

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