ll_rc = dw_1.Reset()

Olan

If you're looking to simply discard the row without affecting the database, try the RowsDiscard(start, stop, buffer) method.

Restoring a row can be done in multiple ways depending on how that row was "created".

• Row retrieved from DB
  • Restore row to the same state it now has in the database => ReselectRow(…)
  • Restore row to the same state as it had when you retrieved it but potentially no longer because it may have changed in the database => More complex/more code => for each column
    • Get original item value to set the current value
    • Restore item's status to NotModified!
    • After all columns restored => Restore row's state to NotModified!
  • Recommendation: Go with ReselectRow unless you really need to insist on potentially looking at outdated data
• Row inserted by user/app
  • Remove the current row => DeleteBow(…)
  • Add new row at same position => InsertRow(…)
  • Restore focus to the new row => ScrollToRow(…)/SetRow(…)
• Restoring all content of DataWindow to state it has in database => Retrieve(...)
• Clearing DataWindow of all its content but keep one empty row for editing
  • Remove all existing data from the buffers => Reset(…)
  • Add new row for data entry => InsertRow( 0 )

This hopefully covers your base and more for later reference.

HTH /Michael

Hi,

What / which / where is the ""Clear" icon in the menu bar"?

Are you showing one row (Freeform dw)?

-------------- steps -----------------------

// 1:

dw_1.Reset() // clears the whole datawindow, not a single row left on the dw.

// 2:

dw_1.InsertRow(0) // makes the dw appear without data showing the fields and labels and a dwItemStatus New!

// 3:

dw_1.ResetUpdate() 

// OR ...:

//3:

dw_1.Retrieve(...) // to get the data back that was showing

// OR ...:

//3:

// Do nothing else

-----------------------------

Another thing you could do to get back the data in the state that it was after having done a retrieve, is to work with the Data and primary!, original! buffer, but it all depends on which state you want the data to end up.

Hi Jim;

  The Reset() command is the correct one. It doesn't clear the DWO - just it's buffers. Of course with no data, the DW Control space may seem empty. It would depend if the DWO had literal Header and/or Footer labels.

  To clear the DWO, you would code ...

      DC.DataObject = ""

  Of course, the DW Control would be unusable after that.

HTH

Regards... Chris