Table sort FM6

[seraph_nyc]

I have create a small database in 6, the client is hesitant to upgrade. I am using a table to organize their records. They have a field called final date in which the due date of thier projects is due. I want to find out all pending projects due. So I create a calculation final date > today's date = pending (1 or 0). In FM7 i can sort or do a find with this calculation. But the choises are not available in 6. Anyone know how to do this?

[-Queue-]

You should be able to sort and find on a boolean calc. You need to make sure that it is unstored, however, if you want it to update.

It would probably be better to forget the calc, though, and merely do a find on the due date for pending records. You can create a script to go to a layout containing the due date, Enter Find Mode, Insert Calculated Result [due date, ">=" & DateToText(Status(CurrentDate))], Perform Find. If you need a more limited date range, use DateToText(Status(CurrentDate)) & "..." & DateToText(Status(CurrentDate) + 30), for example, to find all projects due within the next month. No unstored calc field is necessary, and the finds will be faster since the due date can be indexed.

[Lee Smith]

Hi JT,

Welcome Back, I've missed your corrections (errrrr, additions) to my posts.

Lee

[seraph_nyc]

Ok, I thought there should be a way to script a find in 6. It just looks different in 6 than in 7. I will try that.

[-Queue-]

Thank you, Lee, as have I.

Seraph, you can either perform a manual find and then add a Perform Find step or Enter Find Mode step (if you want to add more criteria) to a script, with the Restore option enabled or you can script an Enter Find Mode (with Restore disabled) and use Set Field, Insert Calculated Result, etc. to set your criteria, then Perform Find (also with Restore disabled).