Re: oracle sql plus - modified table column - but modification not showing in odbc connection
From: BookerT <chipw_at_mierbo.com>
Date: Tue, 24 Mar 2009 14:40:34 -0700 (PDT)
Message-ID: <41db4fcb-3c87-49e8-a4df-bab3fba166d6_at_p11g2000yqe.googlegroups.com>
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
Date: Tue, 24 Mar 2009 14:40:34 -0700 (PDT)
Message-ID: <41db4fcb-3c87-49e8-a4df-bab3fba166d6_at_p11g2000yqe.googlegroups.com>
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
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