Board index » delphi » Experiencing a BDE ERROR, Capability not supported

Experiencing a BDE ERROR, Capability not supported

This is happening with a Delphi 4 application:

On a Post of a query I receive a EDBEngineError:  'Capability not
supported'.
I am running an Oracle 8 database, Oracle 8 client, and I am running BDE

5.01 with Oracle 8 drivers (DLL32:  SQLORA8.DLL and VENDOR INIT:
OCI.DLL).

Has anyone experienced this? What is going on?

I need help with this, PLEASE.

 

Re:Experiencing a BDE ERROR, Capability not supported


Quote
> This is happening with a Delphi 4 application:

> On a Post of a query I receive a EDBEngineError:  'Capability not
> supported'.
> I am running an Oracle 8 database, Oracle 8 client, and I am running BDE

> 5.01 with Oracle 8 drivers (DLL32:  SQLORA8.DLL and VENDOR INIT:
> OCI.DLL).

> Has anyone experienced this? What is going on?

> I need help with this, PLEASE.

Hello,

It usually means that you are doing something in your query that is not
Oracle compliant. If you could give us the actual query, I'm sure someone
would have an answer for you.

--
Guillaume

Re:Experiencing a BDE ERROR, Capability not supported


Quote
Guillaume Metayer wrote:

> > This is happening with a Delphi 4 application:

> > On a Post of a query I receive a EDBEngineError:  'Capability not
> > supported'.
> > I am running an Oracle 8 database, Oracle 8 client, and I am running BDE

> > 5.01 with Oracle 8 drivers (DLL32:  SQLORA8.DLL and VENDOR INIT:
> > OCI.DLL).

> > Has anyone experienced this? What is going on?

Have you set set "Request live" to true? If your query is not
updatable and you ask for a live set you may get this error message.

Re:Experiencing a BDE ERROR, Capability not supported


Usually, on TQuery components that you use to "post" data, the sql command
cannot have relationship with other tables. It only works if you have a
simple SQL command like :

SELECT *
FROM TABLE
WHERE KeyField = :KeyField

But I'm not sure. If you send us the SQL command it will be ease to say !

Walcir Augusto Wehrle
Simple Informatica Ltda.

Re:Experiencing a BDE ERROR, Capability not supported


The error comes when calling the Post method of a query as stated
previously.  Several of the fields are set to different values before
this is called.  I don't know if this helps any.

The query is the following:

SELECT LINE_ITEM.*
FROM "LINE_ITEM" LINE_ITEM
WHERE LINE_ITEM."ORDER_NBR" = :ORDERNBR
  AND
LINE_ITEM."LINE_ITEM_NBR" = :LINEITEM

Quote
Guillaume Metayer wrote:
> > This is happening with a Delphi 4 application:

> > On a Post of a query I receive a EDBEngineError:  'Capability not
> > supported'.
> > I am running an Oracle 8 database, Oracle 8 client, and I am running BDE

> > 5.01 with Oracle 8 drivers (DLL32:  SQLORA8.DLL and VENDOR INIT:
> > OCI.DLL).

> > Has anyone experienced this? What is going on?

> > I need help with this, PLEASE.

> Hello,

> It usually means that you are doing something in your query that is not
> Oracle compliant. If you could give us the actual query, I'm sure someone
> would have an answer for you.

> --
> Guillaume

Re:Experiencing a BDE ERROR, Capability not supported


The error comes when calling the Post method of a query as stated
previously.  Several of the fields are set to different values before
this is called.  I don't know if this helps any.

The query is the following:

SELECT LINE_ITEM.*
FROM "LINE_ITEM" LINE_ITEM
WHERE LINE_ITEM."ORDER_NBR" = :ORDERNBR
  AND
LINE_ITEM."LINE_ITEM_NBR" = :LINEITEM

Quote
Guillaume Metayer wrote:
> > This is happening with a Delphi 4 application:

> > On a Post of a query I receive a EDBEngineError:  'Capability not
> > supported'.
> > I am running an Oracle 8 database, Oracle 8 client, and I am running BDE

> > 5.01 with Oracle 8 drivers (DLL32:  SQLORA8.DLL and VENDOR INIT:
> > OCI.DLL).

> > Has anyone experienced this? What is going on?

> > I need help with this, PLEASE.

> Hello,

> It usually means that you are doing something in your query that is not
> Oracle compliant. If you could give us the actual query, I'm sure someone
> would have an answer for you.

> --
> Guillaume

Re:Experiencing a BDE ERROR, Capability not supported


Hi,

Quote
> The error comes when calling the Post method of a query as stated
> previously.  Several of the fields are set to different values before
> this is called.  I don't know if this helps any.

> The query is the following:

> SELECT LINE_ITEM.*
> FROM "LINE_ITEM" LINE_ITEM
> WHERE LINE_ITEM."ORDER_NBR" = :ORDERNBR
>   AND
> LINE_ITEM."LINE_ITEM_NBR" = :LINEITEM

Hmmm, first of all I think your query could be simplified a lot. From my point
of view, this could look like:

select *
from line_item
where order_nbr = :OrderNBR
and line_item_nbr = :LineItem

Which would make it 10 nanoseconds faster <g>. About "capability not supported",
well, did you set the 'RequestLive' property to 'True' as someone previously
stated?

--
Guillaume

Re:Experiencing a BDE ERROR, Capability not supported


We have tried setting RequestLive to True and had no success.  We tried it and it
did not change anything for us.  It appears to have no bearing in our situation.
Could be wrong though.

More Info:
On an Insert of a record, POST performs succesfully.  If we go back and try to
update that same record, POST gives this 'Capability not Supported' error.

Is there any way to view what SQL command is being on a POST?

PS  If there is any specific information that would help, please let me know.

Thanks,Steve
---------

Quote
Guillaume Metayer wrote:
> Hi,

> > The error comes when calling the Post method of a query as stated
> > previously.  Several of the fields are set to different values before
> > this is called.  I don't know if this helps any.

> > The query is the following:

> > SELECT LINE_ITEM.*
> > FROM "LINE_ITEM" LINE_ITEM
> > WHERE LINE_ITEM."ORDER_NBR" = :ORDERNBR
> >   AND
> > LINE_ITEM."LINE_ITEM_NBR" = :LINEITEM

> Hmmm, first of all I think your query could be simplified a lot. From my point
> of view, this could look like:

> select *
> from line_item
> where order_nbr = :OrderNBR
> and line_item_nbr = :LineItem

> Which would make it 10 nanoseconds faster <g>. About "capability not supported",
> well, did you set the 'RequestLive' property to 'True' as someone previously
> stated?

> --
> Guillaume

Re:Experiencing a BDE ERROR, Capability not supported


What Version of oracle8?

I used to get errors like this one with pre 8.04 Oracle

Quote
Steve Milinovich wrote in message <374BE7E2.B9B0F...@marada-corp.com>...
>This is happening with a Delphi 4 application:

>On a Post of a query I receive a EDBEngineError:  'Capability not
>supported'.
>I am running an Oracle 8 database, Oracle 8 client, and I am running BDE

>5.01 with Oracle 8 drivers (DLL32:  SQLORA8.DLL and VENDOR INIT:
>OCI.DLL).

>Has anyone experienced this? What is going on?

>I need help with this, PLEASE.

Re:Experiencing a BDE ERROR, Capability not supported


We are running version 8.0.4.0.0
Quote
Mike Evans wrote:
> What Version of oracle8?

> I used to get errors like this one with pre 8.04 Oracle

> Steve Milinovich wrote in message <374BE7E2.B9B0F...@marada-corp.com>...
> >This is happening with a Delphi 4 application:

> >On a Post of a query I receive a EDBEngineError:  'Capability not
> >supported'.
> >I am running an Oracle 8 database, Oracle 8 client, and I am running BDE

> >5.01 with Oracle 8 drivers (DLL32:  SQLORA8.DLL and VENDOR INIT:
> >OCI.DLL).

> >Has anyone experienced this? What is going on?

> >I need help with this, PLEASE.

Re:Experiencing a BDE ERROR, Capability not supported


What does the SQLMONITOR show?
Quote
Steve Milinovich wrote in message <3755931C.1AA2E...@marada-corp.com>...
>We are running version 8.0.4.0.0

Re:Experiencing a BDE ERROR, Capability not supported


From what I can tell, the BDE is trying to deal with the update (from
SQLMONITOR)  below:  Using Oracle 7.3 BDE drivers this update was
successfully processed; there were no errors.  When I am using Oracle 8 BDE
drivers, the update below does not show up in SQLMONITOR. I am assuming that
this is the same statement that is trying to be processed.   It appears to
me that this update statement gets to the BDE and the BDE does not like it.
Does this help at all?

SQL Execute: ORACLE - UPDATE "ORDERS" SET "UPDATE_DATE"=:1 WHERE
"ORDER_NBR"=:2 AND "CUSTOMER_NBR"=:3 AND "ORIG_ORDER_NBR" IS NULL  AND
"ACCESS_DATE"=:4 AND "ADMIN_LATE_CHARGE"=:5 AND "ACTIVATION_DATE" IS NULL
AND "BILL_CUSTOMER_NBR"=:6 AND "BILL_ADDRESS_1"=:7 AND "BILL_ADDRESS_2" IS
NULL  AND "BILL_ADDRESS_3" IS NULL  AND "BILL_CITY"=:8 AND "BILL_STATE"=:9
AND "BILL_COUNTRY"=:10 AND "BILL_ZIP"=:11 AND "BILL_ZIP_PLUS_4"=:12 AND
"CALL_RCVR"=:13 AND "CARRIER"=:14 AND "CARRIER_ACCOUNT_NBR" IS NULL  AND
"COMPLETED_DATE" IS NULL  AND "CUSTOMER_REFERENCE" IS NULL  AND
"DIGITAL_IND"=:15 AND "DISCOUNT"=:16 AND "DIVISION_RCVD_DATE"=:17 AND
"ENTRY_DATE"=:18 AND "EXPIRATION_DATE" IS NULL  AND "FISCAL_REVIEW_DATE" IS
NULL  AND "FISCAL_REVIEWER" IS NULL  AND "FOREIGN_SHIP_CHARGE"=:19 AND
"HANDLING_CHARGE"=:20 AND "INTEREST_CHARGE"=:21 AND "INTERNAL_REMARK_ID"=:22
AND "INVOICE_SHIP_DATE" IS NULL  AND "MAIL_CHARGE"=:23 AND "MARKETING_CODE"
IS NULL  AND "OLD_CARRIER_IND"=:24 AND "OLD_RUSH_IND"=:25 AND
"ORDER_STATUS"=:26 AND "ORDER_PRICE"=:27 AND "ORDER_TYPE"=:28 AND
"PACKING_SLIP_IND"=:29 AND "PENALTY_CHARGE"=:30 AND "PRICE_CATEgory" IS
NULL  AND "PROJECT"=:31 AND "RCVD_DATE"=:32 AND "REDO_IND"=:33 AND
"REMARK_ID"=:34 AND "REQUEST_ORIGIN"=:35 AND "RUSH_IND"=:36 AND
"RUSH_CHARGE"=:37 AND "SHIP_ADDRESS_1"=:38 AND "SHIP_ADDRESS_2" IS NULL  AND
"SHIP_ADDRESS_3" IS NULL  AND "SHIP_FOREIGN_IND"=:39 AND
"SHIP_FIRSTNAME"=:40 AND "SHIP_MIDDLE_INITIAL"=:41 AND "SHIP_LASTNAME"=:42
AND "SHIP_ORGANIZATION"=:43 AND "SHIP_CITY"=:44 AND "SHIP_STATE"=:45 AND
"SHIP_ZIP"=:46 AND "SHIP_ZIP_PLUS_4"=:47 AND "SHIP_COUNTRY"=:48 AND
"SHIP_EMAIL"=:49 AND "SHIP_FAX" IS NULL  AND "SHIP_PHONE" IS NULL  AND
"USER_OVERRIDE_IND"=:50 AND "WAIVER_CHARGE"=:51 AND "WORK_ORDER_DATE" IS
NULL  AND "WORK_ORDER_TIME" IS NULL  AND "UPDATE_DATE"=:52 AND "UPDATER"=:53
AND "ROWID"=:54

Quote
Mike Evans wrote:
> What does the SQLMONITOR show?

> Steve Milinovich wrote in message <3755931C.1AA2E...@marada-corp.com>...
> >We are running version 8.0.4.0.0

Re:Experiencing a BDE ERROR, Capability not supported


I don't know if any of this makes sense, but...

In the update statement in the last message, it is checking where ROWID = :54
Well, in SQLMONITOR the ROWID is set in the following line:

18:05:19  SQL Data In: ORACLE - Param = 54, Name = ROWID, Type = fldZSTRING,
Precision = 18, Scale = 0, Data = AAAB6+AAYAAACnOAAH

Look at the Data=AAAB6+AAYAAACnOAAH What is that?    I took the update(after I
did the INSERT), inserted the data values passed and ran that UPDATE command
from an application(TOAD) that runs SQL commands.  I did this to test outside of
the BDE.  The UPDATE FAILED. However, I took the ROWID=   off the end of the
update command and 1 row was UPDATED.

Quote
Steve Milinovich wrote:
> From what I can tell, the BDE is trying to deal with the update (from
> SQLMONITOR)  below:  Using Oracle 7.3 BDE drivers this update was
> successfully processed; there were no errors.  When I am using Oracle 8 BDE
> drivers, the update below does not show up in SQLMONITOR. I am assuming that
> this is the same statement that is trying to be processed.   It appears to
> me that this update statement gets to the BDE and the BDE does not like it.
> Does this help at all?

> SQL Execute: ORACLE - UPDATE "ORDERS" SET "UPDATE_DATE"=:1 WHERE
> "ORDER_NBR"=:2 AND "CUSTOMER_NBR"=:3 AND "ORIG_ORDER_NBR" IS NULL  AND
> "ACCESS_DATE"=:4 AND "ADMIN_LATE_CHARGE"=:5 AND "ACTIVATION_DATE" IS NULL
> AND "BILL_CUSTOMER_NBR"=:6 AND "BILL_ADDRESS_1"=:7 AND "BILL_ADDRESS_2" IS
> NULL  AND "BILL_ADDRESS_3" IS NULL  AND "BILL_CITY"=:8 AND "BILL_STATE"=:9
> AND "BILL_COUNTRY"=:10 AND "BILL_ZIP"=:11 AND "BILL_ZIP_PLUS_4"=:12 AND
> "CALL_RCVR"=:13 AND "CARRIER"=:14 AND "CARRIER_ACCOUNT_NBR" IS NULL  AND
> "COMPLETED_DATE" IS NULL  AND "CUSTOMER_REFERENCE" IS NULL  AND
> "DIGITAL_IND"=:15 AND "DISCOUNT"=:16 AND "DIVISION_RCVD_DATE"=:17 AND
> "ENTRY_DATE"=:18 AND "EXPIRATION_DATE" IS NULL  AND "FISCAL_REVIEW_DATE" IS
> NULL  AND "FISCAL_REVIEWER" IS NULL  AND "FOREIGN_SHIP_CHARGE"=:19 AND
> "HANDLING_CHARGE"=:20 AND "INTEREST_CHARGE"=:21 AND "INTERNAL_REMARK_ID"=:22
> AND "INVOICE_SHIP_DATE" IS NULL  AND "MAIL_CHARGE"=:23 AND "MARKETING_CODE"
> IS NULL  AND "OLD_CARRIER_IND"=:24 AND "OLD_RUSH_IND"=:25 AND
> "ORDER_STATUS"=:26 AND "ORDER_PRICE"=:27 AND "ORDER_TYPE"=:28 AND
> "PACKING_SLIP_IND"=:29 AND "PENALTY_CHARGE"=:30 AND "PRICE_CATEgory" IS
> NULL  AND "PROJECT"=:31 AND "RCVD_DATE"=:32 AND "REDO_IND"=:33 AND
> "REMARK_ID"=:34 AND "REQUEST_ORIGIN"=:35 AND "RUSH_IND"=:36 AND
> "RUSH_CHARGE"=:37 AND "SHIP_ADDRESS_1"=:38 AND "SHIP_ADDRESS_2" IS NULL  AND
> "SHIP_ADDRESS_3" IS NULL  AND "SHIP_FOREIGN_IND"=:39 AND
> "SHIP_FIRSTNAME"=:40 AND "SHIP_MIDDLE_INITIAL"=:41 AND "SHIP_LASTNAME"=:42
> AND "SHIP_ORGANIZATION"=:43 AND "SHIP_CITY"=:44 AND "SHIP_STATE"=:45 AND
> "SHIP_ZIP"=:46 AND "SHIP_ZIP_PLUS_4"=:47 AND "SHIP_COUNTRY"=:48 AND
> "SHIP_EMAIL"=:49 AND "SHIP_FAX" IS NULL  AND "SHIP_PHONE" IS NULL  AND
> "USER_OVERRIDE_IND"=:50 AND "WAIVER_CHARGE"=:51 AND "WORK_ORDER_DATE" IS
> NULL  AND "WORK_ORDER_TIME" IS NULL  AND "UPDATE_DATE"=:52 AND "UPDATER"=:53
> AND "ROWID"=:54

> Mike Evans wrote:

> > What does the SQLMONITOR show?

> > Steve Milinovich wrote in message <3755931C.1AA2E...@marada-corp.com>...
> > >We are running version 8.0.4.0.0

Other Threads