Skip to main content
April 12, 2022
Solved

why does my list still display data after I deleted it from the underlying database table

  • April 12, 2022
  • 2 replies
  • 0 views

I created a data grid to display from a database table, and allow me to add new entries using an associated interface.

The data grid gets its data via a data store that is linked to the underlying MariaDB database.

I had created some dummy records using my data grid and its associated data entry interface.

Consequently, to clean it up, I went into the MariaDB and deleted the dummy rows from the database table.

However, the data grid still shows the rows I deleted.  It is only when you try to open the row in the associated interface to modify the row, that you notice that there are no values for the fields.

Can anyone explain how this might be occurring?  Is the data cached somehow in the data store object or perhaps the record type object?

Thanks heaps,

David

Best answer by stefanhelzle0001

Is this based on a synced record? If yes, the data is still cached. Go to the record and start a manual sync.

2 replies

stefanhelzle0001
Brainy
April 12, 2022

Is this based on a synced record? If yes, the data is still cached. Go to the record and start a manual sync.

davidb545Author
April 12, 2022

thanks heaps - we found the synch option and synched the data - and that cleared out the old rows.

cheers,

David :-)