Hi All,

I am getting the following error when trying to update a dataset using EWB and EDB.

"Database response error (Cannot find the row in the RNDataset dataset, a primary/unique key is not defined in the underlying table)"

I can't seem to work out how to check if a primary key is on the field that I am searching for?

Any pointers appreciated.

Thanks

Richard

Richard Mace wrote:

> I can't seem to work out how to check if a primary key is on the field that I am searching for?

I think you just have to have a primary key, not be searching on it. If you open the table in EDBManager, the constraints has "Primary Key" and shows the field if you click on it. It is in the Constraints tab of Alter table too.

Not sure how that fits into the specific problem though, sorry.

--

Matthew Jones

"Matthew Jones" wrote:

<< I think you just have to have a primary key, not be searching on it. If you open the table in EDBManager, the constraints has "Primary Key" and shows the field if you click on it. It is in the Constraints tab of Alter table too.

Not sure how that fits into the specific problem though, sorry.>>

That sorted it!

Thanks Matthew, much appreciated.

Richard