|
A partire da gennaio 2021, i tipi di file classici non potranno più essere utilizzati. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

DML in WData Table?

Con risposta
Richiedi una 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

Commenti

1 commento

Data Voti
  • 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

Accedi per aggiungere un commento.