CSV as a database?

Are you opening it via Excel, or using a DB connector? 
CSV files are text files and updating a line via SQL might not be supported?

Hi @jon.stueveapeople ,

I was trying this with SQL query and it all worked well and updated the csv. Suddenly, there popped an error mentioning syntactic error. Insert and Select query works well. Due to project timelines i had to change the csv files to excel and run the queries and get things completed.

One thing to check, if your query is dynamic whether the inputs to the query contain valid tokens. Might add a line to log the query to a file, so you can check syntax/completeness.