Data aware Grids?

Data aware Grids?

Post by David O'Lear » Sat, 24 Feb 1996 04:00:00

Are there any data aware grids that work?  Read and write?



1. data aware grid and table - record/key deleted

I have a TDBGrid, TDataSource and TTable on a form. I created a Paradox
table with DataBase Desktop. The table has three fields. I set field[0], a
numeric field,  to be a key field that I want to set from calculated data.
The key field is not displayed in the grid - I am just using it to keep the
data sorted in the grid. The key field is used in a TChart however, but that
is working fine.

I am making the change in the BeforePost event handler. I have also tried
the LeaveColum and other event handlers and they all work the same with the
same problem. I have tried setting the field data with the SetFields method
and by accessing the fields directly; they both have the same problem.

Everything works fine when I insert a new  record, but when I edit an
existing record I get a Record/Key Deleted error message. If I click OK on
the error message box the data posts OK and all is good. I just need to get
rid of the annoying error message.

If I remove the "key" attribute from field[0] the error does not occur. But
then the data displayed in the grid is not sorted after post. Is there a
Sort method for tables? I cannot find it. If there is a Sort method I could
forget the key field and sort the table afterwards.

I cannot see what I am doing wrong here. Can anybody help?


2. software for monitoring Sybase/Oracle

3. Data Aware Grid ActiveX

4. I.E.6 taskbar glitch?

5. Data Aware Grid in VFP 3

6. Locking an entire table within a stored procedure

7. help: look 4 data-aware grid 4 codebasic

8. Howto: trigger get latest record and xp_sendmail it ?

9. Which Data Aware Grid & Combo Box to choose..

10. Delphi 'Cleared' Data Aware Grid?

11. Data-aware controls that be aware of nothing

12. Looking for ADO Aware Grid