Hope you can help me with an error message that appears when executing functions from the Functions' Manager in Studio.
No matter which Function I execute, I am obtaining exactly the same "Bad Request error". The error message is showing some previous commands I ran from the Browse tab, with no reference at all to the actual Function.
In order to show the problem, I wrote the simplest function as an example:
Here is the detail of the error, which include some previous querys I ran from the Browse tab.
"reason": "Bad request",
"content": "ScriptManager: error <eval>:58:7 Expected ; but found yearmonth\r\nselect yearmonth.substring(0, 4), yearmonth.right(2) from yearmonth\r\n ^ in <eval> at line number 58 at column number 7.\nFunction randomedges(nombreclase,nombreclaseedges):\n\n 53: \n 54: //selection of months\n 55: var text=\"insert into yearmonth from select from (select from (select distinct(createdat1.format('yyyy-MM')) as yearmonth from Rolein) order by yearmonth)\";\n 56: var yearmonth=g.command(\"sql\",text);\n 57: \n 58: >>> select yearmonth.substring(0, 4), yearmonth.right(2) from yearmonth\n 59: \n 60: g.command(\"sql\",\"UPDATE yearmonth SET year=yearmonth.substring(0, 4)\")\n 61: g.command(\"sql\",\"UPDATE yearmonth SET month=yearmonth.right(2)\")\n 62: \n 63: }\n"
If the problem is somewhat related with the ScriptManager, is there a way to reset it in someway? I have already restarted my browser, also tried by restarting the server, but the problem remains.
Thanks in advance,