Thoughts on Setting Up a Find

[kenneth2k1]

Hey all. What's happenin?

Please forgive me and be patient with this long post. I had tried to make it brief, but had to go back and change it because there was important information missing. "Wrote a song bout it, wanna hear it, here goes.."

In case you didn't already know, I have a database that prints a series of letters. In order to track which letters should print at what time, I have set up many scripts (with the invaluable help of this forum). They basically go like this:

If ["Letter(X) = "Intro Ltr" and "Status(CurrentDate) >= LtrPrintDate + 4]

Set Field ["Letter(X1)","FollowUp Ltr"]

Insert Current Date ["LtrPrintDate1"]

Go to Layout [FollowUp Ltr]

Print

blah blah

As you can see, these letters print based on if certain text is in a field, and if today meets the inequality criteria. Then it sets another set of fields, which will be used by other scripts in a similar fashion. All these scripts are combined in one big script that runs once each day. These scripts work great. But what I want to do now is be able to re-print the letters if the letters didn't print properly, got destroyed, etc. So I am devising ways to go about this - using the current setup. I had first thought of doing a search of all the date fields (LtrPrintDate1 in this example) that have Status(CurrentDate), clearing those fields and the fields that contain the corresponding letter info (Letter(X1) in this example). Then run the big script again.

I am hesitant to do it this way because the script would have to search each letter date field, clear it and the letter info field, and it may turn out to be a slow process. Last time I counted, there are 48 sets of these fields and could grow to be more.

So I would appreciate some insight on how to approach this problem before I just dive into it without a complete plan. Vaughan had once helped me with this problem a while ago, but I cannot recall what advice he gave, besides telling me that the fields should not be set until it was confirmed that they had printed properly. Sorry. If you have any questions or this is not clear, please let me know and I will gratefully give more info.

Thanks

Ken

[djgogi]

Change the criteria to

If ["(Letter(X) = "Intro Ltr" and Status(CurrentDate) >= LtrPrintDate + 4) or rePrintFlag"]

---

where reprintFlag assume values 0 and 1

Dj

[kenneth2k1]

Ah, I see. So should I put a set field in there to place a 1 if it prints?

I really appreciate your help.

Ken

[harryk]

hope I am not interfering, but your conclusion with the question mark seems to me right. When you add that reprintflag field, that must be automatically set when execute the print command, you might add a lay-out in which you can manually set that flag back to zero in case of misprints, spoilt coffee, or eaten by the dog.

Running the thing, using the suggestion of djgogi gives you the reprints you want.

Harry

[djgogi]

Right!

Dj