• Home
  • Family
    • Esther
    • Jeremiah
    • Gabe
    • Spencer
    • Brigg
  • Posts
  • Photos
  • Family Histories
  • Files
  • Links
    • Caveman Youth Football
    • FileMaker Hacks
    • FileMaker Solutions
    • Great Mac Software
  • About Me
    • Contact Me
    • Resume
  • Login
Layne Shipley

PERSONAL

Menu

  • Home
  • Family
    • Esther
    • Jeremiah
    • Gabe
    • Spencer
    • Brigg
  • Posts
  • Photos
  • Family Histories
  • Files
  • Links
    • Caveman Youth Football
    • FileMaker Hacks
    • FileMaker Solutions
    • Great Mac Software
  • About Me
    • Contact Me
    • Resume
  • Login
  • Computers,  ExecuteSQL,  FileMaker,  General

    ExecuteSQL Show 1 Row of Search Results

    05/01/2025 / No Comments

    I have query that do a find, sort the records, then I want to show only the first record:

    Read More
    Layne

    You May Also Like

    Importing JSON Data Into FileMaker

    07/10/2014

    8B AF Shipley 2020

    11/19/2020

    Downloading the Free U2 Album in iTunes

    09/10/2014
  • Computers,  ExecuteSQL,  FileMaker

    Multi Join FileMaker ExecuteSQL Query

    12/17/2024 / No Comments

    I have a client with a database that was over engineered. Rather build a set of overly complex relationships to find this data I attempted my first multi inner join query with SQL. The result was highly successful! Greatly reducing the speeding on reporting pages. The query finds country names, groups them by name, and sums the days the user is in country.

    Read More
    Layne

    You May Also Like

    Where You Can Find Your Plex App Downloads

    01/28/2022

    The Savior Makes All Things Right

    04/13/2014
    BYU vs Utah Ruby

    Going to the Rugby National Championships!

    05/02/2014
  • Computers,  ExecuteSQL,  FileMaker,  General

    ExcuteSQL Dashboards and Charts

    03/13/2023 / No Comments

    Read More
    Layne

    You May Also Like

    Parsing JSON in FileMaker

    05/10/2022

    Downloading the Free U2 Album in iTunes

    09/10/2014

    Creating QR Codes with FileMaker

    07/10/2014

Menu

Recent Posts

  • Gabe Freshman Highlights
  • Gabe JV Football Videos
  • Gabe Mission Photos
  • ExecuteSQL Show 1 Row of Search Results
  • Multi Join FileMaker ExecuteSQL Query

Categories

  • American Fork
  • Baseball
  • Bitcoin
  • Blog
  • Brigg
  • BTCPayServer
  • Computers
  • Documents
  • ExecuteSQL
  • FileMaker
  • Football
  • Football
  • Gabe
  • Gardening
  • General
  • Laugh
  • MacOS
  • Mission
  • Moodle
  • MU Wordpress
  • Music
  • OS X Server
  • Plex
  • Religion
  • Rugby
  • Shipley
  • Spencer
  • Sports
  • Wordpress
  • WPLMS

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org