Norman,
Thanks. I did add all the necessary field objects and modified all the
select, insert, and update SQL. Apparently, this seems to be related to a
deadlock problem mentioned in a related post.
--
Jim Poe (jpoe_at_fulcrumit.com)
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA7307C52_at_lnewton.leeds.lfs.co.uk...
> Jim,
>
> this might help, but then again maybe not.
>
> I haven't used Delphi for some time, but I use C++ builder with the
> TNOCI8 components for direct Oracle 8 access and I have found that
> changes to the database do not always show up in the components.
>
> My fix for this is to make sure that all connections, queries etc are
> set to have active = false. Then on the query which is not showing the
> new fields, I double click to get the fields editor and select all
> fields, or add the new ones to the query.
>
> HTH.
>
>
> Regards,
> Norman.
>
> ------------------------------------------------------------------------
> -----
> Norman Dunbar EMail: Norman.Dunbar_at_LFS.co.uk
> Database/Unix administrator Phone: 0113 289 6265
> Fax: 0113 289 3146
> Lynx Financial Systems Ltd. URL: http://www.Lynx-FS.com
> ------------------------------------------------------------------------
> -----
>
>
Received on Mon Nov 05 2001 - 10:39:56 CST
