I've recently upgraded to SQL Assistant v14.0. In v13.10 I had no trouble running the following query (statement by statment). Now I'm having trouble because I get an error that says "Error executing query for record 1: 3706: Syntax error: expected something between ')' and the integer '1'.
Here is the sql:
I was just having the same issue and even tried the option to enclose column data in single/double quotes and neither worked. I had just imported the file 15 mins earlier but noticed a small error so I dropped it and tried to reload but kept getting this error.
Eventually I was able to solve it by moving the "Insert" statement into a new query window "Ctrl + N". Apparently SQLA doesn't like having the Import statement mixed in with other SQL statements even if you have "submit only the highlighted text" option set. The first time I had imported it was in a different window then I moved it over to one with other statements and kept getting errors. Once I moved it back into it's own window it ran perfectly fine. Not sure why this happens, must be something related to the way it functions when set to Import mode.
Hope this helps.
I have faced similar kind of error.
While importing data from SQL Assistance, RDBS error has been encountered.
Error:- Error executing query for record 1: 3706: Syntax error: expected something between ')' and
But when i opened new window and ran the same import statement, it went fine.
Can anyone have an idea on this?