Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (herse.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Alter Table ADD Column throws column number exception
Date: Thu, 29 Mar 2007 16:18:04 -0500
Message-ID: 
 <2526D42D65F597428BFF422D6AB79E9E0108FD32@NA1000EXM01.na.ds.monsanto.com>
In-Reply-To: <9f40b500703290908r74adad48v9d1e5b4817cebc7@mail.gmail.com>
Thread-Topic: Alter Table ADD Column throws column number exception
Importance: normal
Priority: normal
Thread-Index: AcdyHKCHE0bKcuAnTJCO5RRJ7gCX+QAKqgnw
From: "BALDWIN, ALAN J [AG-Contractor/1000]" <alan.j.baldwin@monsanto.com>
To: "Derby Discussion" <derby-user@db.apache.org>

Hello all,

When I execute the following SQL statement:
ALTER TABLE OrderDetail=20
ADD COLUMN blah=20
varchar(15)

I get this exception:

java.sql.SQLException: In a base table there was a mismatch between the
requested column number 16 and the maximum number of columns 20.


Does anyone have an idea how I can fix this, or at least find a
workaround?

Thanks,
-Alan-

-------------------------------------------------------------------------=
--------------------------------
This e-mail message may contain privileged and/or confidential =
information, and is intended to be received only by persons entitled to =
receive such information. If you have received this e-mail in error, =
please notify the sender immediately. Please delete it and all =
attachments from any servers, hard drives or any other media. Other use =
of this e-mail by you is strictly prohibited.


All e-mails and attachments sent and received are subject to monitoring, =
reading and archival by Monsanto. The recipient of this e-mail is solely =
responsible for checking for the presence of "Viruses" or other =
"Malware". Monsanto accepts no liability for any damage caused by any =
such code transmitted by or accompanying this e-mail or any attachment.
-------------------------------------------------------------------------=
--------------------------------