Apps limite data from database

[aattaa]

I want to retrieve data from the database. The number of data is fixed and when new data is entered the oldest data is deleted. How can I do that? What to use to erase old data and store new data? I have 25 data location and there will always be new data.

 

[BobPaul]

Use the SQL command delete.

DELETE FROM table_name WHERE (SPECIFY THE CRITERIA FOR YOUR OLD DATA HERE).