non uniquely index when refreshing query

[john230873]

I have a query that I use to read and write data to a table. When I press refresh I get the error message " Table does not support this operation beacuas it is not uniquely indexed"
There is an index on the table at the database level.

Database is SQL Server2000
Components are BDE

 

[DaZZleD]

you need to have an index defined on the table to do refresh. otherwise simply use 'select * from table_name'

--------------------------
"two wrongs don't make a right, but three lefts do" - the unknown sage

 

[john230873]

TTables work fine it a TQuery that doesn't work.