Jump to content

Ron Cates

  • Content Count

  • Joined

  • Last visited

  • Days Won


Ron Cates last won the day on September 6 2012

Ron Cates had the most liked content!

Community Reputation

8 Neutral

About Ron Cates

  • Rank
  • Birthday 04/07/1969

Profile Information

  • Gender
  • Location
    Morristown TN ( Near Knoxville )

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Sound like Go To Related Records to me.
  2. I purchased the plastic plugin yesterday on behalf of our company. I have successfully deployed and registered the plugin and have been able to integrate the scripting, table and fields from the demo file. So far it has gone very well and I am able to process credit cards with authorize.net successfully. Great product!! However I am having some issues with processing electronic check transactions. Using the same API credentials that I am successfully processing cards with I am receiving an error message "The merchant login ID or password is invalid or the account is inactive" Do I need different API credentials for authorize.net for check processing? Also, the Plastic demo is giving the same error with the API credentials it shipped with while the card processing demo works fine. Any help would be appreciated.
  3. Thanks. I'll give it a try. And I whole heartedly agree. Network issues are very difficult. In the last couple months since I have been providing remote access to this system I have gotten reports a variety of different experiences from different users in different locations. It's so hard to trouble shoot any issue when I can't reproduce what the user is reporting from my own location.
  4. User 2 reported this afternoon that she was able to open the interface file from the main file and it came up as it should. User 1 as of last night was still getting Table Missing on the Main file. Can't access the Sales interface file without having access to the main file so he get's no where. He will not be able to try again until tonight. Scratching my head..
  5. In this case the data file is the main file that is already open. The UI file is opened from the data file. The Main file is a self contained file that I have been working with for years. I recently developed and added the Sales file as a UI file that uses the main file as a Data file.
  6. Let me revise my response to bcoony. The UI file is opened from the main file by firing a script that then runs an external openning script in the UI file. Not sure if that makes a difference but it's not using an explicit open file command as the question asked. Do you think it would make a difference using an open file script step instead? rwoods I've double checked the External Data Sources and both files are connected to each other as External Data Sources using the relative paths ( file:CAMv1 and file:CAMv1_Sales ). The files do reside in the same folder on the same sever.
  7. The UI file is opened from within the main database using a script with an open file script step.
  8. I don't even know where to begin with this one. We have a quite large and complicated database developed continuously over the last 10 years. We are currently running Filemaker Server 16 on Windows Server 2008 R2 and all clients are using FMP 16, all on windows 10. Recently we have started working on allowing remote access to our system for employees on the road or working from home. Also recently added a separate interface file that uses the original file as a data source to provide a dedicated sales interface. Other than struggling with the performance over widely varying internet speeds the system has been up and running successfully. Until a few days ago... Here's what's happening. I am the developer and am located remotely. I do my development through team viewer but I can test the direct remote access. I am able to access the database remotely as well as open the separate interface file and all is well. User1 Accessing remotely opens the main database file and the fields all show "Table Missing". User2 Accesses the main database remotely and all is well but when she opens the sales interface file all fields in that file show "Table Missing". The system is operating normally for the 10 or so users at the local office. I have accessed User 2s computer remotely through team viewer and logged in to the database using my user name and password and I get the same result she does, so it's not based on the user account. So currently I'm looking at 3 different remote access locations all getting different results. We are all within the US and only a state or two away from the local office. I have rebooted the server this morning but no change. I don't even know where to begin. Any help would be appreciated...
  9. I was experiencing this after upgrading to 12 I think. Anyway, what I found was that if my field borders were set to less than a full point it was causing objects to jump. For instance I had fields that were set with a border of .25 ( hairline ) . When I changed them all to a full point it fixed the problem. May not be your situation but something to check for maybe..
  10. You'll want to set the variable to the entire path and then enter just the variable $$marinaDir = "filewin:/C:/MarinaPro v17/Marina.fp7" Open File ["Marina"] (Marina File Path: $$marinaDir )
  11. Filemaker 16 got me with this one too if it's what I think it is. I had several fields that were formatted as a button as previously mentioned. In FM15 I could select the field and change the data source and such. In FM16 the options were grayed out and unavailable. What I realized as mentioned was that the field was now grouped. The easiest way I found is to right click the field and choose Arrange > Ungroup. I do find this annoying as I have to ungroup to make any changes and in doing so I lose my button setup. After the change I have to reformat as a button again. I often use some pretty complex script parameters so I need to be sure to copy them before I ungroup so I can replace them. It's not a big deal but less convenient than previous behavior.
  12. I created a little custom function some time ago to allow me to set variables on the fly with dynamic variable names and repetitions. So to address my problem I just need to have the set variable script steps that are affected use this function to set the variables using the same repetitions as before. It simply wraps a Let function with Evaluate. The custom function is simply Evaluate ("Let ( $$" & ~var & "[" & ~rep & "]=" & Quote ( ~value ) & ";\"\" )") Parameters are ~var ( name of the variable ), ~rep ( repetition ) and ~value ~setVarByName ( ~var ; ~rep ; ~value ) So I can set my set variable script steps to something like this ~setVarByName ( "Back" ; Code ( Get ( WindowName ) ; GetLayoutID ) I've tested this and it works as expected.
  13. The post on TechNet says 17 digits but I count 18. Am I miscounting or are they. Lol! Regardless, it was pointed out on that post that only the set variable script step shows the limitation, meaning that a variable set with a Let() function can set the variable with the repetition as desired. Let ( $$LONG_REPETITION[9999999999999999999999999999999999999999999999999] = 10; 1 ) I think that make the most sense for my fix. That way I only have to adjust everywhere the variables are being set and where they are being referenced can remain the same. I haven't tested it myself yet, but will tomorrow..
  14. So here is the issue simplified which had nothing to do with code ( Get ( windowName ) ) after all. Variable repetitions in FM16 appear to be limited to 18 digits. If more than 18 digits are entered it will use the last 18 digits of the entered string whereas FM 15 and prior did not have this limitation. This throws a big monkey wrench into my works as I use the technique of "Bucket Variables" as I now recall it being called in several techniques that I've developed and use on a regular basis. Not only do I use code ( Get ( WindowName ) ) but I also use Code ( record::ID ) in many places to set a variable to an individual record. Ugh! Now to start checking through my solutions to find where this is going to bite me. I would certainly welcome any suggestions for a work around for unique repetitions since I'm loving the new features of FM 16 but have to adjust all my files to be able to use it...
  • Create New...

Important Information

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