About fusion table

[Denise Ong]

Hi may i know how do i control the fusion table from refreshing out the same data . Because at first i put this data in tiny db and put it as a form of fusion table . When i go press the chart screen , it will just have another row which has the same data. how do i prevent it from repeating the same data ? Thankyou. 

[Taifun]

first send a SELECT statement to the table like this

SELECT * FROM <tableid> WHERE Date = <date you like to insert> AND Joint = 'joint you like to insert' AND ROM = <rom you like to insert> AND Result = <result you like to insert>

then get back the result of the query in the fusiontable control got result event, there are 2 possible results:

1. you get only the header row of the table back, which means, the row still does not exist, then send an INSERT statement to the table

2. you get the header row and a data row back, which means, the row already is there, then do nothing

Taifun

---

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

[Denise Ong]

Sorry because im a beginner for this . I dont quite understand what do you mean ):

[Denise Ong]

And also all this data is not fixed , it may changes . I couldn't jus select the date = something right??

[Taifun]

you should do it step by step

it seems to be, you are trying a lot of things in parallel and then you get lost easily

concentrate always on the next step, test that step and only if you got this working, then continue to the next step

see also 

Top 5 Tips: How to learn App Inventor

in this case the first step is to find out, if the row you like to insert is already available in the table

SELECT * FROM <tableid> WHERE Date = <date you like to insert> AND Joint = 'joint you like to insert' AND ROM = <rom you like to insert> AND Result = <result you like to insert>

and if you get an error, then first see here 

Frequently Made Errors with Fusiontables and how to fix them

there is also a chapter "I tried everything, what can I do now"...

If you checked for all the Frequent Made Errors and the error message doesn't tell you anything to fix this, open a new thread in the MIT App Inventor forum and add a screenshot of your SQL statement including the "Do it" result and a screenshot of your error message and I will try to help you. Thank you.       

let's first continue with this task and if you get this running, then let's take a look at the DELETE task

and don't hesitate to take a look into https://developers.google.com/fusiontables/docs/v2/sql-reference

Taifun