|
Klassiske filtyper er ikke lenger tilgjengelige for bruk fra og med januar 2021. Du kan overføre klassiske filer eller laste ned en PDF-fil. Finn ut mer

DML in WData Table?

Besvart
Be om 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

Dato Stemmer
  • 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

Logg på for å legge inn en kommentar.