Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    4

    Unanswered: Alter table syntax error

    I have spent hours trying to find what could cause this statement to work for one table and not another within the same database. Neither have constraints on the column. The column size is/was char(8) for both.

    ALTER TABLE table1
    MODIFY update_who CHAR(12);


    For one table it worked and for the other I get 201: A syntax error has occurred.

    I am guessing that there is something with the table it does not work on but I don't know what to look for and I can't find anything that explains this.

    I am hoping someone has an idea that can help.


    *** Never mind I just did it the old way. Thanks


    Thank you for any insight you can give.
    Last edited by skyleh; 04-07-12 at 20:25.

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abb, Brittany, France
    Posts
    381
    Provided Answers: 1
    Hi,

    run the statement from dbaccess, this way

    dbaccess
    choose database
    Query
    type your statement
    Run
    get the error
    choose the 'Use editor' option in the menu
    this will display your query in vi and will point with a ^^ sign under
    the place where the parser does not accept the syntax.
    this should help you understanding where exactly your problem is

    Eric

Posting Permissions

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