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

    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
    Pont l'Abbé, Brittany, France
    Provided Answers: 1

    run the statement from dbaccess, this way

    choose database
    type your statement
    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


Posting Permissions

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