Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About sawhillr

  • Rank
  1. Hi Steven, Let me explain a bit more. The server is mainly set-up as a general file server and the DB is mainly accessed/edited directly on the server Mac itself. This guy is going to be doing editing remotely and will be doing so when no one else is accessing the DB (locally or remotely). In the long run, we will switch to FM Server, but at this point it is not financially viable and the amount of remote need is minimal (1 remote user, no simultaneous users). Once the business picks up and there is need for remote access we will be able to switch over. Hope this helps clear up the
  2. Please let me know if this is not the right forum for this question. Background: — We have FM Pro 10 Advanced loaded on a Mac OSX server in NY. — We have a contractor who has been hired to edit database content in Kentucky on a Windows Vista laptop running FM 10 Pro. — We have successfully set up a VPN connection and have remote access to the DB files (using favorite hosts and setting a local/internal IP address for the server network). Problem: When VPN connection is active, internet browser connection slows to a stand still (even though FM works fine) and he must have acces
  3. many thanks everyone. I freely admit my brain is still back in the days of the original flat file DB mentality of Filemaker. I have used it here and there over the years and have been thrust back into it to fend for myself. This project is probably too far up the river to go back and restructure but I appreciate the advice and will look into changing my ways going forward. For those that suggested GetField, I had tried it but with no luck, will go back and see if I missed something and/or try Evaluate. Again thanks for your patience and support
  4. wouldn't surprise me if I suffer from basic design issues, have been self taught and my needs have grown sporadically over the years. Database 1 is a sports score DB that stores daily scores (up to 20 games per sport per record) for 6 different sports. Each field (MLB01, MLB02, etc) contains blob of data representing the 2 teams and their scores. Database 2 is a aggregator of data from various other DBs including the sports DB. For reasons too long to go into, I need to use a script that gets the score data from the sport DB and uses SetField to enter the data into the final fields
  5. I have a sequence of scripts that needs to repeat itself about 400 times. Each of the 400 versions should look at a different related field. A sample of the field name would be MLB01, MLB02, MLB03, NFL01, NFL02, NFL03, etc. In each case, the field name is called on multiple times within the script steps. I would like to build a variable to handle this so that I only need to set the MLB/NFL portion separate of the 01/02/03 portion. [color:blue]SetVar ($sport="MLB") SetVar ($num=1) SetVar ($fn="Sport::" & $sport & "0" & $group) [color:blue]$sport will stay the same for
  6. BruceR, your loop and Tominator's repetition & decimal trick will work wonderfully together. Many thanks.Have been rebuilding another part of my logic utilizing the repetitions to make it easier for the rest of the build. This thought process does not come easily some days so moving slowly and testing often. Thanks for all your help.
  7. OK, getting my head around that. After playing with it a short bit I have one question to make sure I am getting this right. When I set the first repetition of $M (previously $M001), then I would set the Repetition value to 1. When I set the second repetition of $M (previously $M002), then I would set the Repetition value to 2. However, when I set the first script to 1, the listing of the script step omits the [1] from the variable name. Does this mean that $M is also the same as $M[1]?
  8. Tominator, that's sneaky — I like it! And yes, my numbers are integers. I have never used repetitions, nor do I understand them, so I will do a bit of reading. If there are any quick tips you have on how they work or good samples to look at I'd appreciate the extra help. That said, even if I do not use repetitions, i can see how I can solve this issue using your initial decimal trick. again, thanks
  9. I'll give it a try when I get back to the office and see how it works. Thanks for the advice.
  10. good question. My first choice is to see the two variables battle to the death in a centrally located container field, but, I'm thinking that might be a bit much even for FM. My variables are currently named $M001 thru $M027. Based on the away things are setup, the higher numbered variables should be the priority over the lower numbered variables. thanks
  11. is there a way to truly convert the contents of a field to title case instead of changing its style (which doesn't really change the contents)? I need to apply this to a headline field that is always in All caps from the source. The problem with changing anything to Title case using styles is that there may be a word that needs to be in all caps (EPA, USA, FBI) so someone has to manually fix them. But if you apply a style, there is no way to change just one word. Also, FM's Title Case function is a bit dumb, it sees a quotation mark as the first letter of a word and will then change what
  12. My customer aggregates a lot of text material (news articles) and in massaging all his data goes back and forth between MS Word and Excel with Excel being the last stop before importation into FM. This changes any curly quotes to normal quotes. I need to convert them back to curly quotes AFTER the data has been imported into FM. Does anyone know how to do this? I even tried a script that would copy the field data and then paste it back into the field but that did not work. Thanks
  • Create New...

Important Information

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