Hi,
Has anyone tried to execute the CSV as database and ran the Update command? Even though the query is correct the the bot throws a syntactic error.
Error when using Update query on CSV
Userlevel 3
+7
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?
Userlevel 3
+7
Hi
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.
Userlevel 3
+7
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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.