|
Die klassischen Dateitypen können ab Januar 2021 nicht mehr verwendet werden. Sie können Ihre klassischen Dateien übertragen oder eine PDF herunterladen. Weitere Informationen

DML in WData Table?

Beantwortet
Demo anfordern

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

Kommentare

1 Kommentar

Datum Stimmen
  • 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

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.