hello. can you help me, I got an error when screen initialize,
Hi @kitakita007 welcome to the community:
Read this:
How to ask a question?
Can you mention what you are trying to do?
Probably your “run query” procedure is having problem
im sorry sir, im newbie. sorry for bad english.
im practice with this app
when i open this screen i want to make a list
then i get data from web my sql database…
can you help me fix this sir?
Received a 200 code, that is not a mistake, it means that the data was obtained successfully
There is an error in your blocks
For a simpler solution I recommend using the MySQL Database extension from DeepHost, it also has an example AIA for use with ColinTree ListView
The Deephost extension did not work well in SQL queries.
Work well for me
Funciona bien para mí
All right, I’ve got the wrong version
as I can see, you are following the MySQL tutorial from here App Inventor Tutorials and Examples: MySQL | Pura Vida Apps
as it already has been said, this is not an error, just remove the Notifier and try again
@yanquisalexander which extension are you talking about? any link? as far as I know, a MySQL extension is not possible, because MySQL runs on a web server…
Taifun
@yanquisalexander thank you for letting me know…
it seems to be, I have to add a few more extensions from @Deep_Host into the extensions directory…
@Deep_Host congratulations! this looks like a great extension, which is based on my script from here App Inventor Tutorials and Examples: MySQL | Pura Vida Apps
Please give credit and add a link to the source… this is how the internet works… Thank you!
see also my license:
This work by Pura Vida Apps is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License with attribution (name=Pura Vida Apps and link to the source site) required.
Why it’s a good idea to give credit by Corey Wainwright.
Also you might want to follow the naming conventions… which are UpperCamelCase for property, method and event names (i.e. the first letter should be a capital letter) and lowerCamelCase for parameter names, i.e. no underscores
Keep up the good work!
Taifun
Take it just as a suggestion…
As I can see you are using AIA of jobworld app made by Sanjay Dey I would like to tell you that there are a lot of bugs in that AIA.
Just a suggestion…
thank you sir, now i understand
yes sir, i learn thats aia. how to crud with webmysql with login system, next ill learn with fire base,
I have problems running a simple query:
SELECT * FROM DB_iscritti
WHERE CODICE_TESSERA
= ‘QR20194’
I put into a Run Query instruction block but it doesn’t return any result.
Where ‘QR20194’ is defined by a TEXT Box
I had the same problem a long time ago. I used the Deephost extension, all its blocks work except the block to make an SQL query, I’ve written to him (Deephost), commented your videos, followed your tutorials that just don’t have the example of SQL queries. I received no response and now I’m using the Taifun tutorial which is great for making SQL queries.
Thanks, I Hope he will fix in future
You might want to use the list from csv table block
Taifun