Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7974 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

Posted

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

Posted

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

This topic is 7974 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.