Hi Developers
When i execute sql statement “SET @VARIABLE = 0;” in script report.
I get error
ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘select\n\t\t\torder_year,\n\t\t\tproject_type,\n\t\t\tproject_number,\n\t\t\tproject_name,\n\t\t\tit’ at line 3”)
After that, I removed it and execute passed.
Can I set variable in sql statment ?
Kind Regards,
Worawat Pansawat