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 https://puravidaapps.com/sqlite.php and some free alternatives you will find a bit below in @SteveJG ’s contribution
probably interesting to read:
"There ain't no such thing as a free lunch" (alternatively, "There is no such thing as a free lunch" or other variants) 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 practice in American bars of offering a "free lunch" in order to entice drinking cus Th...
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, stupidhttps://en.wikipedia.org/wiki/KISS_principle
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
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
– PedrozaSQLite Hello! Here I present to you my second extension ever created! It is an extension to access the local SQLite database! Background I know there is already a few extensions with this functionality, but here are the reasons why I made...
Reading time: 8 mins 🕑
Likes: 60 ❤
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
Taifun.