<div>
have You a primary key for this table. Perhaps this is the problem.<br />
Best Regards<br />
Marcos.<br />

</div>


have You a primary key for this table. Perhaps this is the problem.
Best Regards
Marcos.


<div>
<br />
There is not any key or index field. <br />
<br />
I also get this errror when i modified data on SQL Enteprise Manager , when i &lt;open Table&gt;, &lt;return all rows&gt; , and change data in serveral records
</div>



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

<div>
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.<br />
<br />
if (DataSet.State in [dsEdit, dsInsert]) then<br />
&nbsp; &nbsp; &nbsp; SysUtils.Abort;<br />
<br />
<br />
<br />

</div>


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;





<div>
<div class="content wysiwyg-content">
<br />
<br />
Dear Advisor !<br />
<br />
I use D5 + SQL7<br />
<br />
When i change data in TDBGRID (with AutoEdit = True in DataSource and TADOTable), and after move pont to other record in TDBGRID<br />
<br />
The error :<br />
<br />
Project sample.exe raised exception class EOLEException with message : &quot;Key column information is insufficient or incorrect. Too many rows were effected by update&quot;<br />
<br />
But after deleting all data in SQL, and run application again. Inputing with no error<br />
<br />
It only occurs rarely<br />
<br />
How could i do for this problem<br />
<br />
Thanks for all
</div>
</div>




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

Automatic Posting in TDBGRID

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.