Re: oracle sql plus - modified table column - but modification not
From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 24 Mar 2009 14:55:40 -0700
Message-ID: <49c956dc$1_at_news.victoria.tc.ca>
BookerT (chipw_at_mierbo.com) wrote:
: On Mar 24, 2:45=A0pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
: > On 24.03.2009 19:20, BookerT wrote:
: >
: > > Inside of Oracle Sql *plus
: > > =A0 i use the commands alter table tablename
: > > modify =A0columname 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 =A0as 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? =A0That
: > sounds spooky.
: >
: > Your question sounds more suitable for a MS Access specific forum. =A0Eve=
: n
: > there you should probably include the version of Access.
: >
: > Good luck!
: >
: > =A0 =A0 =A0 =A0 robert
Date: 24 Mar 2009 14:55:40 -0700
Message-ID: <49c956dc$1_at_news.victoria.tc.ca>
BookerT (chipw_at_mierbo.com) wrote:
: On Mar 24, 2:45=A0pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
: > On 24.03.2009 19:20, BookerT wrote:
: >
: > > Inside of Oracle Sql *plus
: > > =A0 i use the commands alter table tablename
: > > modify =A0columname 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 =A0as 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? =A0That
: > sounds spooky.
: >
: > Your question sounds more suitable for a MS Access specific forum. =A0Eve=
: n
: > there you should probably include the version of Access.
: >
: > Good luck!
: >
: > =A0 =A0 =A0 =A0 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?
>does that make sense?
No. If you use ALTER TABLE then it was automatically committed.
Access stores details about the linked table. The only issue is the correct/best way to force Access to update its local version of those details. Received on Tue Mar 24 2009 - 16:55:40 CDT