"Not Uniquely Indexed" error

Bruceh

Delphi Developer

Sat, 08 May 2004 02:06:27 GMT

"Not Uniquely Indexed" error

I have two TQuery's, both accessing the same database table, but
having different filters. I do some deletions with the first and then
with the 2nd TQuery, try to do a Refresh() to account for the
deleted records.

I am getting the error:
Table does not support this operation because it is not uniquely indexed.

I'm using Access97 and I have a "Long Integer" field that is
indexed, without duplicates. It is the only index in the table.

Why am I getting this error?

Thanks.

-bruceh-

Brian Bushay Team

Delphi Developer

Sat, 08 May 2004 08:31:32 GMT

Re:"Not Uniquely Indexed" error

Quote

>I am getting the error:
> Table does not support this operation because it is not uniquely indexed.
>I'm using Access97 and I have a "Long Integer" field that is
>indexed, without duplicates. It is the only index in the table.

Do you have the IndexFieldName set to this index?
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Team

Delphi Developer

Sat, 08 May 2004 09:12:46 GMT

Re:"Not Uniquely Indexed" error

Instead of calling Refresh close and reopen the query.

--
Bill
(TeamB cannot answer questions received via email)

Other Threads

1. "Index not found" error

2. Error "Index Does Not Exist"

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

4. "Index not currently active" or "Table is not indexed"...

5. The keys "-"/"+"/"*"

6. "Index not valid"

7. TOutline "Outline Index Not Found" Repair

8. "Index not Valid"

9. "Outline Index Not Found"

10. "Table does not support this operation because it is not uniquely indexed"...