AnsweredAssumed Answered

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

Question asked by Fred(CH) on Mar 17, 2015
Latest reply on Mar 17, 2015 by 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

Outcomes