can you provide a self contained repro for this. At least telling what
the current ddl of the table may be interesting.
This would let us know if it is a runtime multi-user ddl issue, or
something else. Do all of your alter tables fail or just this one?
Does this one fail all the time or just some time?
BALDWIN, ALAN J [AG-Contractor/1000] wrote:
Hello all,
When I execute the following SQL statement:
ALTER TABLE OrderDetail
ADD COLUMN blah
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.
---------------------------------------------------------------------------------------------------------
