Capability not Supported (Personal Oracle 8)

Jackson Gomes

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Capability not Supported (Personal Oracle 8)

Hi all:

Im trying to open a parameterized query in a Personal Oracle 8 database and
it returns the error "Capability not supported". The query has the
RequestLive property as True. Im using Delphi 3 and BDE 5.01.

Thanks

Jackson Gomes
Tools&Comps - Security Components for Delphi
Web Site: http://www.toolsandcomps.com
e-mail: jack...@toolsandcomps.com
Phone: 55 27 99602760

Les Piotrowsk

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Capability not Supported (Personal Oracle 8)

What does your SQL Statement look like?
Request Live cannot be used with SQL clauses like Group By...etc.

Quote

Jackson Gomes <i...@toolsandcomps.com> wrote in message

news:39770b82@dnews...

Quote

> Hi all:

> Im trying to open a parameterized query in a Personal Oracle 8 database
and
> it returns the error "Capability not supported". The query has the
> RequestLive property as True. Im using Delphi 3 and BDE 5.01.

> Thanks

> Jackson Gomes
> Tools&Comps - Security Components for Delphi
> Web Site: http://www.toolsandcomps.com
> e-mail: jack...@toolsandcomps.com
> Phone: 55 27 99602760

Jackson Gome

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Capability not Supported (Personal Oracle 8)

Hi Les:

Quote

> What does your SQL Statement look like?
> Request Live cannot be used with SQL clauses like Group By...etc.

Yes, I know. The query looks like:

Select *
From Table
Where aField = :aParameter

The most interesting is that it works in all other databases I have tested
(Paradox, MS-Access, Interbase, MS-SQL Server...) but does not work with
Personal Oracle 8. Maybe a BDE bug?

Thanks

Jackson Gomes
Tools&Comps - Security Components for Delphi
Web Site: http://www.toolsandcomps.com
e-mail: jack...@toolsandcomps.com
Phone: 55 27 99602760

Quote

> Jackson Gomes <i...@toolsandcomps.com> wrote in message
> news:39770b82@dnews...
> > Hi all:

> > Im trying to open a parameterized query in a Personal Oracle 8 database
> and
> > it returns the error "Capability not supported". The query has the
> > RequestLive property as True. Im using Delphi 3 and BDE 5.01.

> > Thanks

> > Jackson Gomes
> > Tools&Comps - Security Components for Delphi
> > Web Site: http://www.toolsandcomps.com
> > e-mail: jack...@toolsandcomps.com
> > Phone: 55 27 99602760

Les Piotrowsk

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Capability not Supported (Personal Oracle 8)

I beleive that the :aParameter must show in Capitals
Where aField = :aParameter

Quote

Jackson Gomes <i...@toolsandcomps.com> wrote in message

news:3978383e@dnews...

Quote

> Hi Les:

> > What does your SQL Statement look like?
> > Request Live cannot be used with SQL clauses like Group By...etc.

> Yes, I know. The query looks like:

> Select *
> From Table
> Where aField = :aParameter

> The most interesting is that it works in all other databases I have tested
> (Paradox, MS-Access, Interbase, MS-SQL Server...) but does not work with
> Personal Oracle 8. Maybe a BDE bug?

> Thanks

> Jackson Gomes
> Tools&Comps - Security Components for Delphi
> Web Site: http://www.toolsandcomps.com
> e-mail: jack...@toolsandcomps.com
> Phone: 55 27 99602760

> > Jackson Gomes <i...@toolsandcomps.com> wrote in message
> > news:39770b82@dnews...
> > > Hi all:

> > > Im trying to open a parameterized query in a Personal Oracle 8
database
> > and
> > > it returns the error "Capability not supported". The query has the
> > > RequestLive property as True. Im using Delphi 3 and BDE 5.01.

> > > Thanks

> > > Jackson Gomes
> > > Tools&Comps - Security Components for Delphi
> > > Web Site: http://www.toolsandcomps.com
> > > e-mail: jack...@toolsandcomps.com
> > > Phone: 55 27 99602760

Jackson Gome

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Capability not Supported (Personal Oracle 8)

Hi:

Quote

> I beleive that the :aParameter must show in Capitals
> Where aField = :aParameter

They are. Is this a BDE problem(BDE version 5.01)?

Quote

> Jackson Gomes <i...@toolsandcomps.com> wrote in message
> news:3978383e@dnews...
> > Hi Les:

> > > What does your SQL Statement look like?
> > > Request Live cannot be used with SQL clauses like Group By...etc.

> > Yes, I know. The query looks like:

> > Select *
> > From Table
> > Where aField = :aParameter

> > The most interesting is that it works in all other databases I have
tested
> > (Paradox, MS-Access, Interbase, MS-SQL Server...) but does not work with
> > Personal Oracle 8. Maybe a BDE bug?

> > Thanks

> > Jackson Gomes
> > Tools&Comps - Security Components for Delphi
> > Web Site: http://www.toolsandcomps.com
> > e-mail: jack...@toolsandcomps.com
> > Phone: 55 27 99602760

> > > Jackson Gomes <i...@toolsandcomps.com> wrote in message
> > > news:39770b82@dnews...
> > > > Hi all:

> > > > Im trying to open a parameterized query in a Personal Oracle 8
> database
> > > and
> > > > it returns the error "Capability not supported". The query has the
> > > > RequestLive property as True. Im using Delphi 3 and BDE 5.01.

> > > > Thanks

> > > > Jackson Gomes
> > > > Tools&Comps - Security Components for Delphi
> > > > Web Site: http://www.toolsandcomps.com
> > > > e-mail: jack...@toolsandcomps.com
> > > > Phone: 55 27 99602760

Other Threads

1. Capability Not Supported, Delphi 4, Oracle 8

2. Capability Not Supported error with Oracle 8i...

3. BDE/Oracle 8/Capability not supported

4. Oracle: Capability not supported

5. Oracle TO_CHAR - capability not supported - convert numeric to char

6. Capability not support (delphi c/ss,BDE5.01,Personel ORacle 8.04

7. Capability not supported? (Oracle insert fails)

8. Oracle - Capability Not Supported Error

9. Capability Not supported.....why not?

10. Problem - Getting Capability not supported