Field Data Deletion based on a timer

[Issachar5]

Is there a way to setup a code that allows data to be deleted from a field
based on a date range.

 

[PvdG42]

Is there a way to setup a code that allows data to be deleted from a field
based on a date range.

Where and how is the data stored? Are you talking about a field in a
particular row in a database table, or what? Where is the date range
information stored, in the same database, or somewhere else?

In general, yes, there probably is a way to do what you want. To get useful
suggestions, you'll need to supply all the details pertinent to your case.

 

[Jamal Samedov]

of course there area ways:
1) suppose you table has intrinsic datetime stamp field
2) if not then add such field with correspondent trigger which will update
the field during creation or/and updating of the record
Then sometimes (up to scenario of you application) you can run stored
procedure (or routine in your code) which will delete records older than let
say 1 month (or whatever another criteria)
The exact solution you should architect self
1) what should be deleted
2) when should be deleted
3) where from should be deleted


www.coin-masters.com