Necesito ayuda. No sé cómo hacer.
Trabajo con varias ventanas.
En una ventana, se crea un despacho o almacén y se guarda en una lista con todos los almacenes creados.
En otra ventana, doy la posibilidad de ingresar los productos con sus fechas de caducidad (en los bloques que envío está resumido)
Quiero hacer una busqueda.
Que al ingresar una fecha de caducidad o nombre de producto, la aplicación devuelva en qué despacho hay productos con esa fecha de caducidad.
Es decir, que busque en todos los stock con los diferentes nombres de despacho, productos que vayan a caducar en esa fecha.
Envío fotos para hacerse una idea de lo que intento.
Taifun
February 25, 2020, 7:11pm
2
you can do it the cumbersome way using TinyDB using loads of blocks, @ABG might want to add his examples into this thread...
or you can do it elagantly using a SQlite database
you can find my paid sqlite extension here App Inventor Extensions: SQlite | Pura Vida Apps and some free alternatives you will find a bit below in @SteveJG 's contribution
probably interesting to read:
"No such thing as a free lunch" (also written as "There ain't no such thing as a free lunch", "There is no such thing as a free lunch" or simply "No free lunch" and sometimes called Crane's law) is a popular adage communicating the idea that it is impossible to get something for nothing. The acronyms TANSTAAFL, TINSTAAFL, and TNSTAAFL are also used. The phrase was in use by the 1930s, but its first appearance is unknown. The "free lunch" in the saying refers to the formerly common practic The p...
why you might want to consider buying rather than taking the "free lunch"
my extension is available since August 2016 and is therefore very stable
it follows the KISS principle - Keep it simple, stupidKISS principle - Wikipedia
I'm offering support in case there are issues and provide updates and bugfixes
Taifun
Trying to push the limits! Snippets Tutorials Extensions Pura Vida Apps by
Taifun.
SteveJG
February 25, 2020, 7:52pm
3
There a several (free) extensions that allow you to experiment with a SQlite database:
If you decide upon using sqlite you might consider these capable (free) extensions below.
AppInventor extension for SQLite. Contribute to frdfsnlght/aix-SQLite development by creating an account on GitHub.
and here is another one
Community – 9 Oct 17
https://community.thunkable.com/t/free-sqlite-extension-sponsored/8802
ABG
February 25, 2020, 7:55pm
4
SQL is more elegant for searching.
If you want to do blocks based search, here are some alternatives …https://groups.google.com/d/msg/mitappinventortest/7jsH889DYt8/R66q86OXCQAJ
None of those samples use the new dictionary data type, and none are online.
No conozco nada de SQL :no divertido:
ABG
April 17, 2023, 5:32pm
6
