Base Query says 'Syntax Error', but there is none

English
,
#1

I have a Base frontend to a MySQL 5.7 backend.

Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

I’m creating a query in Base:

select id artifactCalibration, artifact artifact, provider provider, date_format(date, '%m/%d/%y') date, notes notes
from artifactcalibrations

It won’t let me run or save the query, claiming there’s a syntax error. But there is no error. I can successfully run the sql directly. Anyone have any ideas how I can proceed?

#2

There is a contradiction:

or didn’t you use the direct mode of base?

#5

You are correct. I wasn’t using the direct mode. If I had, it would have provided more info.

#3

You are using a name of a function (DATE()) for a field. Won’t work without masking the field and the alias.

date_format("date", '%m/%d/%y') "date"
#4

Thanks! Since I’m rebuilding my database, I’ll definitely come up with a better, more descriptive name for that field.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.