Re: PLS-00417: unable to resolve <string> as a column

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 5 Nov 2001 16:17:14 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7307C52@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:17:14 CST