Text Join SQL query is wrong

[Avraham_Yerachmielbenzvi]

Hi All

Can anyone tell me why this Join is showing the wrong DO IT?

(just to prove that there is nothing wrong with the query string)

and how to fix it (besides replacing the join)

Thanks

t

[Still-learning (1-2-3-4...)]

I believe you have clicked it before the action triggers in companion mode…

Once the companion connected with creator , try to execute the event it by clicking a button then click do it.

[Avraham_Yerachmielbenzvi]

Thanks but these blocks are in screen initialize so It should be right every time, No?

[Still-learning (1-2-3-4...)]

Yes it should show… don’t know what is happening. In screen inti use tinydb clear all. And start from the beginning, saving value in tinydb and try

Clear all value from tinydb and retest it

[Avraham_Yerachmielbenzvi]

Thanks

Problem is that if I clear all TinyDB nothing will work as I depend on values picked up earlier (but let me look at that quickly)

Thanks

[Still-learning (1-2-3-4...)]

Ok… just testing only… after the screen ini drag the web url and right click on it for do it and check up the comple url… if that too wrong mean you can lodge it as bug.

[Avraham_Yerachmielbenzvi]

Thanks busy testing. Will try in a bit.

Thanks

[Avraham_Yerachmielbenzvi]

I think it most certainly is a bug because the ONLY thing that sorts it out is if I change the JOIN with a new one.

[dora_paz (Dora)]

Try something like this, I added a temp label to test

But for me it works also as

[Avraham_Yerachmielbenzvi]

Yes, Dora, I agree

The problem is NOT that the Joins dont work always. Most times they do or else my entire app would fail

The problem seems to be when you have used (i think) the join for something else and try to reuse it again

It doesnt seem to FLUSH the last string???

[Still-learning (1-2-3-4...)]

If possible you can share us your full blocks to check up

[dora_paz (Dora)]

Till now haven’t noticed it. I usually refresh my screen on changes or even disconnect companion and connect again to test latest changes while working in an app, just to be sure

[Avraham_Yerachmielbenzvi]

Ive done all that, and still the problem persists ???

[Avraham_Yerachmielbenzvi]

with plesure

How do I share the block?

[dora_paz (Dora)]

Right click on when screen.initialize block, download blocks as png, upload it here

[Avraham_Yerachmielbenzvi]

but you will only get a useless png file, without the functionality but OK

[dora_paz (Dora)]

This is not true, the png that you save is also containing all the code used. See more info here

How to make images of your blocks and how to use them

This is a short guide on how you can upload images of your blocks to the community and use them in the creator. We see users posting photographs with different levels of quality but urge everyone to use the following method. When you want to post an image of all your blocks right click a bit of white space in the blockseditor and choose Download blocks as Image [Peek 2020-04-26 06-26] If you want to share just one set of blocks you can right click on the block and choose Download blocks as …

[Avraham_Yerachmielbenzvi]

thanks, I am suprised

Thanks

[Avraham_Yerachmielbenzvi]

oh, I changed the join so now its gone. but it will happen again so next time!

but this one just failed