Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About MSPJ

  • Rank

Profile Information

  • Industry
  • Gender
  • Location
    Boston, MA
  • Interests
    Astronomy, Photography, Martial Arts, Amateur Radio (KB1PIE)

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Win 10
  1. Hi - I'm developing a business solution to be hosted on FM Server. It will be hosted on Soliant Cloud. This is my first time developing for Server. I read Steven and Wim's whitepaper on FM 16 security, which was very helpful. In the past, when I've created upgrades to my solution, I've imported data from the previous version into the new one. Each update is a modified version of the previous file. I read about the benefits of using File Access Protection. My solution is a single file solution so I can basically exclude any other file having access - except I'm not sure what impact that will have on import from previous versions. I assume both files will have the same ID - but not sure if that means that FM will see the older version as trusted or not. Thanks!
  2. Hi - thanks for the input and link to that (long!) discussion. Not sure this totally relates though to what I'm trying to do. I have successfully implemented a commercial exe wrapper. That is, users install the trial version, and in order to get more than 30 days use, they have to activate it with a code they get when they purchase. However, there's no way using the wrapper to interact with the solution itself so that my runtime can determine if someone paid for additional features - and enable them if they did. That's the part that must be implemented in C++, C#, etc. I suppose I could look into creating my own plugin using the code from Sciensoft. I suspect that won't be particularly easy. So I wondered if there was instead a way for Filemaker to interact with a separate program that implemented that API. I'm not sure if that even makes sense though. Michael
  3. I wasn't sure how to title this question, but here's my question: I have a software protection solution for my runtime product - I use Eleckey from Sciensoft. The basic licensing function works as an EXE wrapper. and I have that implemented fine, integrates with my software seller and my self-hosted activation server. All good. However, advanced features (such as being able to activate specific features) require adding code to the solution - they support several languages, including C#, VB.NET, VC.NET, VB, VC++, Delphi, and C++ Builder. I'm trying to figure out if there's any way a filemaker runtime could communicate with an external program built using one of these. In other words, if I could build a separate application that incorporated the advanced license code, is there some way a runtime could talk to it - as an alternative to actually incorporating that code in the filemaker solution itself. Even better would be some kind of plugin that let me incorporate that code directly in the solution in some way - but I haven't come across anything like that. Any thoughts? Thanks, Michael
  4. Thanks both! Are there any ways that multiple users could "step on each other" if I don't script something in a particular way? For instance, I have some scripted searches set up with global fields. Are globals stored per user session? So one person's search will not impact the others?
  5. Hi - I'm sure this has been asked and answered before, but I could find it by searching. So I apologize in advance and would appreciate suggestions for resources. I have a solution I've been developing for years which was intended for single user use in a runtime. I'm creating a multiuser version that will be hosted on FM server. I'm looking for information on what to look out for and what changes I need to make to avoid problems in that environment. For instance, I'm already aware of the need to load globals from single record tables with non-global variables. I assume there must be other things like that to be aware of but I haven't found a good resource yet. Thanks for your help. Michael Oh, just to add some details, I expect to have 5-10 users at most.
  6. Hi - I'm having an issue I've never had since starting with FMP 7. I'm using FM Pro Advanced 16 (latest update), working on a database that I've been working on for years. It's always been very stable. Lately, it's been crashing unpredictably. When I say crashing - the program just quits, no messages, warnings, etc. It's happened at different times - running a very simple script, going to a layout, closing the relationship graph. No apparent pattern. Is anyone aware of any particular issue like this? I am running a couple instances of chrome at the same time (quite a number of tabs) plus an SVN client and various things in background. I don't know if it could be a memory issue. I haven't tried a db recovery yet as I have no specific reason to think there's any issue with my db itself. I'm running on Windows 10. Would appreciate any thoughts, suggested trouble-shooting, etc. Thanks, Michael
  7. Thanks for the replies. Not sure what you meant about having to switch strategies eventually - I assume you mean the deprecated runtime? If so, I'm assuming I'll eventually have to move away from FMP altogether (Xojo is in the running) since any solution that requires users to have their own FM license is not an option. (We've discussed this a while back - I know your thoughts Wim. ). RIght now, while I'm still using FMP, I'm trying to determine what I'll get out of an upgrade to 16.
  8. Hi - I'm considering upgrading from FMP 14 to FMP 16. However, my solution depends on a distributed runtime for a commercial solution. It appears that API improvements are not available in the runtime. I'm wondering if the window control (cards) and overall windows interface are at least available in the runtime - otherwise, there doesn't seem to be much point in upgrading for me. Thanks, Michael
  9. FM did it initially - it seems to be doing that for names with spaces - I assumed it was the equivalent of enclosing between \" and \" So what strategy would you suggest for accomplishing the same thing in a value list?
  10. Hi - I've been trying a number of approaches to get a calculated value list using ExecuteSQL code. I initially tried putting the SQL code directly into the Value List definition but that didn't work. Right now, I've done this: I created a UnusedClaims field in a Visit table, whose value is calculated by this: ExecuteSQL(" Select \"_k1_xSAClaim_ID\" FROM \"xSA Claim Status:xSAClaim\" WHERE \"_k1_xSAClaim_ID\" NOT IN ( Select \"_k2_ClaimID\" FROM \"xSA Claim Status:VisitClaims\" WHERE \"_k2_VisitID\" = ? ) " ;""; "" ; Visits::${Visit ID} ) I then put a Claim TO in and related its primariy ID variable to the UnusedClaims field in the visit table. Then I created a ValueList, using the _k1_xsaClaim_ID value from that related Claim TO, and in the value list definition clicked Use only related values from the Visits table. Sometimes this works - but other times it includes values that are in the list that should be NOT IN. The ExecuteSQL code works perfectly in the data viewer, but the Unused Claims field, which has the exact same code in it, includes values it should not include. What am I missing?
  11. Ok - so I got this to work perfectly in the Data Viewer - used nested ExecuteSQL statements. The goal is to use it as a selection criterion, sitting on a claim, looking at a portal of visits. To do this, I set the portal filter to Visit ID = big long ExecuteSQL expression. This works fine on one particular claim, but when I switch to a different claim, it no longer works, even though the Execute SQL statement in the data viewer continues to work. In other words, the Portal Filter seems to be record-context sensitive, while the Execute SQL code in data viewer, does not have that same context sensitivity. Does this make sense?
  12. Wow, thanks! Will try out soon - much appreciated!
  13. Hi - I'm trying to do something that seems like it should be doable, but I can't quite figure out how to do it - I've thought about using relationships and SQL, but neither quite gets me there. I have 4 tables: Visits, VisitClaims, Claims, Account. The relationship between Visits and Claims is many to many, thus the join. When I'm standing on the Claims table , I can easily see all the visits that are assigned to that Claim - simple. If I'm standing on Account, I can see all the visits that have been assigned to claims using that account What I'm trying to do is stand on Claims, and find Visits that have NOT been assigned to claims using the same account as the current claim. In other words, when I go to create a claim, I don't want to see visits that have previously been assigned to claims associated with the same account as the current claim. I'm sure I could do this with some kind of multi-step find -- Find the set of visits that were assigned and then omit those from the full set - but I'm not sure how to create a portal filtered by that definition. I could do a script that runs the find, but I'd have to rerun it every time something changes. That's a possibility, but I'd prefer not to do it that way. It seems like there must be a more straightforward way to do this... Thanks!
  14. Runtime DEPRECATED?

    Wim - that seems a little narrow-minded. Are you suggesting that no one has built a successful business selling to end users? So Intuit really needs to rethink their business model because they aren't making enough money on Quicken and Turbotax? Like Espringer, this is not my day job - but I do hope this will develop into a bigger business eventually, and in the meantime, I'm providing a desperately needed product.

Important Information

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