HOW TO DELETE MULTIPLE ROWS FROM FUSION TABLE WITH DELETE QUERY?

387 views
Skip to first unread message

ΘΕΟΔΩΡΟΣ ΗΛΙΟΥ

unread,
Mar 27, 2015, 3:06:10 PM3/27/15
to mitappinv...@googlegroups.com
1) I m making an app with app inventor 2 and i want to Delete multiple rows from fusion table, but Delete query needs Rowid so it can Delete only 1 row every time.
Is there other way to do it?



Taifun

unread,
Mar 27, 2015, 3:11:44 PM3/27/15
to mitappinv...@googlegroups.com
unfortunately not, see also https://code.google.com/p/fusion-tables/issues/detail?id=417
Taifun

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

SteveJG

unread,
Mar 27, 2015, 5:23:26 PM3/27/15
to mitappinv...@googlegroups.com
If you just need to update the Fusion Table, you might find it easier  to access the table from your PC and use the FT controls there to delete rows etc.

Unfortunately, as indicated by Taifun, deleting multiple rows from the Table using Delete query from your Android device means you have to delete one row at a time.

Hopefully, this may be "the other way."      Do return to this thread; someone might post an alternative solution we are not aware of.

Regards,
Steve

Taifun

unread,
Mar 27, 2015, 5:31:54 PM3/27/15
to mitappinv...@googlegroups.com
Is there other way to do it?
you will have more flexibility, if you use a MySQL database on your own webserver, see also 
Taifun
Reply all
Reply to author
Forward
0 new messages