|
Klassiska filtyper är inte längre tillgängliga för användning från och med januari 2021. Du kan överföra dina klassiska filer eller ladda ner en PDF. Läs mer

DML in WData Table?

Besvarat
Begär demo

Is 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.

0

Kommentarer

1 kommentar

Datum Röster
  • Jeff Hickey

    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.

    0

Du måste logga in om du vill lämna en kommentar.