Board index » delphi » Existing tables in BDE connection against Oracle.

Atle Smelv?r

Delphi Developer
Fri, 19 Dec 2003 21:02:18 GMT

Existing tables in BDE connection against Oracle.

I have a weird problem. When doing a "drop table" in Oracle, the "Exists"
function in TTable does not work. You get "true" from the function even
though it is dropped. This way it bypasses my logic, and my program comes up
with errors.

Is there some way to get BDE (TTable) to understand that the table does not
exist anymore?

-Atle

 
Robert Cern

Delphi Developer
Fri, 19 Dec 2003 23:05:18 GMT

Re:Existing tables in BDE connection against Oracle.


Yes, you have to reconnect. Or use TQuery instead of TTable.

Kevin reposts quite frequently a "TTable vs TQuery", IOW "why is it bad idea
to use TTable with SQL servers"

--
Robert

Quote
Atle Smelv?r wrote in message <3b406e95$1_1@dnews>...
>I have a weird problem. When doing a "drop table" in Oracle, the "Exists"
>function in TTable does not work. You get "true" from the function even
>though it is dropped. This way it bypasses my logic, and my program comes
up
>with errors.

>Is there some way to get BDE (TTable) to understand that the table does not
>exist anymore?

>-Atle

Other Threads

1. Bug on BDE 5.1.1/ Oracle SQL Links against Oracle 817

2. Improving BDE Performance against ORACLE

3. Improving BDE Performance against ORACLE

4. Invalid time when using BDE 5.2 against Oracle 8.1.7

5. BDE against Oracle = AV

6. BDE slow to open Ttable against Oracle DB

7. Problems using Oracle 8.1.7 against BDE 5.2

8. MSSQL against ORACLE with Delphi/BDE

9. Using native BDE and ODBC against Pdox tables

10. Using native BDE and ODBC against Pdox tables