Android Question Solved:Encryption Initialization Creation

[Shelby]

My problem is that my project will no longer compile now that I have attempted to use SQLCipher invented by Zetetic.net.

On a tutorial by Erel,(https://www.b4x.com/android/forum/t...ryption-with-sqlcipher-library.14965/#content), Erel tells me to use the following line to initialize the SQLCipher method.

Unfortunately, the IDE slips me the note; Undeclared variable 'SQL1' is used before it was assigned any value.

In actuality I don't have a variable SQL1 anyway, so how shall I change the wording to make it work for my project. I'll attach a screenshot of when the compilation goes haywire.... Whoops, the image was too large. Here's the wetransfer.com link:
https://we.tl/t-vXVH78nqBw

Of course my project is an SQLite one. It has 712 records

 

[Shelby]

I took a big chance and exited the IDE; just brought it up again; didn't help

Yes file seems to be ok in Addnl folder although I had to rename it
It had a (3) in the name which I removed so IDE could identify it

 

[aeric]

 

[Shelby]

View attachment 155010

Thanks, checking; my paths configuration seems to be ok

 

[Shelby]

 

[teddybear]

List files in the folder as aeric posted #22.

 

[Shelby]

Lastly I've looked all through my project and the only squiggly line is in my Main module

Sub Activity_Create(FirstTime As Boolean)

I suppose it not important

 

[Shelby]

Lastly I've looked all through my project and the only squiggly line in in my Main module

Sub Activity_Create(FirstTime As Boolean)

I suppose it not important

But my additional libraries is in my projects folder. Do you think I should change the folder location and then change the path configuration?

 

[Shelby]

View attachment 155012
List files in the folder as aeric posted #22.

But my additional libraries is in my projects folder. Do you think I should change the folder location and then change the path configuration?
Can I have the folder in both locations and then change the configuration?

 

[teddybear]

But my additional libraries is in my projects folder. Do you think I should change the folder location and then change the path configuration?

No, just show the folder, see if the android-database-sqlcipher-4.5.4.aar is existed

 

[Shelby]

But my additional libraries is in my projects folder. Do you think I should change the folder location and then change the path configuration?
Can I have the folder in both locations and then change the configuration?

OK I did it

But! Same Results

B4A Version: 12.80
Parsing code. (0.14s)
Java Version: 14
Building folders structure. (0.03s)
Running custom action. (0.17s)
Compiling code. (0.11s)
Compiling layouts code. (0.00s)
Organizing libraries. Error
Could not find file 'C:\Program Files\Anywhere Software\B4A\libraries\android-database-sqlcipher-4.5.4.aar'.

I just put the configuration back as it was.

 

[Shelby]

 

[teddybear]

You don't need to change the configuration, all you need to do is put android-database-sqlcipher-4.5.4.aar into Additional Libraries folder

 

[Shelby]

You don't need to change the configuration, all you need to do is put android-database-sqlcipher-4.5.4.aar into Additional Libraries folder

Yeah I think I'm all set with that; thanks.

 

[Shelby]

 

[teddybear]

Put android-database-sqlcipher-4.5.4.aar into B4A folder

 

[Shelby]

This couldn't make any difference right? My Main module.

 

[aeric]

View attachment 155016
This couldn't make any difference right? My Main module.

Hover you mouse to the squiggly line and see what is the message. It is better not to hide the Logs panel, you can see the warning or error immediately.

 

[Shelby]

Put android-database-sqlcipher-4.5.4.aar into B4A folder

View attachment 155017

I did it but no cigar.

 

[Shelby]

layout file mainpage.bal is not used. Are you missing a call to Activity.LoadLayout? (warning #16)

That's the squiggly line hovered message.

 

[Shelby]

Any chance my old dbbrowser download needs more than just the .aar file to function properly? I used your .aar file but maybe it's not compatible. My dbBrowser file was downloaded in 2022; seems suspect to me.