Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Results 1 to 5 of 5
  1. #1
    FMT Preferred FileMaker Consultant - Trainer jaymo67's Avatar
    Join Date
    Sep 2014
    Posts
    104
    Location
    Chino Hills, CA
    FileMaker Pro Software
    FileMaker 15 Advanced
    OS
    Mac
    Skill Level
    Developer
    Last Post
    11-02-2017
    Local Date
    11-25-2017
    Local Time
    02:32 AM
    Last Active
    11-02-2017

    Preferences and Options

    I'm no SQL expert but I know when, and when NOT, to use the ExcecuteSQL function. ExecuteSQL is not for creating replicas of portals, despite the numerous examples floating around the internet. It's also not designed to replace the built-in FileMaker find feature, even though it seems to replicate the search abilities of find mode. In fact, there’s really nothing ExecuteSQL can do that a relationship can’t do, it just can do it without a relationship. In other words, it resolves Relationship Graph clutter but, only under under certain circumstances.

    http://www.philosophyoffilemaker.com...nd-options-119
    - John Mark Osborne
    FileMaker Developer for over two decades. Certified in FileMaker 7, 8, 9, 10, 11, 12, 13, 14, 15 and 16.
    http://www.philosophyoffilemaker.com/

  2. #2
    Gold Member
    Join Date
    Mar 2015
    Posts
    27
    Location
    Bakersfield, CA, USA
    FileMaker Pro Software
    FileMaker Pro ver14.3 - Mac
    OS
    Mac
    Skill Level
    Intermediate
    Last Post
    10-25-2017
    Local Date
    11-25-2017
    Local Time
    01:32 AM
    Last Active
    11-21-2017
    What about replacing hand inputs to a joint table for a many-to-may relationship. I recently did one of these for assigning Doctores to Procedures in a many-to-many & it took a very long time. Would this be any easier using ExecuteSQL?

  3. #3
    FMT Preferred FileMaker Consultant - Trainer jaymo67's Avatar
    Join Date
    Sep 2014
    Posts
    104
    Location
    Chino Hills, CA
    FileMaker Pro Software
    FileMaker 15 Advanced
    OS
    Mac
    Skill Level
    Developer
    Last Post
    11-02-2017
    Local Date
    11-25-2017
    Local Time
    02:32 AM
    Last Active
    11-02-2017
    ExecuteSQL can only query a FileMaker table, it can't add, delete or edit records. Good 'ole Set Field is probably the best choice in this scenario.

    I found a good article on this subject:

    https://filemakerhacks.com/2017/10/2...rocal-linkage/

    Hope it helps!
    Last edited by jaymo67; 10-25-2017 at 10:12 AM.
    - John Mark Osborne
    FileMaker Developer for over two decades. Certified in FileMaker 7, 8, 9, 10, 11, 12, 13, 14, 15 and 16.
    http://www.philosophyoffilemaker.com/

  4. #4
    FileMaker Mentor
    Join Date
    Aug 2015
    Posts
    111
    Location
    Broomall, PA USA
    FileMaker Pro Software
    FM 16 Advanced
    OS
    Windows
    Skill Level
    Intermediate
    Last Post
    11-18-2017
    Local Date
    11-25-2017
    Local Time
    04:32 AM
    Last Active
    11-24-2017
    Hey Jaymo, can't seem to reach the blog site for the last few days. Keep getting error message:

    This site can’t be reached

    www.philosophyoffilemaker.com took too long to respond.

    Can't reach it via PC or iPad

  5. #5
    FMT Preferred FileMaker Consultant - Trainer jaymo67's Avatar
    Join Date
    Sep 2014
    Posts
    104
    Location
    Chino Hills, CA
    FileMaker Pro Software
    FileMaker 15 Advanced
    OS
    Mac
    Skill Level
    Developer
    Last Post
    11-02-2017
    Local Date
    11-25-2017
    Local Time
    02:32 AM
    Last Active
    11-02-2017
    Been having a bit of trouble with my web server lately. It's up and running now. Thanks for your patience.
    - John Mark Osborne
    FileMaker Developer for over two decades. Certified in FileMaker 7, 8, 9, 10, 11, 12, 13, 14, 15 and 16.
    http://www.philosophyoffilemaker.com/

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Saving preferences
    By nbrown46 in forum FileMaker Pro 12 - All versions
    Replies: 0
    Last Post: 09-08-2014, 01:10 PM
  2. User preferences
    By brsamuel in forum Portal & Relationships
    Replies: 3
    Last Post: 11-11-2008, 11:34 AM
  3. Creating user preferences
    By iankh in forum ScriptMaker and Scripting
    Replies: 4
    Last Post: 06-08-2006, 04:45 AM
  4. Network Preferences
    By Johnny Boy in forum FileMaker Pro Versions 5 & 6
    Replies: 4
    Last Post: 07-07-2003, 06:36 PM
  5. Global preferences
    By Ed G in forum FileMaker Pro Wishlist
    Replies: 1
    Last Post: 03-25-2002, 04:09 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 42,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.