> Delphi 3 Pro, Win95, PO 7.3 using ODBC:

> I'm new to Oracle, and am obviously doing something wrong,
> but don't know quite what is wrong, but I can't edit data
> using a TQuery.

> I have set up a test alias to the sample database in Personal
> Oracle 7.  I can set up a form with a Table, Query, Datasource,
> and DBGrid.  I can edit the EMP table if I connect up the TTable,
> and I can view the data with the TQuery if I set RequestLive = False.
> If I set RequestLive = True, the data will not show-- I either get an
> error "Table or view doesn't exist" or something like "Cannot perform
> this operation".  I also tried leaving RequestLive = False and using
> an UpdateSQL, but when I try applying the updates I get the second
> error.

> Please provide suggestions.  I've used queries with local databases and
> other ODBC data sources, but haven't come across this type of problem
> before.

> Thanks,  Brian

> Hello!!

> This might help you!! there is a genuine problem with the Oracle driver
> faced by many of them if you have to use RequestLive = True then in the
> SQL your table name and column names have to be in capitals else it will
> keep on giving you 'Table or view does not exists..' so if you give it
> in capitals it works for RequestLive queries.

> If you want to avoid it then you have to use cached updates!!

> I hope it helps you!

> Bye
> Ritesh

> Brian Feifarek wrote:

> > Delphi 3 Pro, Win95, PO 7.3 using ODBC:

> > I'm new to Oracle, and am obviously doing something wrong,
> > but don't know quite what is wrong, but I can't edit data
> > using a TQuery.

> > I have set up a test alias to the sample database in Personal
> > Oracle 7.  I can set up a form with a Table, Query, Datasource,
> > and DBGrid.  I can edit the EMP table if I connect up the TTable,
> > and I can view the data with the TQuery if I set RequestLive = False.
> > If I set RequestLive = True, the data will not show-- I either get an
> > error "Table or view doesn't exist" or something like "Cannot perform
> > this operation".  I also tried leaving RequestLive = False and using
> > an UpdateSQL, but when I try applying the updates I get the second
> > error.

> > Please provide suggestions.  I've used queries with local databases and
> > other ODBC data sources, but haven't come across this type of problem
> > before.

> > Thanks,  Brian