fusion table update

does anyone know whats wrong with my blocks

--

your blocks look fine

what do you get after sending the SELECT query to the table?

how does the fusiontable1.GotResult event look like?

do you get an error message? if yes, which error message?

--

I dont get a erorr the select works i get the rowids
but then the code breaks and de rowids arent send to the global rowid

--

--

I use 2 fusion tables insert and select works fine but the update doesnt work maybe the redlt isnt sending the rowid but i also tryed to set a rowid in de update block but that doesnt work

--

https://puravidaapps.com/fusionerror.php

What have you done to debug it?

--

but then the code breaks and de rowids arent send to the global rowid

piece should be the text "rowid" and the text should be the result...

--

no that didnt work  also it doesnt update if i set a number in the amount text

and set a rowid in a textblock

--

i use do it to debug it i dont get errors it just wont work grrrr

--

see the documentation http://appinventor.mit.edu/explore/ai2/support/blocks/text.html#contains

contains

Returns true if piece appears in text; otherwise, returns false.

i use do it to debug it i dont get errors it just wont work grrrr

it does not look like you know how to debug?

see tip 4 here

Top 5 Tips: How to learn  App Inventor

what is the result you get in the fusiontable1 got result event?

--
Error from companion. The variable $result

Is not bound in the current context
This is when i do ot

--

I dont get a responce back

--

Error from companion. The variable $result
Is not bound in the current context

Do it does not work for local variables

as already suggested, you might want to follow tip 4 and read also what Scott recommends how to debug local variables...

protip: use a label or assign the result to a global variable and display that...

--

Now when i put a number in the update it says affected row
But i dont get a result from the global rowid
Whats wrong i am getting frustrated please help mee

--

Don't make us guess.

You know what we need.

--

What do you need ? I have Autism so i dont understand the qeustion

--

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.

--

those are the blocks and the aia.file

going nuts with that

Wharehousetest.aia

--

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

You probably will get more feedback then...

which means in your case post a screenshot of your relevant blocks...

and: you additionally might want to provide a description what exactly is happening, which result you get etc.

sorry, I will not take a look at all the blocks...

and to download the aia file, upload it to  App Inventor, open it, do some bug hunting for you, etc... this takes time, and most people will not do that...

Thank you.

--

See attached.

Your CONTAINS test is wrong.

swap the inputs.

You want to look for piece  in text, not the other way around.

You can see the tool tip for this block by hovering the cursor over it,

if you forget which way it goes.

--

You are overloading the Fusion Table controls by asking

them to do too many different jobs.

The event block that catches the result from the FT control

doesn't 'know' which query produced that result.

I recommend making separate FT controls in the Designer,

named after the Query they are used with,

like FT_SELECT_STAR,

FT_INSERT,

FT_UPDATE_GET_ROWID_Part_1,

FT_UPDATE_USE_ROWID_PART_2,

etc.

This way you can have separate event blocks that

know what just happened, and how they should respond.

(I see no economy in overloading single controls using global variables

to "remember" the context.)

--

Also, you don't need those .ForgetLogin blocks.

--

Taifun said that i should swap those blocks

--

I can pay for your service if thats ok then u could do it for me how much thatt that costs?

--

Taifun said that i should swap those blocks

yes exactly, I suggested to swap the blocks and also ABG did

but unfortunately you did not follow that suggestion.. which means don't be surprised if it does not work...

--

Yes i did swap it when you told me too
But still i cant update so when i swapped it back
It still didnt work .
But what does it cost when you build the app for me
What does that cost ?

--

There is a For Hire section in this FAQ: For Hire (sites offering paid help (YMMV))

Sample project and doc showing multiple Fusion Table request management ...  Fusion Table Deletion

--

But what does it cost when you build the app for me

sorry, I'm currently not available

I will be in vacation for some weeks soon...

--

i got it working with help from you i can insert get select add and update now the next thing i wanna do is delete

--

great! congratulations!

to delete is simple, you do not need the rowid for that...

just send the delete statement to the table...

--