oracle sql plus - modified table column - but modification notshowing in odbc connection

#11

On Mar 25, 1:35*am, sybra... (AT) hccnet (DOT) nl wrote:

Quote:

On Tue, 24 Mar 2009 14:40:34 -0700 (PDT), BookerT <ch... (AT) mierbo (DOT) com
wrote:

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?

It makes no sense at all, as every DDL is automatically committed.
You really need some knowledge brushing up.
As soon as you change any table in Oracle, you'll need to *reattach*
it in Access, or the changed definition will not show up.
So it IS an Access problem, and a problem with your lack of knowledge.

--
Sybrand Bakker
Senior Oracle DBA

Well Sybrand, that's why I posted the question, if I had the
knowledge, I would not have posted the question

Thanks

#12

On Mar 25, 1:35*am, sybra... (AT) hccnet (DOT) nl wrote:

Quote:

On Tue, 24 Mar 2009 14:40:34 -0700 (PDT), BookerT <ch... (AT) mierbo (DOT) com
wrote:

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?

It makes no sense at all, as every DDL is automatically committed.
You really need some knowledge brushing up.
As soon as you change any table in Oracle, you'll need to *reattach*
it in Access, or the changed definition will not show up.
So it IS an Access problem, and a problem with your lack of knowledge.

--
Sybrand Bakker
Senior Oracle DBA

Also, the data did not change until I used the commit work command as
well, so go figure, and that was the data, not the meta data that did
not refresh.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

oracle sql plus - modified table column - but modification notshowing in odbc connection

comp.databases.oracle.misc comp.databases.oracle.misc

Re: oracle sql plus - modified table column - but modification notshowing in odbc connection - 03-25-2009 , 07:24 AM

Re: oracle sql plus - modified table column - but modification notshowing in odbc connection - 03-25-2009 , 07:25 AM