hello all,

i have created a session for dumping some condition base data in a table.but this program should run once in a month. I am using user define button for inserting . My question is how should i restrict so that it shuold not process more than once

thanx in advance

I think the only way is to store the date when the data was last processed. The next time when data is to be processed, the script will check the last date, and function accordingly.

thanx for the reply

i am storing the date but i donot know where to write

Originally posted by novicebaan
hello all,

i have created a session for dumping some condition base data in a table.but this program should run once in a month. I am using user define button for inserting . My question is how should i restrict so that it shuold not process more than once

thanx in advance

Why don't you use the job scheduler for running this session every month?

Regards Bernd

Originally posted by novicebaan
thanx for the reply

i am storing the date but i donot know where to write

In the before.program section of the program script, check the current month and the month of the last processing date. Accordingly build the logic.

thanx , i have written a script in before.field . It is working now