{"id":5520,"date":"2013-07-22T07:29:21","date_gmt":"2013-07-22T14:29:21","guid":{"rendered":"http:\/\/www.seedcode.com\/?p=5520"},"modified":"2013-07-22T07:29:21","modified_gmt":"2013-07-22T14:29:21","slug":"new-sqlexplorer","status":"publish","type":"post","link":"https:\/\/seedcode.com\/new-sqlexplorer\/","title":{"rendered":"New SQLexplorer"},"content":{"rendered":"

Jason has just completed a major new version of SQLexplorer<\/a> that makes it easier for beginners and pros alike to write better queries.<\/p>\n

If you haven’t used SQLexplorer before, it writes FileMaker SQL queries for you as you fill out a simple form using FileMaker terms your familiar with (sorts, relationships, etc). You can then test your query right in SQLexplorer before copying and pasting it into your solution. Queries are clearly commented and abstracted to survive field renaming.<\/p>\n

I can tell you this has sped up our own work considerably as we now don’t have to think hard (and type correctly) every time we write a query.<\/p>\n

If you’ve been using SQLexplorer for a while, checkout the screenshots to see what’s new.<\/p>\n

\"Review<\/a>
Review query results in new HTML5 powered portals with column resizing and sorting.<\/figcaption><\/figure><\/div>\n
\"refinesmall\"<\/a>
Refine your results then paste refined criteria back into your queries.<\/figcaption><\/figure><\/div>\n
\"schemasmall\"<\/a>
Run queries against FileMaker’s built-in schema tables.<\/figcaption><\/figure><\/div>\n
\"Optionally<\/a>
Optionally export column headers that respect translated field names using “as”.<\/figcaption><\/figure><\/div>\n

SQLexplorer is still free and completely unlocked. Learn more and download the new version here: \u00a0get\u00a0SQLexplorer<\/a>. Jason has also recorded a great video<\/a> of the new features in action.<\/p>\n","protected":false},"excerpt":{"rendered":"

Jason has just completed a major new version of SQLexplorer that makes it easier for beginners and pros alike to write better queries. If you haven’t used SQLexplorer before, it writes FileMaker SQL queries for you as you fill out a simple form using FileMaker terms your familiar with (sorts, relationships, etc). You can then test your query right in SQLexplorer before copying and pasting it into your solution. Queries are clearly commented and abstracted to survive field renaming. I can tell you this has sped up our own work considerably as we now don’t have to think hard (and type correctly) every time we write a query. If you’ve been using SQLexplorer for a while, checkout the screenshots to see what’s new. SQLexplorer is still free and completely unlocked. Learn more and download the new version here: \u00a0get\u00a0SQLexplorer. Jason has also recorded a great video of the new features in action.<\/p>\n","protected":false},"author":1,"featured_media":5529,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[17,18,23],"class_list":["post-5520","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-filemaker-12","tag-filemaker-sql","tag-javascript"],"yoast_head":"\nNew SQLexplorer - SeedCode<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/seedcode.com\/new-sqlexplorer\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New SQLexplorer - SeedCode\" \/>\n<meta property=\"og:description\" content=\"Jason has just completed a major new version of SQLexplorer that makes it easier for beginners and pros alike to write better queries. If you haven’t used SQLexplorer before, it writes FileMaker SQL queries for you as you fill out a simple form using FileMaker terms your familiar with (sorts, relationships, etc). You can then test your query right in SQLexplorer before copying and pasting it into your solution. Queries are clearly commented and abstracted to survive field renaming. I can tell you this has sped up our own work considerably as we now don’t have to think hard (and type correctly) every time we write a query. If you’ve been using SQLexplorer for a while, checkout the screenshots to see what’s new. SQLexplorer is still free and completely unlocked. Learn more and download the new version here: \u00a0get\u00a0SQLexplorer. Jason has also recorded a great video of the new features in action.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/seedcode.com\/new-sqlexplorer\/\" \/>\n<meta property=\"og:site_name\" content=\"SeedCode\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/seedcoder\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-22T14:29:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/seedcode.com\/wp-content\/uploads\/2013\/07\/schemasmall.png\" \/>\n\t<meta property=\"og:image:width\" content=\"407\" \/>\n\t<meta property=\"og:image:height\" content=\"220\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"seedcode\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dayback\" \/>\n<meta name=\"twitter:site\" content=\"@dayback\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"seedcode\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/seedcode.com\/new-sqlexplorer\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/seedcode.com\/new-sqlexplorer\/\"},\"author\":{\"name\":\"seedcode\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/af42f3f8cbfc8652fb0ffbb3f46f260f\"},\"headline\":\"New SQLexplorer\",\"datePublished\":\"2013-07-22T14:29:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/seedcode.com\/new-sqlexplorer\/\"},\"wordCount\":230,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/seedcode.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/new-sqlexplorer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2013\/07\/schemasmall.png\",\"keywords\":[\"FileMaker 12\",\"FileMaker SQL\",\"javascript\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/seedcode.com\/new-sqlexplorer\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/seedcode.com\/new-sqlexplorer\/\",\"url\":\"https:\/\/seedcode.com\/new-sqlexplorer\/\",\"name\":\"New SQLexplorer - SeedCode\",\"isPartOf\":{\"@id\":\"https:\/\/seedcode.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/seedcode.com\/new-sqlexplorer\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/new-sqlexplorer\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2013\/07\/schemasmall.png\",\"datePublished\":\"2013-07-22T14:29:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/seedcode.com\/new-sqlexplorer\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/seedcode.com\/new-sqlexplorer\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/new-sqlexplorer\/#primaryimage\",\"url\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2013\/07\/schemasmall.png\",\"contentUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2013\/07\/schemasmall.png\",\"width\":407,\"height\":220},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/seedcode.com\/new-sqlexplorer\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/seedcode.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New SQLexplorer\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/seedcode.com\/#website\",\"url\":\"https:\/\/seedcode.com\/\",\"name\":\"SeedCode\",\"description\":\"Build the Software You've Always Wanted\",\"publisher\":{\"@id\":\"https:\/\/seedcode.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/seedcode.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/seedcode.com\/#organization\",\"name\":\"SeedCode\",\"url\":\"https:\/\/seedcode.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png\",\"contentUrl\":\"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png\",\"width\":595,\"height\":189,\"caption\":\"SeedCode\"},\"image\":{\"@id\":\"https:\/\/seedcode.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/seedcoder\",\"https:\/\/x.com\/dayback\",\"https:\/\/www.linkedin.com\/company\/seedcode\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/af42f3f8cbfc8652fb0ffbb3f46f260f\",\"name\":\"seedcode\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/seedcode.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f0c386c5b845ee7fe111b36b2d87e983811f1f549682de9597a934b9dfd45469?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f0c386c5b845ee7fe111b36b2d87e983811f1f549682de9597a934b9dfd45469?s=96&d=mm&r=g\",\"caption\":\"seedcode\"},\"sameAs\":[\"https:\/\/seedcode.com\"],\"url\":\"https:\/\/seedcode.com\/author\/seedcode\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New SQLexplorer - SeedCode","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/seedcode.com\/new-sqlexplorer\/","og_locale":"en_US","og_type":"article","og_title":"New SQLexplorer - SeedCode","og_description":"Jason has just completed a major new version of SQLexplorer that makes it easier for beginners and pros alike to write better queries. If you haven’t used SQLexplorer before, it writes FileMaker SQL queries for you as you fill out a simple form using FileMaker terms your familiar with (sorts, relationships, etc). You can then test your query right in SQLexplorer before copying and pasting it into your solution. Queries are clearly commented and abstracted to survive field renaming. I can tell you this has sped up our own work considerably as we now don’t have to think hard (and type correctly) every time we write a query. If you’ve been using SQLexplorer for a while, checkout the screenshots to see what’s new. SQLexplorer is still free and completely unlocked. Learn more and download the new version here: \u00a0get\u00a0SQLexplorer. Jason has also recorded a great video of the new features in action.","og_url":"https:\/\/seedcode.com\/new-sqlexplorer\/","og_site_name":"SeedCode","article_publisher":"https:\/\/www.facebook.com\/seedcoder","article_published_time":"2013-07-22T14:29:21+00:00","og_image":[{"width":407,"height":220,"url":"https:\/\/seedcode.com\/wp-content\/uploads\/2013\/07\/schemasmall.png","type":"image\/png"}],"author":"seedcode","twitter_card":"summary_large_image","twitter_creator":"@dayback","twitter_site":"@dayback","twitter_misc":{"Written by":"seedcode","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/seedcode.com\/new-sqlexplorer\/#article","isPartOf":{"@id":"https:\/\/seedcode.com\/new-sqlexplorer\/"},"author":{"name":"seedcode","@id":"https:\/\/seedcode.com\/#\/schema\/person\/af42f3f8cbfc8652fb0ffbb3f46f260f"},"headline":"New SQLexplorer","datePublished":"2013-07-22T14:29:21+00:00","mainEntityOfPage":{"@id":"https:\/\/seedcode.com\/new-sqlexplorer\/"},"wordCount":230,"commentCount":4,"publisher":{"@id":"https:\/\/seedcode.com\/#organization"},"image":{"@id":"https:\/\/seedcode.com\/new-sqlexplorer\/#primaryimage"},"thumbnailUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2013\/07\/schemasmall.png","keywords":["FileMaker 12","FileMaker SQL","javascript"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/seedcode.com\/new-sqlexplorer\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/seedcode.com\/new-sqlexplorer\/","url":"https:\/\/seedcode.com\/new-sqlexplorer\/","name":"New SQLexplorer - SeedCode","isPartOf":{"@id":"https:\/\/seedcode.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/seedcode.com\/new-sqlexplorer\/#primaryimage"},"image":{"@id":"https:\/\/seedcode.com\/new-sqlexplorer\/#primaryimage"},"thumbnailUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2013\/07\/schemasmall.png","datePublished":"2013-07-22T14:29:21+00:00","breadcrumb":{"@id":"https:\/\/seedcode.com\/new-sqlexplorer\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/seedcode.com\/new-sqlexplorer\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/new-sqlexplorer\/#primaryimage","url":"https:\/\/seedcode.com\/wp-content\/uploads\/2013\/07\/schemasmall.png","contentUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2013\/07\/schemasmall.png","width":407,"height":220},{"@type":"BreadcrumbList","@id":"https:\/\/seedcode.com\/new-sqlexplorer\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/seedcode.com\/"},{"@type":"ListItem","position":2,"name":"New SQLexplorer"}]},{"@type":"WebSite","@id":"https:\/\/seedcode.com\/#website","url":"https:\/\/seedcode.com\/","name":"SeedCode","description":"Build the Software You've Always Wanted","publisher":{"@id":"https:\/\/seedcode.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/seedcode.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/seedcode.com\/#organization","name":"SeedCode","url":"https:\/\/seedcode.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/#\/schema\/logo\/image\/","url":"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png","contentUrl":"https:\/\/seedcode.com\/wp-content\/uploads\/2022\/12\/SeedCodeLogo.png","width":595,"height":189,"caption":"SeedCode"},"image":{"@id":"https:\/\/seedcode.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/seedcoder","https:\/\/x.com\/dayback","https:\/\/www.linkedin.com\/company\/seedcode\/"]},{"@type":"Person","@id":"https:\/\/seedcode.com\/#\/schema\/person\/af42f3f8cbfc8652fb0ffbb3f46f260f","name":"seedcode","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/seedcode.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f0c386c5b845ee7fe111b36b2d87e983811f1f549682de9597a934b9dfd45469?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f0c386c5b845ee7fe111b36b2d87e983811f1f549682de9597a934b9dfd45469?s=96&d=mm&r=g","caption":"seedcode"},"sameAs":["https:\/\/seedcode.com"],"url":"https:\/\/seedcode.com\/author\/seedcode\/"}]}},"_links":{"self":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts\/5520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/comments?post=5520"}],"version-history":[{"count":0,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/posts\/5520\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/media\/5529"}],"wp:attachment":[{"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/media?parent=5520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/categories?post=5520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/seedcode.com\/wp-json\/wp\/v2\/tags?post=5520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}