Jump to content
Sign in to follow this  
Richard Carlton

Free Video>>> FMPUG-Without Borders - July 15 - SQL Intro for Beginners

Recommended Posts

Please Excuse the Minor Audio feedback issue at the beginning.  We were unkinking out new studio.

 

FMPug Without Borders | Execute SQL with Todd Dignan

www.filemakerusergroup.com

http://youtu.be/y8fuHbBw2Zw

 

Download the FileMaker Pro 14 & FileMaker 14 for Mobile Devices Training Videos athttp://www.learningfilemaker.com

Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos Please Subscribe While There.

 

Richard Carlton Consulting, Inc. provides customized database development services for business, government, and non-profit organizations. Our core competency is FileMaker Pro, where we hold FileMaker's highest certifications. With a team of 27 staff, we are capable of deploying both small and large solutions for a wide variety of customers. We service all modern versions of FileMaker Pro, FileMaker Server, and FileMaker Go (for the iPad and iPhone). We also deploy FileMaker databases to the web, and offer PHP/Web Development, iOS Programming, FileMaker Server Support, and Hosting Services.

 

http://www.rcconsulting.com/

Please feel free to contact us at support@rcconsulting.com

Looking for FM Starting Point free software download: http://www.fmstartingpoint.com

For More Free FileMaker Videos Check out Http://www.filemakerfree.com

Please Comment, Like & Share All of Our Videos.

Feel Free to Embed any of Our Videos on Your Blog or Website.

 

Watch a FileMaker Training Review Video Here:

https://www.youtube.com/watch?v=reoBiKXlv54

 

Follow Us on Your Favorite Social Media

https://www.facebook.com/FileMakerVideos

https://twitter.com/filemakervideos

https://plus.google.com/+FileMakerVideos/videos

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By Prasad Khandagale
      We are happy to announce the launch of the next FM Quizilla – Our Flagship product for FileMaker developers to practice for the FileMaker Certification exam. FM Quizilla supports aspiring developers who wish to be FileMaker 18 Certified. LEARN – EXPERIENCE – PRACTICE giving FileMaker 18 certification exam on your phone or tablet.
       
      What FM Quizilla offers?
      Even as FileMaker is reborn as Claris International Inc. and assumed a new brand identity -- MetaSys Software continues to bring to you the latest version , with all the features you have come to expect !
      FM Quizilla has got a well-researched question bank along with questions related to FileMaker 18. Features like Practice test, Historical Analysis, Reviewing Answers, Tracking your progress will all continue to help you with learning and preparation for certification.
       
      How can the users gain more from this app?
      Users can download the trial version of the app and explore all the app features and a limited number of questions.
       
      Note: Those who purchased the previous version of the app – FM Quizillaa for FileMaker 17 and FileMaker 16 can continue to use it.
       
      Happy Learning!
       
      For more info. https://www.metasyssoftware.com/fm-quizilla
    • By everythingFileMaker
      Over a year ago, I started an ambitious project; to develop a FileMaker solution where everything happens on a single screen. It has been much more work than I had anticipated but 8 projects later, it has been defined and refined to the poiint where it is now bulletproof and will work for any solution for any industry.
      On January 3, 2020 I will be releasing NautilusFM to the community under an open source (BSD) license so that anybody and everybody can benefit and learn from it. The release includes a comprehensive ebook with step-by-step instructions and an example file to illustrate all of the techniques and methodologies used; that example file could easily be used as a basis for projects and contains the basis functionality required for every business
      NautilusFM is a framework, a methodology for development.  To read the background story
      www.nautilusfm.com
      NautilusFM is NOT a FileMaker solution although the example file is.
      To find out exactly what NautilusFM is
      http://www.nautilusfm.com/whatis/
      If you have a company or organization and want to find out how NautilusFM can benefit you
      http://www.nautilusfm.com/fororgs/
      To watch a quick tour of the NautilusFM example file
      http://www.nautilusfm.com/videos/
      To get a copy of the completely unlocked and open Example file, please fill out the simple request form
      http://www.nautilusfm.com/example/
      As soon as the file is ready, you'll receive a copy of it via email.
      I'm excited to share it with the community.
    • By Will_Logic
      Hi, I am using the Base Elements plugin Execute SQL command to select SQL on a table in another FileMaker file. For a file with many fields and quite a lot data in some fields, this times as about 1 minute just for SQL SELECT command for 1,000 rows. I haven't used MBS (monkeybread software) plugin yet, but I wonder if anyone knows if it is significantly faster?
      I.e. BE_FileMakerSQL vs. MBS(FM.SQL.Execute..) - is one significantly faster?
      Here's the code to select 1,000 rows for reference, $timer_seconds comes as about 60 seconds here. If I export same table internally in FileMaker using the menu export to Excel, it takes 29 minutes for all 41,000 rows, so timing seems similar for the Base Elements SQL. (NB there is some flag going on here in the FileMaker database so internal export gets 41,000 rows but script SQL SELECT COUNT(*) gets 200,000 rows for same table, but I don't think that is relevant to my question).
       
      Set Variable [$time1; Value: Get(CurrentTimeUTCMilliseconds)] Set Variable [$part_ca; Value: BE_FileMakerSQL ( "SELECT * FROM Contact_ACTIVITY OFFSET 100000 ROWS FETCH FIRST 1000 ROWS ONLY" ; "&≠≠&" ; "EOR≠≠EOR" ; "DataContacts11" )] Set Variable [$timer_seconds; Value: (Get(CurrentTimeUTCMilliseconds) - $time1) / 1000] MBS command I think would be something like:
      MBS( "FM.SQL.Execute"; "DataContacts11"; "SELECT * FROM Contact_ACTIVITY OFFSET 100000 ROWS FETCH FIRST 1000 ROWS ONLY" ; ...delimiters here I'm assuming.. ) We only have base FileMaker here on machine I am using, which can run the Base Elements plugin, but to run MBS plugin, needs FileMaker Pro Advanced to install it I think, am getting several databases in roughly same FM format where script workspace disabled, hence need to use SQL select run from script in my own external FileMaker file. Might consider getting FMP Pro Advanced if MBS is faster.
      Tx any suggestions!
    • By Peter Barfield
      Well, I'm new to SQL and have used it in it's basic select  mode. 
      Now I have been asked too create a dashboard using data from different tables to display. Which on the most part is OK and working great.
      I have had a request for a top customer list for the month and previous month (say best 5 ranked from 1-5.) and not together so 2 seperate views
      I am able to pull customers and SUM totals (seperately)for the month using SELECT DISTINCT I am able to get a list of the customers for the month. How would you then get a total or SUM of the invoice amounts for the given month with the customer name and their total ? also is there a similar function to FRACTION in filemaker?
      Listed is my SQL Statement that just returns a ?
      Which I understand to mean a syntax error however, being a SQL "Virgin" any halp would be appreciated. I know I am able to do this natively through filemaker however, as I said this is for a dashboard that uses data from a number of tables.
      Here is my calc that is obviously wrong.
       
      Currently working with Filemaker 15 Advanced.
       
      Let ( [ 
      ReturnSub = "\n" ; 
      SQLResult = ExecuteSQL ( 
      "SELECT DISTINCT (a.\"Customer Name\"), SUM(a.\"InvoiceTotal\")
      FROM \"Invoices \" a
      WHERE a.\"Invoice Sub Total\" > ? AND a.\"InvoiceMonth\" = ? AND a.\"InvoiceYear\" = ? AND a.\"Job Status\" <> ?" 
      GROUP ON a.\"Customer Name\" ASC; 
      "    " ; "|*|" ; 

       "0" ; Month(Get(CurrentDate))-1 ; Year(Get(CurrentDate)); "Giveaway"

       ) ] ; 
      Substitute ( SQLResult ; [ ¶ ; ReturnSub ] ; [ "|*|" ; ¶ ]  )

      )
    • By everythingFileMaker
      https://firesidefilemaker.podbean.com/e/a-conversation-with-claris-part-2/
      This is Part 2 of a 2 part (90 minute) amazing conversation with Rick Kalman, Director of Product Management for FileMaker, and Robert Holsey, Senior Product Manager for FileMaker. Rick and Robert talk about, among other things, Claris Connect, the benefits of acquisition instead of strategic partnerships, save as XML, responsive layouts, Apple's influence, live database development, moving to a web first strategy and changes to the relationship graph. We are very honored that they took so much of their time to talk with us candidly and openly.
      Part 1 was released last Wednesday and has had over 700 downloads. Thanks to all for listening.  Steven Blackwell tweeted that it was an 'Exceptionally significant PodCast' and that 'All #FileMaker developers should listen.' 
      https://firesidefilemaker.podbean.com/e/a-conversation-with-claris-part-1/
      Follow us on iTunes 
      https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087?mt=2&app=itunes
      Follow us on Podbean
      https://firesidefilemaker.podbean.com
      or find us on YouTube by searching for Fireside FileMaker
      ~

×
×
  • Create New...

Important Information

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