oracle sql plus - modified table column - but modification not showing in odbc connection
From: BookerT <chipw_at_mierbo.com>
Date: Tue, 24 Mar 2009 11:20:08 -0700 (PDT)
Message-ID: <3ebf8543-1fd9-4af0-95a6-77bd6e8c01b6_at_o36g2000yqh.googlegroups.com>
Inside of Oracle Sql *plus
i use the commands alter table tablename modify columname varchar2(10)
;
Date: Tue, 24 Mar 2009 11:20:08 -0700 (PDT)
Message-ID: <3ebf8543-1fd9-4af0-95a6-77bd6e8c01b6_at_o36g2000yqh.googlegroups.com>
Inside of Oracle Sql *plus
i use the commands alter table tablename modify columname varchar2(10)
;
to change the field size to 10
When I open up Access to view the linked table via an odbc connection, in the design view, it still shows the field as having a field size of 5.
What did I miss.
This is all tied to a web app, where, I changed all of the web forms to accept 10 characters..... Received on Tue Mar 24 2009 - 13:20:08 CDT