Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


normanicus last won the day on June 6

normanicus had the most liked content!

Community Reputation

2 Neutral

About normanicus

  • Rank

Profile Information

  • Gender
  • Location
    France/UK/New Zealand

FileMaker Experience

  • Skill Level
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

Recent Profile Visitors

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

  1. normanicus

    SQL to FQL rules

    Thank you for the reply. Having admitted to my mental laziness I made some progress. My breakthrough was to put the query into a global text field so I could play with less effort.
  2. I am wanting to learn to use the ExecuteSQL() function. I find I seem to take quite naturally to SQL when working through the examples on w3schools but am quickly lost in a maze when I try to translate this learning to use in Filemaker. I have seen the introductory articles but have rather a lazy mind. Are there a set of concise rules to translate from SQL to FQL? In passing, as this has become an important feature in Filemaker, would it not be reasonable to expect Filemaker to provide an SQL editor where one could enter standard SQL, use field and table references, and then give us the FQL version of the query?
  3. normanicus

    User created window control

    I didn't explain clearly enough. I'll try again. Table 'DPD' is in file Sales Items. The DPD layout is used in a window 'DPD' created with the New Window script step. When using the DPD window it is on the DPD layout. If the last action performed in the file Sales Items used the window DPD then a subsequent call to GTRR using a table other than DPD uses the DPD window , not the window of the parent file** , Sales Items. This may well be normal behaviour but means that GTRR script steps have to be followed by a Select Window to work as intended. I hope I am missing something. ** 'parent file' I'm using to mean the file containing the table DPD.
  4. I have a window, DPD, based on a table in a file, Sales Items. I am surprised that a GTTR going to a different layout in the same database takes me to the DPD window and not the parent db window. I assume this is intended behaviour? Does this mean that I have to replace all GTTRs in that database with a script that includes a 'Select Window' script step?
  5. normanicus

    FM17 add Filemaker data source via 'Hosts'

    Thank you. I knew if must be simple but I actually searched for answers for quite a while.
  6. In previous version of Filemaker I've been able, in the relationship graph, to 'add a Filemaker data source'. The dialogue, as in the image, after clicking 'Remote' showed only the 'principal' Filemaker file but I could replace the name with the file I sought to add manually. Now, with FM17 I no longer have this option. So, how do I add another of the served files as a data source? I suspect I am missing something simple
  7. normanicus

    Data Migration Tool : repensons le versioning

    Est-ce qu'on peut utiliser des 'wildcards' (REGEX) ? Accepte-t-il des 'pipes' ?
  8. normanicus

    Realtime Developer Intelligence

    This is what google produces as a definition of realtime : "relating to a system in which input data is processed within milliseconds so that it is available virtually immediately as feedback to the process from which it is coming, e.g. in a missile guidance system."
  9. normanicus

    Realtime Developer Intelligence

    I read the article. FM Perception works with the DDR. The DDR is not a realtime thing. So how can this be a realtime tool?
  10. normanicus

    GetLayoutObjectAttribute() not working

    Apologies for being slow to report back. I recovered the file but it made no difference. I left if a couple of days and then thought to delete my Web Viewer and paste in the one from the test file Comment provided. It worked. So, it was the Web Viewer that had become dysfunctional, maybe corrupted. Thanks once again for your help.
  11. normanicus

    GetLayoutObjectAttribute() not working

    Went back to an old backup and found one that works. Did a Recover on the bad file and there were errors. Still the button didn't work. I'll paste your Web Viewer onto my layout and see what happens.
  12. normanicus

    GetLayoutObjectAttribute() not working

    Thank you. I tested your file and it works as it should. Copy/Pasted the 'Get Content' button to my file and changed the field to the one I use. Nothing. Chose another, non-global field on the same layout, nothing. So, as you said, something is going wrong. I never mentioned before but this was also failing on the client's computer so it looks like it is a corruption problem or similar. Your test has shown it is neither the browser or FM14 causing the problem. I'll try an older version of this file and then a 'Recover' and report back.
  13. normanicus

    GetLayoutObjectAttribute() not working

    I'm doing something like this: Set Field [ globalTextField ; GetLayoutObjectAttribute ( “Magento” ; "source" ) - where 'Magento' is the object name of the WebViewer. The contents of the Web Viewer is based on a URL stored in a field. I just put 'https://www.google.com' in that field and the Google search page appeared. Clicked the button with the above script step on it and the text field remains empty. When it is working I put the results into a variable and extract the page title. Let me know if more information is required.
  14. FM14, Mac Sierra, Google Chrome. I have set up a script to scrape the title from the page showing in the Web Viewer. This was working fine. Now I get nothing. One problem I solved. There was a message showing at the bottom of the web page referring to blocking third party cookies. I went into settings and allowed these. Still nothing. I was using the FM16 Trial which ran out so I reverted to FM14 Advanced. I think this may be the problem because, when running file from Soliant which demonstrates interaction with Web Viewer, each time I run script it opens FM16 telling me the licence has run out. In the Finder I changed the default opener for FM files to Filemaker 14. Still does the same thing. GetLayoutObjectAttribute is not exactly replete with error messages. Hopefully, I am just being dumb and somebody will put me right. Meanwhile I'm going through the hoop of trying to install the necessary packages in Python 3.6 so I can do this in Python. I know it's an aside but setting up Python in Sierra/OS X is not straightforward.
  15. normanicus

    FM 16 Variable Repetition limitation change?

    This may not be appropriate by why not use Get ( CurrentTimestamp ) as your repetition number? This, unless you are creating more than a window/second, is guaranteed to be unique, to be compatible with whatever version of Filemaker and has the benefit of being in historical order. As I said, maybe I'm missing the point.

Important Information

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