3 Replies Latest reply on Mar 17, 2015 8:07 AM by Fred(CH)

    Date syntax error in french's FM 13 SQL Reference Guide

    Fred(CH)

      Summary

      Date syntax error in french's FM 13 SQL Reference Guide

      Product

      FileMaker Pro

      Version

      2013 Guide / Edition 01

      Operating system version

      N/A

      Description of the issue

      At page 24, about syntax of CONSTANTS, and SQL-92 date FORMAT, the Year and the Day are reversed. Also, the term TIME and TIMESTAMP shouldn't have been traduced in french.

      Steps to reproduce the problem

      Go to the top of page 24 (FRENCH)

      Expected result

      THE GUIDE MUST STATE :

      FileMaker accepte également les formats de date et d'heure ISO syntaxe SQL-92 sans accolades :
      • DATE 'AAAA-MM-JJ'
      • TIME 'HH:MM:SS'
      • TIMESTAMP 'AAAA-MM-JJ HH:MM:SS'
      La fonction EXECUTE SQL de FileMaker Pro n'accepte que les formats de date et d'heure ISO syntaxe SQL-92 sans accolades.

      Actual result

      THE GUIDE ACTUALLY STATE :

      FileMaker accepte également les formats de date et d'heure ISO syntaxe SQL-92 sans accolades :
      • DATE 'JJ-MM-AAAA'
      • HEURE 'HH:MM:SS'
      • HORODATAGE 'JJ-MM-AAAA HH:MM:SS'
      La fonction EXECUTE SQL de FileMaker Pro n'accepte que les formats de date et d'heure ISO syntaxe SQL-92 sans accolades.

      Exact text of any error message(s) that appear

      N/A

      Configuration information

      N/A

      Workaround

      N/A