Board index » delphi » BDE/Oracle 8/Capability not supported

Ronald Ruijs

Delphi Developer
Sun, 01 Aug 2004 17:12:52 GMT

BDE/Oracle 8/Capability not supported

Hi,

I have an app, that updates a database via the bde (5.1). It works well with
Access, SQL Server, DB2, Oracle 7.3, but when I connect to Oracle 8, I get
an error messaget when tryin to update several tables using a transaction.
The code looks like:

TDatabase.StartTransaction;

Table1.Open; (contains 1 row)
Query1.Open;

Table1.Insert;
Query1.Insert;

Query1.Post;   ->  error 'Capability not supported'
Table1.Post;

TDatabase.Commit;

I downloaded the latest oracle 8 bde dll, no luck. Again, this code works
fine on several other dbms'ses and ms access.

Any ideas are welcome.

Best regards, Ronald

 
paudoming..

Delphi Developer
Sun, 01 Aug 2004 17:58:38 GMT

Re:BDE/Oracle 8/Capability not supported


Are you sure that the property query1.requestlive is set to true and have
an updateobject attach with the sqlstrings corrects?

Pau.

Nick Pavlin

Delphi Developer
Sat, 07 Aug 2004 08:09:17 GMT

Re:BDE/Oracle 8/Capability not supported


"Ronald Ruijs" <ru...@rvc-software.com> wrote in news:3c6a2d9a_2@dnews:

Quote
> Hi,

> I have an app, that updates a database via the bde (5.1). It works
> well with Access, SQL Server, DB2, Oracle 7.3, but when I connect to
> Oracle 8, I get an error messaget when tryin to update several tables
> using a transaction. The code looks like:

> TDatabase.StartTransaction;

> Table1.Open; (contains 1 row)
> Query1.Open;

> Table1.Insert;
> Query1.Insert;

> Query1.Post;   ->  error 'Capability not supported'
> Table1.Post;

> TDatabase.Commit;

> I downloaded the latest oracle 8 bde dll, no luck. Again, this code
> works fine on several other dbms'ses and ms access.

> Any ideas are welcome.

> Best regards, Ronald

This and other problems may be resolved by setting ROWSET SIZE = 0 in the
BDE native driver configuration.  Check out
http://www.borland.com/devsupport/bde/bdeupdate.html
"The Oracle 8 driver has a new feature where ROWSET SIZE is now
implemented the same as the Oracle 7 driver. See SQLLNK32.HLP for
information on what ROWSET SIZE does. However, ROWSET SIZE has caused
problems for some users. If you encounter a new problem with the BDE
5.1.1 Oracle 8 driver, set ROWSET SIZE to 0 to insure that ROWSET SIZE is
not the problem."

Other Threads

1. Capability Not Supported, Delphi 4, Oracle 8

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

3. Oracle: Capability not supported

4. Capability not Supported (Personal Oracle 8)

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. BDE: Capability not supported token: NESTED SELECT (when using Paradox files, works with Interbase)

10. BDE error, 'Capability not supported'