BASE SQL SIMPLE DELETE QUERY FAILS

[davidsharpe]

Version: 5.2.2.2 (x64)
Build ID: 8f96e87c890bf8fa77463cd4b640a2312823f3ad
CPU Threads: 2; OS Version: Windows 6.19; UI Render: GL;

---

THIS QUERY WORKS
SELECT “flddata” FROM “tbldata” WHERE ( “flddata” LIKE ‘%stars%’ OR “flddata” LIKE ‘%/%/%’ )

---

THIS QUERY
DELETE FROM “tbldata” WHERE ( “flddata” LIKE ‘%stars%’ OR “flddata” LIKE ‘%/%/%’ )

RETURNS THE ERROR
"The given command is net a SELECT statement.
Only queries are allowed.
DELETE FROM “tbldata” WHERE ( “flddata” LIKE ‘%stars%’ OR “flddata” LIKE ‘%/%/%’ ) "

[Ratslinger]

I imagine you are doing this from a Query window. Only Select statements are allowed there. Other statements can be performed under the menu item Tools->SQL... form the opening Base screen.

[jimk]

Update queries are possible - see https://stackoverflow.com/a/34562420/5100564.