AI2 Inventor Forum News: 07/29/17

2017년 7월 29일 토요일

HELP ME! How to exchange image.

Good Evening. I just wanted to know how to 2 image exchange in app inventor. When light dependent resistor sends high value of data to app it will display the image I set for sunny but when it is raining and the app receives data from rain sensor, the image will change into raining.

Just do the same as you have done with your text label (Sunny or Shady) but use the image.picture block instead and feed it the correct image?

2 sensors are working. so if it is raining the rain sensor will sends data to app and then i want to show the image raining and then when rain sensor stop sending data and no rain and the ldr receives data that it is sunny the raining image will be sunny image.

Unless I am missing something here:

See aia

weather.aia

when rain sensor stop sending data and no rain

So the rain sensor will send no data (and therefore have no events trigger?) if there is no rain?

That would call for a Watchdog Timer design, where you keep a TinyDB tag msLastRainDrop with the last

time (in milliseconds from 1970) that the rain sensor event triggered, and a repeating clock

that checks Clock1.Now() in milliseconds against the TinyDB value, to see if enough time has passed

(1 minute = 60000 ms)

since the last raindrop to announce there's no rain.

When a rain drop arrives, set the TinyDB value to Now in milliseconds, and announce it's raining.

The Clock component is in the Sensors drawer.

--
refer to: search results for HELP ME! How to exchange image.

--

How do you get the ROWID from a fusion table?

I searched the official fusion table guide made by google, but I can't figure out what query command I'm supposed to send to get a row id. I want to search based on a "username" entered by the user. Once I found the row id, I want to use it to retrieve the user's high score, profile pic, and what-not from that row.

Is there even a possible way of getting the row id? Also, am I going about my little login system all wrong? Thanks.

for SELECT statements you do not need the rowid

just send the following query

SELECT * FROM <tableid> WHERE username = 'entered user name in the textbox'

and if you later need the rowid to update or delete a row, just send the following query to get the rowid

SELECT ROWID FROM <tableid> WHERE username = 'entered user name in the textbox'

Error 403 Daily limit of unauthenticated use exceeded while updating Fusion Table

I am working on an app that is like an extension to the Pizza party app. Here first the user enters user ID and amount spent and that gets subtracted from his balance.

Now while doing SELECT, I face no problem, but while running UPDATE query on the table, it gives the Error 403 Daily limit of unauthenticated use exceeded error.
I am logged on in my phone and have edit permissions for the same login.

Attaching the UPDATE query and the results. Here I have verified that the variables global updated_amt_full and global row_no (contains the ROWID) are correct.

Attaching the codes. Pls help

Your block calling UPDATE looks suspicious is it actually spaceUPDATEspace or spaceUPDATEnospace ? I can not tell from the image.

Thnks for your prompt reply.

The UPDATE block is spaceUPDATEspace. Similarly the other blocks also have proper spaces.

Any other suggestions, pls ??

I assume your blocks posted do not show all your code. Do you use your API code? The API is necessary to access your table.

Keep in mind, f you do not include an API Key, you will receive a "403: Daily Limit Exceeded" message.

From the Pizza Party Fusion table:

which you are probably using as an example for your code shows some blocks that might be missing or that do not have the correct API Key. Is that possible? Please check and get back here to let us know if they are there or they were missing.

You were spot on. Since I was using multiple Fusion table control objects, I actually did forget to include the API key for the last one.

Doing it removes the error. Thnks.

But it gives a new error: 503 service Unavailable Internal error. Please report to ...

Any suggestions here??

--

you might want to provide a screenshot of your relevant blocks

Glad my suggestion worked. So, you get a different error. "it gives a new error: 503 service Unavailable Internal error. Please report to "

I have mixed results with Google's Fusion Tables; after all they are Experimental. Google keeps changing how they work and what they look like AND they are not always available.

I have gotten that error, waited a few minutes and my access was OK, so try again. Are you using an emulator or a device. Sometimes the emulator has issues and it is possible you have not given users (and yourself) all the permissions needed.

Look here: Fusion Table API . Have you looked at your table using Windows or whatever OS you have? Try accessing your table using windows. I have found that many users are using tables that are mal-formed and un-editable even when using DropBox. The solution is to rebuild the table using your PC and then change the table ID in your aI2 code.

Why not try this and get back to us here at the forum . If your table is in good shape, consider providing an aia file or images of your relevant blocks as suggested by Taifun. If you can not edit your own table using dropbox, your issues is with Fusion Tables and not AI2.

You can access your table by pasting code similar shown at this link into your browser window Direct Windows Access to FT . The link explains how. Try viewing/editing your table using the example code remembering to replace the table ID with your table's id.

Thnks for your support so far. I continue to get the 503 service unavailable error. I would like to answer to the issus raised by you.

1) I have a windows 7 machine and I am running on a device through wifi.

2) I tried to re do the query and it still gives the same error, so probably its not a temporary issue.

3) I have Two fusion tables say A and B. On B I am running an INSERT query that works fine. On A, I run a SELECT query that works fine and an UPDATE query that gives the error.

4) I ran the update queries the way you told me through the browser.

First I ran the query

https://www.googleapis.com/fusiontables/v1/query?sql=UPDATE%201yL3P7x0ET84EXE-k3nI2sktew3KDbr9wW0grFG8%20SET%20Amount%20=%20'450'%20WHERE%20ROWID%20=%20'1'

This gave an error saying need to send a POST request and not GET.

Next I tried the interface at https://developers.google.com/fusiontables/docs/v1/reference/query/sql#try-it

to send the UPDATE query. After authenticating with the API key, I ran the query

UPDATE 1yL3P7x0ET84EXE-k3nI2sktew3KDbr9wW0grFG8 SET Amount = '450' WHERE ROWID = '1'

The Query actually works and the fusion table is updated.

This is a snapshot of the response

Question is if this works, why is it giving the 503 Error from the app ??? Any suggestions

--

In addition to my previous response to Steve, I would also give snapshots of most of the blocks as you have asked.

Basically I am trying to modify the Pizza party app such that there are two tables: say A and B. When user buys something, we check if he has sufficient balance in A, (SELECT query works fine). If yes the transaction is stored in B (INSERT query, works well) and the specific user's balance is reduced in A (UPDATE query: not working)

Fig 1 These are the global variable declarations

Fig 2 These are the initialization and reset form functions (Similar to Pizza party)

Fig 3 Submit button functions (Similar to Pizza party)

Fig 4 and 5 SELECT query and response handling (seems to be working fine)

Fig 7 and 6 INSERT query and response handling (Similar to Pizza party and seems to be working fine)

Fig 8 and 9 : The UPDATE query: GIVES 503 Internal error: Service not available

Attaching the figures below. Any help would be great.

I you are asking for help, I recommend you to make it as easy for others to be able to help you ...

first to unzip something is not very helpful from my point of view...

to find out, if your sql statement is correct, right click onto the join block of the statement and select "Do It"... it looks like there is a space missing after UPDATE, also the amount in your table most probably is numeric and not text? if yes, remove the quotes around the amount...

you might want to provide another screenshot of the update statement incl. Do it result...

I agree with Taifun, there is a space missing after UPDATE in your updateBalanceTab

Also, your values probably are numeric. You can check your table on Windows and find out whether each field is text or numeric; Do you know how to do that. You may need to remove the quotes from the amount and the row ID. Do those things, try your app and let us know. So basically, I am agreeing with Taifun's suggestions.

Another thing that seems suspicious is where you retrieve SET Amount= I am not sure what the actual name for the field is in your table. Consider "UPDATE 1yL3P7x0ET84EXE-k3nI2sktew3KDbr9wW0grFG8 SET Amount = '450' WHERE ROWID = '1' " as a direct query works. Check for missing spaces. I noticed that when you defined the two globals used in this sql query they are defined as text.

I would get rid of the quotify blocks temporarily and test the sql statement again. Since the UPDATE does work on the table, you are possibly close to a solution.

Thnks for your prompt reply.

My apologies if the way I mailed was not helpful. I on the contrary felt that sending all the attachments zipped in one file would be helpful as it would help you not having to download all the attachments separately. I will keep your advice in mind.

Coming to your suggestions: there is a space after UPDATE.

I have removed the quotes as the Amount column indeed is numeric. But the problem continues.

I am sending you the snapshot of the UPDATE block.

Remove the quotify block from the row ID too.

Why? The answer is probably here: '450' WHERE ROWID = '1'

so if '450' should be 450, then rowid should be 1 . Does that make sense.

When I remove the quotify block from row ID it gives me a different error

400 Bad Request Invalid Query: Parse error near '1&#39 (line 2 position 0)

Though I am not sure, is it that the row_no variable is getting the value \n 1 instead of 1 ??

Sending you the update block again

Also to reply to an earlier query, the table has two fields Name (Text) and Amount (Numeric, format 1235.56 )

The table being public you can I think see it at https://www.google.com/fusiontables/DataSource?docid=1yL3P7x0ET84EXE-k3nI2sktew3KDbr9wW0grFG8#rows:id=1

--

the rowid needs to be quotified

unfortunately I can't see in your Do it result, if the statement is correct...

it would help if we could see the Do it result in one row only, just resize that window accordingly...

Quotified rowid. That again brings back the 503 error

I am sending the query in one line. Somehow the rowId never comes in the same line of the query. Is there an unnecessary \n or something??

Would it make sense instead of getting the row ID to get WHERE Name= ?

Also is ROWID= called in all capitals or should it be rows.id= ???

even though this query works perfectly well: UPDATE 1yL3P7x0ET84EXE-k3nI2sktew3KDbr9wW0grFG8 SET Amount = '450' WHERE ROWID = '1'

--

I think I know now why you get the problem...

how do you retrieve the rowid?

in case you do a query like that "SELECT ROWID FROM <tableid> WHERE ...

you will get a 1 column result like that:

rowid

now use the split command to split the result by \n to get a 2 item list and select the second item, which is the rowid: 1

probably you do it different currently and the invisible \n is inside your rowid variable...

The quotify procedure is same as the one being used in pizza party example, I dont think there is any mistake there.

I think the point you are making is right. I think there is a problem in the split. Let me see to it.

Also to Steve's suggestion can we have a UPDATE query with WHERE name = . If yes, that would suffice because Name is the primary key. But the syntax seems to say we need WHERE ROWID thing.

I will try out both and connect back in some time.

Also to Steve's suggestion can we have a UPDATE query with WHERE name = . But the syntax seems to say we need WHERE ROWID thing.

exactly, "WHERE name=" is not possible in the fusion table syntax, you need the ROWID...

It works !!!!

Yes, though the splits have been done haphazardly by me, I followed Taifun's suggestion and did one more split at \n and then took index 2. This removes the \n problem and the UPDATE worked !!!

Really want to thank both of you, for helping me out.

I would probably do some more cases and see if this works all the time and get back to you.

Also @ Taifun, I found the parsing of JSON packets pretty difficult for first timers like us. Any links/posts that I may follow. I say a few posts from you in ai1, but not much in ai2.

I am very glad you got this working and I hope you had a lot of fun. It was clever of Taifun about the \n split. You spent a lot of time on the project, tried lots of suggestions and it payed off. Congratulations.

Fusion Tables UPDATE by App Inventor

I have created an app by App Inventor to store data in a Fusion Table but I need to UPDATE some cells in a specific row. I want to scan a barcode and manually enter the new data. After that, I need to sum the old data and the new data in the row orded by barcode. How can I do it?

a good start is the Pizza Party with Fusion Tables for App Inventor 2

just send an update statement to the fusiontable using the fusiontable controls

and here an example of an UPDATE statement https://puravidaapps.com/fusionDB.php#update

this also may help

Frequent Made Errors with Fusiontables and how to fix them

Thank You for the fast answer but I've seen that tutorial about 3 weeks ago and It can't help me. Now I can insert data, but I can't update it. That's my problem. Do You know something about it?

the tutorial helps you to learn how to work with fusiontables

now it's your turn

I sent you several links, did you check all of them?

just try something, and if you get stuck, post a screenshot of your relevant blocks

Ok, ok. Thank You again. Now I try to explain (if I can) with some screenshots.

The INSERT TO function works and the dropdown menus too. But now I need to update QUANTITY and PRICE choosing product by barcode scanner.

--
For UPDATE statements the first step to be done is to get the ROWID of the row to be updated with a SELECT statement. The second step is to do the UPDATE.

you can find the syntax in the documentation https://developers.google.com/fusiontables/docs/v1/sql-reference

btw. you probably like to rename your procedures? for example rename "procedure" to "insert"

what is "procedure2" doing?

Yes, You're right!. Rename functions is better then default names.

I've found that page too, but I think my sintax is incorrect. Can You verify it, please?

1. SELECT ROWID FROM <tableid>

WHERE CODICE = '<tb_barcode.Text>'

2. UPDATE <tableid>

SET GIACENZA = '<tb_quantita_text>',

PREZZO = <tb_prezzo_text>

WHERE rowid = '<rowid from step 1>'

and yes, it helps to read the reference documentation to find out the correct syntax...

Now I suppose I undestood. I never thought to need to use SELECT instruction. Can I use them in the same "join" element?

first do the select

then you get back the rowid in the fusiontablecontrols.Gotresult event

then do the update

About Fusion Tables in MIT App Inventor 2

I am Indibar speaking. I have a doubt that how to use Fusion Tables component in MIT App Inventor 2? I went on App Inventor 2 tutorials and saw an app called "PizzyParty_MIT_2014". There I saw the component "Fusion Tables" used. I tried to link that program with my programming but it was not working. So can you help me about:

1) How to get the API Key for my table?

2) How to get the Table ID for my table?

3) How to get the Table URL for my table?

Also send a program about my doubt.

see the Pizza Party tutorial for a detailled descxription of the steps to be done Pizza Party with Fusion Tables for App Inventor 2

btw. alternatively you might want to use the service account method

https://puravidaapps.com/fusionservice.php

Thank You. I want to ask another question on How to change the Font size and styles in Fusion Tables of MIT App Inventor 2? Eg: To change the height and width of the table, To change the Font size etc.

are you talking about displaying a fusiontable in the webviewer? as far as I know, you can't change that style.

alternatively you can download your fusiontable (using a SELECT statement) and display it in App Inventor

here is an example, which gives loads of possibilities...

https://puravidaapps.com/table.php

Yes I am talking about displaying fusiontables in the web viewer. In my project I tried to create a table in Google drives which contains 3 columns and 15 rows. When I tried to display that table in my web viewer it showed but the display was horrible. The three columns name is NAME, ADDRESS, LOCATION. The first input which I gave had uploaded from below. I am not able to understand that why the datas are getting uploaded form bottom to top. Why is it not getting uploaded from top to bottom? And second thing is the font sizes are displaying very big. Can I change the font size to small ? So help me on this problem.

what is your complete table URL?

My complete table url is : https://www.google.com/fusiontables/embedviz? viz=GVIZ&t=TABLE&q=select+col0%2C+col1%2C+col2+from+1mb4xICnbmLOJeMYtucgphNelqaANN_d2ljhCQTQu&containerId=googft-gviz-canvas

you can order your result by any column in ascending or descending order, example:

https://fusiontables.googleusercontent.com/fusiontables/embedviz?viz=GVIZ&t=TABLE&q=select+col0,+col1,+col2+from+1mb4xICnbmLOJeMYtucgphNelqaANN_d2ljhCQTQu+ORDER+BY+NAME+DESC&containerId=googft-gviz-canvas

I just added +ORDER+BY+NAME+DESC after the tableid...

as already said, as far as I know, you can't change that style.

alternatively you can download your fusiontable (using a SELECT statement) and display it in App Inventor

here is an example, which gives loads of possibilities...

https://puravidaapps.com/table.php

Thank You very much. I got another problem while creating my app. The problem is that how can I get my rowid from my table? I want my rowid because when I click clear button it will clear only that row. So How can I do that? Please send this answer quickly because I have to submit this app to my teacher tomorrow.

just send a SELECT statement to the table like this
SELECT ROWID FROM <tableid> WHERE <your where condition>

to get the row id

In my project I have inserted four buttons SAVE,UPDATE,REFRESH and CLEAR. So I want to know that when first time I press SAVE button, it gets saved but it is not uploading in my table. When I refresh the page second time it is showing in my table. Why is this happening? Second thing is how to update my whole table when I press the UPDATE button? Third thing is how to clear only that row on which the data is displayed when I click the clear button? Last thing is that when I click any two rows of my table it should go to Google maps and show the location of that point. So how is that possible? Please help me on this four problems. Also send some pictures.

when first time I press SAVE button, it gets saved but it is not uploading in my table

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.

how to update my whole table when I press the UPDATE button?

do a search in the forum and see SQL Reference Documentation of the Fusion Tables API.

you have to update each row one by one

probably easier to delete the complete table and do an insert again

Third thing is how to clear only that row on which the data is displayed when I click the clear button?

do a search in the forum and see SQL Reference Documentation of the Fusion Tables API.

do it step by step first finish the first task and then think about the next

don'T try to solve all poblems at the same time

later ask again concerning the last task

It does not look like you have used the forums yet, as a search using the search box above would have returned several threads about these topics.

Advice: Before posting, it's a good idea to search in this forum. Many others have likely run into problems similar to yours. How to search see screenshot.

See also the Top 5 Tips: How to learn App Inventor

I have send an attachment as you said for the app. It is PDF document. So it might help you.

App.pdf

Frequently Made Errors with Fusiontables and how to fix them

Is there any error in my program I sent just few minutes back ago? If there is an error, please let me know. And why did you send this link "Frequently made errors with fusion tables" to me? I am not able to understand.

I don't know if there is a nerror

the link shows you how to debug your blocks and find problems yourself

also in case of error, I would display the result in the notifier, else how can you know, what kind of error happened?

use Do it to debug your blocks, see also tip 4 here

Top 5 Tips: How to learn App Inventor

Thank you for your answer taifun. I am asking this same question to Steve DJ. So please show this question to him and let me know the answer. Please do not mind.

Taifun, this is a problem that I have in last few days - until 12th of Nov, creating P12 for android returned email address like this: xxxx@developer.gserviceaccount.com. From that day, DNS is changed to xxxx@dc4-2015.iam.gserviceaccount.com and Fusion table won't accept it. I've seen the tutorial on https://puravidaapps.com/fusionservice.php, but it's not working. When I want to share Fusion table with xxxx@dc4-2015.iam.gserviceaccount.com this happens

Any ideas?

--
@Katarina: obviously it does not make much sense, to notify a service account by email...

therefore you should uncheck the checkbox "Notify people by email"...

Taifun

PS: instead of hijacking another thread, for new questions start a new thread next time. Thank you.

Dearest Taifun, you've solved my problem! Thank you so much.

For everything else - I'm guilty as charged!

Should I delete my posts?

It's better to leave your posts and their answers up on the board,

for other people who might have a similar problem in the future.

I have a really important question to ask you because I really need help of you . The question is that How to choose a particular data from a row in fusiontables?

Eg: In my app I want to choose the GPS Location column from that fusion table and when I click that that particular block it should directly go to google maps and show that location.So how to do that? Please help me because I am creating this app for exhibition which will be held on 1st of December 2015 in my school. Can you please help me to give the answer by today?

How to choose a particular data from a row in fusiontables?

send a select query to the table and get the result back in the fusiontables control got result event

then convert the result into a list and display it in a listpicker

after picking one of the items open Google Maps using the activity starter together with that GPS location

Once you had asked for my Table URL, so I gave my URL. My table contains total 39 or 36 rows. So can you decrease the row to only 8 rows? Whatever you suggested is fine but when I directly click on the location field it should go to google maps. So how to do that? Please suggest me on this problems.

My table contains total 39 or 36 rows. So can you decrease the row to only 8 rows?

you can filter your table

but when I directly click on the location field it should go to google maps

the webviewer can only display your table, you can't click onto something to trigger something else

therefore you will have to follow these steps

1. send a select query to the table and get the result back in the fusiontables control got result event

2. then convert the result into a list and display it in a listpicker after picking one of the items open Google Maps using the activity starter together with that GPS location

Is it possible to create links in fusiontables? I asked this question because I wanted to create a link in the location column so that when I click on that link, it will go to google maps and view the locations. So is that possible?

Is it possible to create links in fusiontables?

as already said, the webviewer can only display your table, you can't click onto something to trigger something else

therefore you will have to follow these steps

1. send a select query to the table and get the result back in the fusiontables control got result event

2. then convert the result into a list and display it in a listpicker after picking one of the items open Google Maps using the activity starter together with that GPS location

After thinking more about it, I'm not sure anymore...
Therefore just try it an let us know, what you find out

As you said in the last post "send a select query to the table and get the result back in the fusiontables control got result event then convert the result into a list and display it in a listpicker after picking one of the items open Google Maps using the activity starter together with that GPS location". I understood it but I am not able to write the code in mit app inventor 2. So please can you give me the code on what you said so that I could put it on my app. Please help me and give the code.

try something and if you got stuck, provide a screenshot of your relevant blocks

search results for SELECT ROWID FROM

Re: How do you get the ROWID from a fusion table?

for SELECT statements you do not need the rowid. just send the following query. SELECT * FROM <tableid> WHERE username = 'entered user name ...

Re: fusion tabloya kayıtlı olan verinin rowid nasıl alınır?

SELECT ROWID FROM <tableid> WHERE ... see also How to INSERT, DELETE and SELECT a Fusiontable by Viktor. Taifun ...

Re: in built fuisontables controls.

SELECT ROWID FROM <tableid>. and store them in a list, then execute an update statement for each rowid. UPDATE <tableid> SET myColumn ...

Re: Delete a row in fusion tables.

SELECT ROWID FROM <tableid> WHERE ... The second step is to do the DELETE. DELETE FROM <table_id> { WHERE ROWID = <row_id> }.

Re: Update Fusion Table Specific Row Query.

there are 2 steps for UPDATE statements. 1. get the rowid of the row you like to update, this is something like this. SELECT ROWID FROM <tableid> ...

Re: Help with my app.

SELECT available, ROWID FROM <tableid> WHERE schedule = <listpicker. selection>. then depending on the result send an UPDATE statement.

Delete a space.

Hi, when I select something from a fusion table (for example SELECT ROWID FROM (tableid) WHERE Description = 'apple'), it comes out like this: ...

Re: CSV to Listpicker.

SELECT ROWID FROM< tableID> WHERE Produkt = productNumberOfTheProductYouWantToUpdate. you get back the rowid as described in this ...

Re: AYUDA.

DELETE FROM <tableid> WHERE ROWID = <rowid from step 1>. 4. if you want to store products by userid, you have to provide additionally the userid ...

Re: Help with Fusion Table Oporations.

instead of only sending a. SELECT ROWID FROM <tableid> WHERE ... to the table, you would have to send a. SELECT ROWID, logdate FROM ...

Re: Error 403 Daily limit of unauthenticated use exceeded while updating Fusion Table.

I think I know now why you get the problem... how do you retrieve the rowid? in case you do a query like that "SELECT ROWID FROM <tableid> ...

Re: How do you import the row id's from a fusion table?

... UPDATE or DELETE. SQL Reference Documentation of the Fusion Tables API. SELECT ROWID FROM <tableid> WHERE <your where condition>.

Fusion table select statement.

SELECT ROWID, * FROM tableid... The statement works ONLY when I remove the * and replace by individual table elements. Please help.

Using Fushion Tables: Runtime Error that list is of length 1 Can't Be the Case.

Then comes the fushionTables.GetRowsWithConditions block. I have the tableId set to a particular fusion table's id. (I already have the credentials set ...

Re: Fusion Tables and Conditions in Queries.

to get the ROWID, just send a SELECT statement to the table like this (example). SELECT ROWID, Product, Quantity FROM <tableid>. Taifun.

Re: Update Query.

UPDATE TableID SET PicName = Ted WHERE ROWID = 12005. it should be something more like: UPDATE TableID SET PicName='Ted' WHERE ...

Re: App Inventor Fusion Tables UPDATE.

SELECT ROWID FROM <tableid> WHERE Name = 'textbox1.text'. 2. update query. UPDATE <tableid> SET Value = <textbox2.text> WHERE ROWID ...

Re: Fusion tables.

SELECT ROWID FROM <tableid> WHERE Room = '2'. you will receive a result like this. rowid. 1001. now split the result using the split block at \n (new ...

Re: How can I create a database of items so the user can search it for things?

first send a select statement to the table to get the rowid. SELECT ROWID FROM <tableid> WHERE item = <your item you want to delete>. then send a ...

Re: Edit a Column in Fusion Tables.

1. SELECT ROWID FROM <tableid> WHERE storeName = 'Waltmart__2070'. 2. UPDATE <tableid> SET value04 = <your new value> WHERE ROWID ...

Re: Fusion table check specified RowID.

SELECT * FROM WHERE ID = 2518 <tableid>. as already said, the sql statement should look like this. SELECT ID FROM <tableid> WHERE ID = 2518.

3/21/16 by Taifun - 8 posts by 2 authors - 38 views

Re: Fusion Tables UPDATE by App Inventor.

1. SELECT ROWID FROM <tableid>. WHERE CODICE = '<tb_barcode.Text>'. 2. UPDATE <tableid>. SET GIACENZA = '<tb_quantita_text>',. PREZZO ...

Re: Fusion table.

SELECT ROWID FROM <tableid> WHERE name = 'Denise'. assuming there is the column name available and you like to delete the row, which has ...

Re: Deleting data.

DELETE FROM <tableid>. and after that of course the block SendQuery to send the statement to the table. btw. there is no semicolon required after the ...

Re: user log on for then up date info.

FROM <TABLEID> WHERE username = 'TextboxUsername.Text'. see also How to INSERT, DELETE and SELECT a Fusiontable by Viktor. Taifun ...

Re: FusioTables.

are you talking about the ROWID? do a select statement like this. SELECT ROWID, Date, Name, Pizza, Drink, Comment FROM <tableid>. and receive ...

Re: Fusion Tables getting the first value of the row.

Yes, but is a way to only get the number? send a select query to the table like this . SELECT ROWID FROM <tableid> WHERE <your where condition>.

Re: About Fusion Tables in MIT App Inventor 2.

just send a SELECT statement to the table like this. SELECT ROWID FROM < tableid> WHERE <your where condition>. to get the row id. Taifun.

Re: selecting specific data from fusiontable.

Ok so I manage to get SELECT working with this code ... SELECT rowid, Location , Destination, Fare From tableID ... But it is displaying everything in ...

Re: Profiles with Fusiontables.

just send an UPDATE statement to the table like this. UPDATE <tableid> SET name = <textboxName.Text>. age = <textboxAge.Text> WHERE ROWID ...

Re: Does not update.

also if you now send a new select statement to the table, don't you see the new values? SELECT * FROM <tableid> WHERE ROWID = '18002'. Taifun.

AI2 Inventor Forum News