2014년 12월 11일 목요일

Query with fusion table

Hi guys, i'm trying to make a simple app with app inventor 2. This app help you to find some kind of gift for friends, parents or girlfriend/boyfriend. But i have a problem. I used a fusion table to store the gift list ( the table is: Description, Recurrence, Relationship, Gender, Age, Price ). I have a screen where the user insert these data: Minimum price, max price, Gender, Age, Recurrence and Relationship.. The query is like "SELECT Description FROM gift WHERE Recurrence = "users's recurrence" AND Relationship = "user's relationship" AND Age ="user's age" AND minimum price < "price" AND max price > "price". The result will be the "Description" column. But i'm not able to make the query with the blocks. I tried to follow the tutorial, but they explain how to insert into a fusion table, not how to select from a fusion table. The result of the query will be displayed in a notification or similar. Can someone help me with the query? 



this might help

see also 

It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.



Hi, thanks! I found how to make a select query, thank you so much


댓글 없음:

댓글 쓰기