Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About fedixon

  • Rank
  1. I know there is an elegant solution to this problem... just can't seem to find it! I have an FMP interface into an Oracle table via ODBC which contains a number of text-entry fields. These fields are ultimately delivered to an online application and some are used for display, others for things like searching and sorting. During data entry, users are entering or pasting special (high-ASCII) characters from their keyboards. Depending on the field, these need to be converted. In some fields they need to be "flattened" (ex: á changed to a)... and in others they need to be changed to a valid HTML character entity (ex: á changed to ampersand+aacute;). Right now, I have OnFieldExit trigger scripts that execute a series of Substitute statements, one for each search/replace string. But I end up writing a separate script for each field, just so that I can set the Specify Field for each statement, and set the (text)parameter of the Substitute calculation. Hugely time-consuming and seemingly inefficient! There MUST be an easier, more centralized way to approach this problem. : Any suggestions and/or solutions for better text handling? I'd be very grateful to know and learn.
  2. Thanks again for responding, Sam. Our users are scattered across two floors of a large building, and the powers-that-be have decided to subnet by floor. That leaves our two servers AND roughly half our users on Subnet A (myself included), and the remaining users on Subnet B. It's lousy, but fixed. What is the IP address quartet? and how would I search for it? I must admit I'm technically-challenged in this area.
  3. ..."do any files on Server A relate to files on Server B? If so, that's another can of worms to delve into..." YES!!!.. that is my biggest issue. I've got cross-server relationships and script steps all over the place! I have fixed them all from a workstation outside the local subnet, so they are currently working, but my development for the future is a problem. I'll have to continue to relate and script across two servers, but my computer is in the same subnet, and hence I get the (*), which I cannot seem to change. I'm looking for a way to INSERT the IP address when I create a relationship or script step. I don't know how to do this! Can anyone help?
  4. Thanks, Sam... that would be an excellent solution if I could get one of the servers to populate the Hosted list automatically (then I could put the opener there). The problem is that FMP does not detect either server when the Hosts button is clicked. Users are required to click on an IP address to get to anything at all... so it would actually add a second step. Still wanting to hear if anyone has a way to hardcode the relationships?
  5. I've always found good advice here... so I'm giving it a shot! In our department we have a few hundred relational files all hosted on one of two NT servers, and "collapsed" in the hosted list under a handful of front-end opener files with descriptive names. We have about 100 clients using both Windows and Macs (v 5.5). In the past, all clients who opened the Hosts dialog were presented with the complete listing of these files, viewing both servers. Recently, my company has undergone a complete IP restructuring, which has split my FMP user base into two separate subnets (this cannot be changed). This means that users who are on the SAME subnet as the servers (myself included) see the lists as before, and all relationships are intact. All users on the OTHER subnet now have had to have the IP addresses individually added, and can only view one list at a time, and the relationships have all had to be re-established. (What a pain!... I know you would say to use opener files, but the maintenance of these on each workstation each time we change/add FMP "apps" is dreadful, with the number of clients we have) So my question is this: Since my workstation (sole FMP developer) is in the same subnet as the two servers, how can I define relationships and/or scripts that will still path for users outside of this subnet? Is there a way to hardcode these to a specific IP? Any advice (other than the obvious: get another machine on the other subnet) would be appreciated!! Thanks, Felicia

Important Information

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