Prev: SMTP Mail Sending Problem Windows 7
Next: Encryption algorithms for product licensing
From: Issachar5 on 1 Apr 2010 15:26
Is there a way to setup a code that allows data to be deleted from a field
based on a date range.
From: PvdG42 on 1 Apr 2010 18:41

"Issachar5" <Issachar5(a)discussions.microsoft.com> wrote in message
news:35A8ADCC-DD1C-4877-B0E1-FAEE1C0B4FBC(a)microsoft.com...
> 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.



From: Jamal Samedov on 7 Apr 2010 09:31
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
"Issachar5" <Issachar5(a)discussions.microsoft.com> wrote in message
news:35A8ADCC-DD1C-4877-B0E1-FAEE1C0B4FBC(a)microsoft.com...
> Is there a way to setup a code that allows data to be deleted from a field
> based on a date range.


 | 
Pages: 1
Prev: SMTP Mail Sending Problem Windows 7
Next: Encryption algorithms for product licensing