Re: oracle sql plus - modified table column - but modification not showing in odbc connection
Date: Tue, 24 Mar 2009 14:40:34 -0700 (PDT)
On Mar 24, 2:45 pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> On 24.03.2009 19:20, BookerT wrote:
> > 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.
> Probably the refresh button in Access.
> > This is all tied to a web app, where, I changed all of the web forms
> > to accept 10 characters.....
> You have tied MS Access into a web app which also uses Oracle? That
> sounds spooky.
> Your question sounds more suitable for a MS Access specific forum. Even
> there you should probably include the version of Access.
> Good luck!
Robert, the other basic thing that we missed, is I did not use the commit work; command and that seemed to make a difference as well. So it was not an Access problem, but a SQL issue, .. does that make sense? Received on Tue Mar 24 2009 - 16:40:34 CDT