DML in WData Table?
AnsweredIs it possible to perform basic DML statements such as insert into or update in WData tables via Chains / API? What are my options for modifying data in a Table? I know I can import a file into a table. But if I now want to update all rows where column X = some value? As far as I understand the API "Update a single table" is for DDL updates, not DML.
-
Hi Waldo, To ensure data integrity, the SQL editor supports read-only statements like SELECT, but not read/write statements like INSERT or DELETE. If you would like to update data in a Wdata table, you'll need to identify the file it is associated to, unimport/delete the file from the table, then upload a new file containing the correction(s) as well as the all old unchanged data that was in the original file.
0Please sign in to leave a comment.
Comments
1 comment