• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

Automatic Posting in TDBGRID

Dear Advisor !

I use D5 + SQL7

When i change data in TDBGRID (with AutoEdit = True in DataSource and TADOTable), and after move pont to other record in TDBGRID

The error :

Project sample.exe raised exception class EOLEException with message : "Key column information is insufficient or incorrect. Too many rows were effected by update"

But after deleting all data in SQL, and run application again. Inputing with no error

It only occurs rarely

How could i do for this problem

Thanks for all
1 Solution
have You a primary key for this table. Perhaps this is the problem.
Best Regards
NamCitAuthor Commented:

There is not any key or index field.

I also get this errror when i modified data on SQL Enteprise Manager , when i <open Table>, <return all rows> , and change data in serveral records
set the updatemethod (if available) to upWhereAll
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

NamCitAuthor Commented:

Thanks. I use ADO
On any dataset driving a data aware grid, I add the following line to the BeforeScroll event to handle unwanted posting on movement of pointer.

if (DataSet.State in [dsEdit, dsInsert]) then

NamCitAuthor Commented:

Do you have any easy ways
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now