Re: oracle sql plus - modified table column - but modification not showing in odbc connection
From: <sybrandb_at_hccnet.nl>
Date: Wed, 25 Mar 2009 06:35:09 +0100
Message-ID: <nggjs49galrkjbf5jsar7sllpic7paq4ov_at_4ax.com>
On Tue, 24 Mar 2009 14:40:34 -0700 (PDT), BookerT <chipw_at_mierbo.com> wrote:
Date: Wed, 25 Mar 2009 06:35:09 +0100
Message-ID: <nggjs49galrkjbf5jsar7sllpic7paq4ov_at_4ax.com>
On Tue, 24 Mar 2009 14:40:34 -0700 (PDT), BookerT <chipw_at_mierbo.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 DBAReceived on Wed Mar 25 2009 - 00:35:09 CDT