🚀 go-pugleaf

Mr. Bloomfield,

Thank you for your response. But I think the real problem is  BDE is not
registering  the Oracle tables. When I try to see the list of tables from
BDE Explorer, It does not show me the tables. For example, I have table
named Owner.System. And I can see list of tables Owner.S, Owner.Sy,
Owner.Sys, Owner.Syst, Owner.Syste, Owner.System, where there should only be
a table named Owner.System.  I can Query against the table using TQuery
object in the program or in Enter Sql window in BDE Explorer, but I can't
open the tables. When I double click on table name it says invalid table
name.

What do I need to do to see the Tables in BDE Explorer? Is there different
way to register database in BDE Explorer?  Is this known issue with Oracle?

Nirmal



Jerry Bloomfield (TeamB) <JersWork@wwa.com> wrote in message
news:de2fetg50gpgtbme882j9i2jlvvesjqhlt@4ax.com...
> On Fri, 20 Apr 2001 13:21:50 -0500, "Nirmal Shrestha"
<nirmals@flowcal.com>
> wrote:
>
> >It gives me an Oracle error, table does not exists. If I set
> >Query->RequestLive = false; it prepares the SQL statement and Opens the
> >table but do not lt me insert saying read only data set.
> >
> >It was working fine with MS Access database, and I am having problem
trying
> >to change it to access to Oracle database.
>
> There are problems with the Oracle ODBC drivers (and there are also
> problems with the Microsoft ODBC drivers for Oracle databases too).  Quite
> often,  you can resolve your problems with the Oracle drivers by making
> sure that you always use UPPERCASE in your SQL syntax,  especially when
> referring to field and table names.
>
> Jerry Bloomfield (TeamB)
> --
> http://www.teamb.com                                      JersWork@wwa.com
> Please do *NOT* send private e-mail without prior permission (my anti-spam
> filters will probably just delete it anyway <g>)