missing the boat?

[crazybake]

I have working with my app for months and have it working (at least doing the things I need it to do).. However, this was with one user. Now that I have it on the server with multiple users, I find a fundamental flaw in my understanding of storing data... help!?

I have a button which shows all scheduled jobs. When the user clicks on this button, I have a loop which looks at all records omits records in which field a is set to "done". The problem is that when this script is performing it is slow (maybe I should have used a find instead). Also, when other users attempt to perform this script it states that records are being modified by other users (I assume becasue the script is looking at all records).

Is there a fundamental problem in which a script omit records such as above EVERY time the button is selected.. or should I be storing this info in some manner...

thanks

[kenneth2k1]

Hi:

Loops in dbs with lots of records will be slow. Yes a find may be quicker. What is your script? Please give more information. Are users opeining dbs with the host dialog to the server? Are you using FM server?

Ken

[BobWeaver]

A find will be much faster than a looping omit script. Just do a find on the done status field then save it as the script that your button executes.

[crazybake]

As far as a find script... what is the proper statement to find records which do not include specific text in a field...<>?

[kenneth2k1]

Do a find for the text value and omit those.

Enter Find Mode [Pause]

Omit Record

Perform Find [ ]

Ken

[kenneth2k1]

Sorry, just re-read the post and Bob's first answer was right.

Perform a find manually for Done (omit) and perform. Go to ScriptMaker and:

Perform Find [Restore]

My answer was for a user-defined search and omit.

Ken