FusionTable delete statement problem

[Ryan Cheung]

I would like to delete the first row. But fail with my delete statement. I searched example from tutorial. But only have example about "delete from single condition" . 

I set the query to 

DELETE FROM TableID WHERE GroupID='001' and Phone='66'

But fail.

Is it only able to delete by ROWID?

Ryan

[Taifun]

Is it only able to delete by ROWID?

yes, therefore first send a SELECT statement to the table to get the ROWID, then send the DELETE statement to the table using that ROWID

Taifun

---

Trying to push the limits of App Inventor! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun. 

[Ryan Cheung]

Thanks Taifun,

I found the solution.

Ryan