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
NamCitAsked:
Who is Participating?
 
kretzschmarConnect With a Mentor Commented:
set the updatemethod (if available) to upWhereAll
0
 
marcoszorrillaCommented:
have You a primary key for this table. Perhaps this is the problem.
Best Regards
Marcos.
0
 
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
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
NamCitAuthor Commented:

Thanks. I use ADO
0
 
YodaMageCommented:
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
      SysUtils.Abort;



0
 
NamCitAuthor Commented:

Do you have any easy ways
0
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.

All Courses

From novice to tech pro — start learning today.