SQLite Tool Extension Update (Free)


#1

Hola a todos comparto esta herramienta fue una de las primeras extensiones que hice y se puede utilizar en appybuilder Gold es poder generar consultas Sql desde bloques aquí le dejo algunos ejemplos

CREATE TABLE

CREATE TABLE Inventory ('ID' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'ItemName' TEXT, 'Stock' INTEGER, 'UnitCost' INTEGER, 'SalePrice' INTEGER, 'Opcion' TEXT);

INSERT INTO

INSERT INTO Inventory (ItemName, Stock, SalePrice, UnitCost, Opcion) VALUES ('anyway','45000','10000','5000','4 for 15000');

SELECT

 SELECT ItemName, Stock, SalePrice, UnitCost, Opcion FROM Inventory;

SELECT ItemName, Stock, SalePrice, UnitCost, Opcion FROM Inventory WHERE ID = 3;

UPDATE

UPDATE Inventory SET ItemName = 'crema', Stock = '300', SalePrice = '4000', UnitCost = '2000', Opcion = 'esta buena' WHERE ID = 1;

DELETE

DELETE FROM Inventory WHERE ID = 3;

image

co.com.dendritas.SQLiteAddon.aix (9,1 KB)


#2

Hi @Andres_Cotes nice extension, but I don’t get the use of SELECT, it always return the SELECT STATEMENT and not the values get from the database


#3

Descarga nuevamente me muestra que sale


#4

Sorry, can’t understand the answer


#5

If you had given the aia file with all of your super extensions, then we would have been better for less sensible people like us.


#6

Well Said brother.

Really what @Shivendra_Kr_Sahu is telling is right.

An aia file help us a lot. Please post any aia


#7

Hello guys, i hava problema with select, did You have a example ? This setence don’t give me the values, but show “select * from…”


#8

you can view in result comment


#9


#10

In the block of end, the label6.text don’t Take the result of query select


#11

Hello You check info inputs no are text they are list


#12

I Will Go check this.

This is error