Board index » delphi » SQL error: Table does not support this operation because it is not uniquely indexed

SQL error: Table does not support this operation because it is not uniquely indexed

Do anyone know why the error occur when view one table and click the refresh
buttom:

Table does not support this operation because it is not uniquely indexed.
BDE Error: 10768 [$2A] [$10]

Using Oracle 806 client + BDE 5.1.1.1 + Updated SQLORA8.DLL (dated:
2000/06/16).
Delpha 4.0 + SQL Exlporer 4.0.

Using Oracle 8.1.6 server.

And what should I do?  build a index for that table?

Markco Wong
markco_w...@email.com

 

Re:SQL error: Table does not support this operation because it is not uniquely indexed


Quote
> Do anyone know why the error occur when view one table and click the
refresh
> buttom:

> Table does not support this operation because it is not uniquely
indexed.
> BDE Error: 10768 [$2A] [$10]
...

> Using Oracle 8.1.6 server.

> And what should I do?  build a index for that table?

Add a primary key to the table. In Delphi/BDE the TTable/TQuery.Refresh
means that the current record in dataset is refreshed. To do so, BDE
needs to know how to find and retrive that record from database. And
that means that the primary key is needed...

Gert

Other Threads