Jump to content

glenbeigh

Members
  • Posts

    9
  • Joined

  • Last visited

Everything posted by glenbeigh

  1. John, Thanks for your replies. I appreciate your input. I will first see if my hosting company has any explanation or fix for this. Cheers, Michael
  2. Unfortunately, I do not have full Admin Console access. I do know that the database backs up around midnight or so, but i do not know what other scripts might be running. I will talk to my hosting company, but I wanted to get some opinions in advance, so thanks!
  3. Hi all... I wasn't quite sure where to put this question, so here it is. My database is hosted by a hosting company. I use the separation model, where most of the layouts and scripts are in a local file on each users' computer, and the data is online. It's been running fine for about a year and a half. Over the past month or two, my users have been getting sporadic hangs. For about 5-10 minutes, all users in all locations get the spinning beachball/colorwheel. They generally don't lose connection. Unless they force quit (argh!), it comes back to life after 5-10 minutes and continues operating as normal. I really need to get to the bottom of this. Any ideas? Might this be caused by one user running a particularly intensive (or poorly designed) report? Could this be an issue with our hosting company? I dare not ask: might this be a symptom of a corrupt database? Any thoughts or suggestions would be most appreciated. Thanks all!
  4. John, Thanks very much for your reply. The "Not Empty" box was checked under Validation in the Field Options. I don't think this could be changed from the layout. I did bring up the layout in the new window and tried changing the field. That didn't work, but it did result in a different message, something about the value being required, but that it couldn't be edited on this layout so I was supposed to enter it on a different layout. I don't know if it next came up on its own, or because i hit something (Esc?), but it then gave me the option to Revert the Record. That did the trick! It deleted (un-created?) the record and let me out of the endless loop! Good stuff. Thanks again for your prompt reply, and the assistance. Cheers! Michael
  5. Hi all, Okay, you're going to laugh, but I'm going to ask this question anyway. I've been developing all day (and haven't backed up since first thing this morning) in FM Pro 10 Advanced. Somehow (don't ask how!) I've ended up on a layout where I have a field that requires a value, but is set to be not modifiable. Oops. I can't get out of the record without getting the "{field} is defined to require a value. You must enter a value." message. If I try to type something in, I get that "This action cannot be performed because this field is not modifiable." I can't delete the record or quit. But I can get into ScriptMaker or open new windows and do things on other layouts. I cannot Manage Database. So, my question: Do I just have to Force-Quit? If so, is there any way that the file will be safe to use -- or should I threw out today's development and revert to an old file to avoid any problems? Thank you so much for any help!
  6. Reed, thank you very much for this idea. I appreciate your sample file. However, the value list for Dates doesn't depend upon the found set; instead, it returns all the unique dates in the field. My found set of appointments could be any range of dates from one month to one year, usually a number of months. I suppose I could set up a self-join relationship that depends on the current range of dates and then use the date field in this new table for the value list? Might there be a more elegant way to do this? I figure this isn't such an uncommon need. I was hoping to be able to just Count the date field and be done with it... haha. Thanks again for the help.
  7. Hi all. Forgive the newbie question. I have a found set of appointments for which I need to know how many unique dates occur for these appointments. For example, I might have 40 appointments during the month, but they're spread across only 20 unique dates. I need my script to count the number of total unique dates which contain appointments (in this case 20, not 40). Any ideas? Thanks very much in advance for any help.
  8. oh gosh, all i need to do is... ... Go to Layout Enter Find Mode Set Field (for my two requirements) Perform Find Send Mail (and choose "collect address") ... That's so simple. I was looking for some way to do it through the "Specify Calculation" box in the Send Mail options. Yikes.
  9. Hello! Please forgive a question from a novice, but I just can't find a way to do this... I have a script with a Send Mail step. I want to address it To: any employees who are found by the following criteria: the "Position" field matches "Vice President" and the "Office" field matches an $$Office variable. For employees who match these criteria, I would like it to return the value from their "Email" field to the Send Mail script step. I have some ideas how to accomplish this, but none that are even close to elegant. Thank you very much for any assistance.
×
×
  • Create New...

Important Information

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