{"id":2625,"date":"2013-09-04T18:02:05","date_gmt":"2013-09-04T18:02:05","guid":{"rendered":"https:\/\/gofilemaker.de\/?p=2625"},"modified":"2022-03-28T16:18:10","modified_gmt":"2022-03-28T15:18:10","slug":"exporty-sqlquery-a-nazvy-poli-s-podtrzenim","status":"publish","type":"post","link":"https:\/\/gofilemaker.de\/cs\/2013\/09\/exporty-sqlquery-a-nazvy-poli-s-podtrzenim\/","title":{"rendered":"SQLQueryExecute a n\u00e1zvy pol\u00ed s podtr\u017e\u00edtky"},"content":{"rendered":"<p><img decoding=\"async\" class=\"alignleft size-full wp-image-2324\" src=\"https:\/\/gofilemaker.de\/wp-content\/uploads\/gofilemaker_kurztipp2.jpg\" alt=\"Rychl\u00fd tip pro FileMaker: SQL dotazy a n\u00e1zvy pol\u00ed\" width=\"150\" height=\"150\">FileMaker 12 obsahuje funkci \"SQLQueryExecute\", kter\u00e1 je v ka\u017edodenn\u00ed praxi FileMakeru velmi u\u017eite\u010dn\u00e1. Tuto funkci lze velmi dob\u0159e vyu\u017e\u00edt nap\u0159\u00edklad k vytv\u00e1\u0159en\u00ed seznam\u016f hodnot z hodnot pol\u00ed jin\u00fdch tabulek bez nutnosti vztahu. Ve spojen\u00ed s funkc\u00ed \"MagicValueList\", kterou p\u0159edstavil Arnold Kegebein v \u010dasopisech FileMaker 201301 a 201302, se otev\u00edraj\u00ed prakticky nep\u0159edstaviteln\u00e9 mo\u017enosti, pokud jde o FileMaker a seznamy hodnot.<\/p>\n<p>Pro tento \u00fa\u010del se obvykle pou\u017e\u00edvaj\u00ed pouze jednoduch\u00e9 <a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/sql\/\" target=\"_self\" title=\"Co je SQL a k \u010demu se pou\u017e\u00edv\u00e1? SQL (Structured...\" class=\"encyclopedia\">SQL<\/a>-jsou vy\u017eadov\u00e1ny dotazy, jako nap\u0159. <em>SELECT n\u00e1zev pole FROM <a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/tabulka\/\" target=\"_self\" title=\"Co je to tabulka v aplikaci FileMaker? Tabulka se ve FileMakeru pou\u017e\u00edv\u00e1 k...\" class=\"encyclopedia\">Tabulka<\/a> WHERE krit\u00e9rium=xyz<\/em>. Takov\u00e9 dotazy funguj\u00ed ve FileMakeru 12 bez probl\u00e9m\u016f - alespo\u0148 pokud n\u00e1zvy p\u0159\u00edslu\u0161n\u00fdch pol\u00ed neobsahuj\u00ed na za\u010d\u00e1tku podtr\u017e\u00edtko. Mnoho v\u00fdvoj\u00e1\u0159\u016f aplikace FileMaker v\u0161ak ozna\u010duje kl\u00ed\u010dov\u00e1 pole podtr\u017e\u00edtkem jako p\u0159edponou, tak\u017ee se zobrazuj\u00ed na za\u010d\u00e1tku definic pol\u00ed a diagramu vztah\u016f. Bohu\u017eel ve v\u0161ech p\u0159edchoz\u00edch verz\u00edch FileMakeru je chyba, kter\u00e1 znamen\u00e1, \u017ee dotazy SQL s takov\u00fdmi n\u00e1zvy pol\u00ed nefunguj\u00ed.<!--more Weiterlesen &gt;&gt;&gt;--><\/p>\n<h2>V\u00fdsledek = \"?\"<\/h2>\n<p>Pokud je na za\u010d\u00e1tku n\u00e1zvu pole podtr\u017e\u00edtko, funkce \"SQLQueryExecute\" vr\u00e1t\u00ed jako v\u00fdsledek pouze otazn\u00edk. Nem\u011bjte v\u0161ak obavy: existuj\u00ed zp\u016fsoby, jak tuto chybu obej\u00edt.<\/p>\n<p>Praktick\u00fd p\u0159\u00edklad: M\u00e1me z\u00e1kazn\u00edka<a href=\"https:\/\/gofilemaker.de\/cs\/glosar\/databaze\/\" target=\"_self\" title=\"Co je to datab\u00e1ze? Datab\u00e1z\u00ed (datab\u00e1zov\u00fdm syst\u00e9mem, DBS) se rozum\u00ed...\" class=\"encyclopedia\">Datab\u00e1ze<\/a>se kter\u00fdmi jsou adresy v jin\u00e9 tabulce propojeny vztahem 1:n. P\u0159\u00edslu\u0161n\u00e1 standardn\u00ed adresa z\u00e1kazn\u00edka je v poli &lt;&gt; ozna\u010dena hodnotou \"1\", v\u0161echny ostatn\u00ed adresy toto ozna\u010den\u00ed neobsahuj\u00ed. Pokud bychom nyn\u00ed cht\u011bli zjistit ID p\u0159\u00edslu\u0161n\u00e9ho datov\u00e9ho z\u00e1znamu adresy z datab\u00e1ze z\u00e1kazn\u00edk\u016f pomoc\u00ed SQL dotazu, dotaz by vypadal n\u00e1sledovn\u011b<\/p>\n<pre>SQLQueryExecute(\"SELECT _pk_adresa_ID FROM adresy WHERE sta.default=1\"; \"\"; \"\")<\/pre>\n<p>Tento dotaz by nefungoval a jako v\u00fdsledek by vr\u00e1til pouze otazn\u00edk. Nen\u00ed to v\u0161ak zp\u016fsobeno chybou v SQL dotazu, ale FileMakeru se v tomto okam\u017eiku prost\u011b nel\u00edb\u00ed podtr\u017e\u00edtko v n\u00e1zvu pole &lt;&gt;.<\/p>\n<p>To lze napravit uveden\u00edm n\u00e1zvu pole - na tomto m\u00edst\u011b d\u011bkujeme za odpov\u00eddaj\u00edc\u00ed tip z webu <a href=\"https:\/\/www.filemaker-magazin.de\/forum\/beitrag\/131682\" target=\"_blank\" rel=\"noopener\"><strong>F\u00f3rum<\/strong><\/a> \u010dasopisu FileMaker od Otmara Kramise. Pokud dotaz uprav\u00edte takto:<\/p>\n<pre>SQLQueryExecute(\"SELECT \\\"_pk_adresa_ID\\\" FROM adresy WHERE sta.default=1\"; \"\"; \"\")<\/pre>\n<p>...pak to bez probl\u00e9m\u016f funguje i ve FileMakeru :-)<\/p>\n<h2>Dodatek: Tipy pro robustn\u00ed v\u00fdvoj dotaz\u016f SQL<\/h2>\n<p>V\u00fdvoj\u00e1\u0159 aplikace FileMaker <a href=\"https:\/\/gofilemaker.de\/cs\/author\/karo\/\">Robert Kaiser<\/a> doporu\u010duje v jin\u00e9m f\u00f3ru p\u0159\u00edsp\u011bvek <a href=\"http:\/\/www.filemakerhacks.com\/?p=4924\" target=\"_blank\" rel=\"noopener\"><strong>\u010cl\u00e1nky z webu filemakerhacks.com<\/strong><\/a>kter\u00fd popisuje, jak lze dotazy SQL v aplikaci FileMaker vytv\u00e1\u0159et tak, aby spr\u00e1vn\u011b fungovaly i po p\u0159ejmenov\u00e1n\u00ed nebo zm\u011bn\u011b vztah\u016f \u010di pol\u00ed. Toto \u0159e\u0161en\u00ed tak\u00e9 odstra\u0148uje popsan\u00e9 probl\u00e9my s podtr\u017e\u00edtky na za\u010d\u00e1tku n\u00e1zv\u016f pol\u00ed. \u010cl\u00e1nek popisuje pou\u017eit\u00ed vlastn\u00edch funkc\u00ed, pomoc\u00ed kter\u00fdch lze SQL dotazy ve FileMakeru vyv\u00edjet mimo\u0159\u00e1dn\u011b robustn\u011b. Proto stoj\u00ed za to se do tohoto t\u00e9matu pono\u0159it hloub\u011bji :-)<\/p>","protected":false},"excerpt":{"rendered":"<p>FileMaker 12 beinhaltet mit &#8222;SQLQueryAusf\u00fchren&#8220; eine Funktion, die in der t\u00e4glichen FileMaker-Praxis \u00e4u\u00dferst hilfreich ist. Sehr gut gebrauchen kann man diese Funktion zum Beispiel, um Wertelisten aus Feldwerten anderer Tabellen zu erstellen, ohne da\u00df daf\u00fcr eine Beziehung notwendig ist. Im Zusammenhang mit der von Arnold Kegebein in den FileMaker-Magazinen 201301 und 201302 vorgestellten Funktion &#8222;MagicValueList&#8220; [&hellip;]<\/p>\n","protected":false},"author":187,"featured_media":32984,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":10,"footnotes":""},"categories":[798,1,5],"tags":[],"class_list":["post-2625","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-custom-functions","category-filemakerpro","category-tipps-anleitungen"],"_links":{"self":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/posts\/2625","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/users\/187"}],"replies":[{"embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/comments?post=2625"}],"version-history":[{"count":0,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/posts\/2625\/revisions"}],"wp:attachment":[{"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/media?parent=2625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/categories?post=2625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gofilemaker.de\/cs\/wp-json\/wp\/v2\/tags?post=2625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}