A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
to run alter command in Access
Joined: Oct 01, 2001
Oct 01, 2001 01:16:00
I have been able to run the create and drop tables using the sql statements in Microsoft Access but the alter command to add columns is not working. Code is..
stmt.executeUpdate(" alter table tablename add (address VARCHAR(15) ,city VARCHAR(15) ");
Joined: Jul 09, 2001
Oct 01, 2001 10:51:00
what is the exception message/number?
I agree. Here's the link:
subject: to run alter command in Access
CVS How To
inserting a new column to an existing oracle table with a fixed value in all the rows of that column
upgrading to 2.1.6
Exceptions (4) in catalina.out
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015