Why does an error occur in a SQL query in Crystal Reports?

Question

SQL

Good afternoon, when creating a report in Crystal Reports for Visual Stduio, an error occurs when trying to save and execute an SQL query





. Why does it appear and how can I fix it?

Answer 1

I will make an assumption that you have fields of the DATE type in your selection and the system has Russian in the region settings.
In general, change * to explicitly indicate the fields and, if necessary, convert the date format.