crazybake Posted January 28, 2003 Posted January 28, 2003 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 Posted January 28, 2003 Posted January 28, 2003 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 Posted January 28, 2003 Posted January 28, 2003 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 Posted January 28, 2003 Author Posted January 28, 2003 As far as a find script... what is the proper statement to find records which do not include specific text in a field...<>?
kenneth2k1 Posted January 28, 2003 Posted January 28, 2003 Do a find for the text value and omit those. Enter Find Mode [Pause] Omit Record Perform Find [ ] Ken
kenneth2k1 Posted January 28, 2003 Posted January 28, 2003 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
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now