I have encountered a problem when trying to insert/update a record in a Retool database table while using the SQL mode instead of GUI mode. I have the table BPlus_Anschriften in the Retool database and successfully inserted/updated the records in this table using the GUI mode. Now I try to do the same in SQL mode and it doesn't work.
Reading the data from the table works fine:
SELECT * FROM "BPlus_Anschriften" WHERE "AdrNr" = 79273 AND "AnsNr" = 0
But when trying to update this record with
UPDATE "BPlus_Anschriften" SET "Na2" ='TEST' WHERE "AdrNr" = 79273 AND "AnsNr" = 0
I just get the following error:"syntax error at or near "UPDATE ""
The same happens when I try to insert a new record.
INSERT INTO "BPlus_Anschriften" ("AdrNr", "AnsNr", "Na2") VALUES (11111, 0, 'TEST')
When using a different resource, like a BIG QUERY table, these queries work, but not with the Retool database.
I tried the tablename with and without quotation marks, it does not work in any of the cases. These are just basic insert and update queries. Any idea what the problem could be?
Is it maybe not possible to write into the Retool database while using SQL mode?