genrate alarm

[nitinjainitm@yahoo.co.in]

hi,

   I have created SQL database and store some element expiry date in this table. Now i want to genrate a alram when today date and expiry date are equal. And i don't know, how do i do that. please someone help me.

[GerdW · Accepted solution]

Hi Nitin,

try this:

[nitinjainitm@yahoo.co.in]

hi GerdW,

    Thanks for your reply. Could you please tell me, how am i know which element has been expired.

Becouse i have 3300 element and all element expiry date is store in SQL Table. i know how can i read this table but generate alarm is the main problem please help me

[Dennis_Knutson]

Gerd's example shows you exactly how to generate an alarm. I don't think you really know how to do the query. It would be simply setting it to return all items with an expiration date less than or equal to the current date. All rows returned would be expired.