SQLite extension (SPONSORED!)

Extensions
#11

But make sure, to give credits for @CarlosPedroza27, as he developed the extension and you have used it.

3 Likes
#12

Carlos already gave permission to the Makeroid developers to use his code in Makeroid.

Screenshot_20171010-080541-01
Screenshot_20171010-080541-01.jpeg747×791 192 KB

3 Likes
#13

I’ve already been talking with him for some days about the extension :wink:

6 Likes
#14

That’s correct, and that is my goal when liberating the source code: Contribute to the AppInventor and all its distributions community.

4 Likes
#15

I have merged this extension into a Makeroid component; It’ll be available in the next update. Thank you @CarlosPedroza27, great extension!

5 Likes
#16

A post was split to a new topic: YAIL error when compiling

#17

This has been a known extension posted in other distributors too and a very good one.
I am glad to see it embedded in Makeroid.

I am failing to use it with multiple WHERE, GROUP BY & ORDER BY CRITERIA in the pre-compiled statements.
No problem at using raw queries to get the results I need.

Could anyone post a block example for
call PedrozaSQLite1. Query
call PedrozaSQLite1.Update
call PedrozaSQLite1.Delete

blocks with multiple criteria???

Thank you in advance!!

#18

Como eu consigo essa extensão?
Aqui diz que o Link não existe.

#19

This extension is included with Kodular. It is the SQL component, in Storage.

2 Likes
#20

But, the extension included in Kodular does not have the option “Import / FileName” or “ImportDatabase / FileName”. With the basic options you have, I did not understand how to open a database :expressionless:

#21

The original extension doesn’t have these features either.

screenshot_115
screenshot_115.png713×87 6.21 KB

You can create the DB on the fly, using the SingleSQL method. Then you can’t export it easily. For import/export methods you can try these two extensions:

1 Like
#22

my sqlite extension offers an Import and Export method…
Taifun

5 Likes
#23

Este aia esta dando erro!

#24

Welcome. The official language of the forum is English. So please translate your text.

1 Like
#25

Sorry. This file is not working when I roll into Kodular today!

#27

Can anyone please update the aia, or can anyone help?

1 Like
#28

agreed. It would be helpful
hope someone can post it

#29

You can get all the files from this topic:

1 Like
#30

The extension from @CarlosPedroza27 is since a long time a component of Kodular

image

4 Likes
#31

sure, i know but i’d liek to have an aia tu study the funcionality