TOraceDataset.ResfreshRecord on deleted row?

[rakgol_a]

Hi,

I'm using DOA 4.X(on CB5.x, and Oracle 9i).
When I call refreshrecord method on a deleted record to clear it from the display DBGrid,
the record still remains until u do a full refresh.

This record is delete by a stored procedure after
passing it details of the record from a button click event.

If this is not a bug, how can I refresh only one deleted record without having to refresh.

 

[Marco Kalter]

Instead of explicitly calling your stored procedure to delete the record, you could actually delete it from the dataset, and call the stored procedure from within the OnApplyRecord event handler. This way everything stays in sync.

 

[rakgol_a]

From design side of things in our system,
no DML statements are allowed from the
presentation layer; hence we use stored procedures
as interface for DML operations and business logic.

Is there any other way without having to delete directly from the dataset?

 

[al0]

Originally posted by rakgol_a:
From design side of things in our system,
no DML statements are allowed from the
presentation layer; hence we use stored procedures
as interface for DML operations and business logic.

Is there any other way without having to delete directly from the dataset?

But Marco's advice doesn't contradict to your approach! Deletion from DB is performed by OnApplyRecord event or at some other place. No direct DML, only procedure call!