Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Automatic Posting in TDBGRID

Posted on 2002-07-14
6
Medium Priority
?
350 Views
Last Modified: 2010-04-04


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
0
Comment
Question by:NamCit
6 Comments
 
LVL 3

Expert Comment

by:marcoszorrilla
ID: 7153511
have You a primary key for this table. Perhaps this is the problem.
Best Regards
Marcos.
0
 

Author Comment

by:NamCit
ID: 7153530

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
 
LVL 27

Accepted Solution

by:
kretzschmar earned 60 total points
ID: 7153622
set the updatemethod (if available) to upWhereAll
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:NamCit
ID: 7153701

Thanks. I use ADO
0
 
LVL 4

Expert Comment

by:YodaMage
ID: 7154270
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
 

Author Comment

by:NamCit
ID: 7155918

Do you have any easy ways
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question