Android Question Mostly 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

 

[teddybear]

I did it but no cigar

Show your path configuration and B4A folder

 

[aeric]

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

That's the squiggly line hovered message.

That is just a warning or reminder that you may forgot to load the layout file. Your app may show a blank screen.

Private Sub B4XPage_Created (Root1 As B4XView)
    Root = Root1
    Root.LoadLayout("MainPage") ' <--
End Sub

 

[Shelby]

 

[Shelby]

View attachment 155019

 

[Shelby]

That is just a warning or reminder that you may forgot to load the layout file. Your app may show a blank screen.

Private Sub B4XPage_Created (Root1 As B4XView)
    Root = Root1
    Root.LoadLayout("MainPage") ' <--
End Sub

The apps have been displaying ok; so I don't think the warning is affecting anything.

 

[aeric]

The apps have been displaying ok; so I don't think the warning is affecting anything.

Yes. If you have another layout file and you don't need MainPage.bal then you can delete it.

 

[Shelby]

Yes. If you have another layout file and you don't need MainPage.bal then you can delete it.

OK

 

[teddybear]

Your Additional Libraries path is this (see red border)

but you put android-database-sqlcipher-4.5.4.aar into project folder not Additional folder

You should put the android-database-sqlcipher-4.5.4.aar into folder C：\Users\HP\Desktop\Projects\Additional Libraries\B4A

 

[Shelby]

This following from my configuration paths; I'll check your wording above.
C:\Users\HP\Desktop\Projects\Additional Libraries
OH! I put that .aar file in any B4a folder I saw earlier

 

[Shelby]

This following from my configuration paths; I'll check your wording above.
C:\Users\HP\Desktop\Projects\Additional Libraries
OH! I put that .aar file in any B4a folder I saw earlier

 

[Shelby]

Your Additional Libraries path is this (see red border)
View attachment 155021
but you put android-database-sqlcipher-4.5.4.aar into project folder not Additional folder
View attachment 155022
You should put the android-database-sqlcipher-4.5.4.aar into folder C：\Users\HP\Desktop\Projects\Additional Libraries\B4A

View attachment 155023

It's there also

 

[aeric]

Can you create a small project so we can see where the problem is?
Do you manage to encrypt your database using DB Browser (SQLCipher)?

 

[Shelby]

I just found a space in the .aar file and removed it. compiling not certain

 

[Shelby]

It's compiling ok but the display is a problem. You guys have given me so much time and joy. As usual, this forum is a miracle for some of us.
Thanks,
I'll give some money to you, Teddy, Aeric. I'm off for a 100 mile drive for a dinner by Los Angles in the next hour so I'll get back to you tomorrow.
Later,
Shelbinator

 

[Shelby]

Yeah, the display has stopped. I'll tackle it tomorrow after we return or Monday.

 

[aeric]

Even though I have no experience with SQLCipher, I read that it is not straight forward like using normal SQL library.
I have no success encrypting a SQL database using DB Browser (SQLCipher).
It seems not easy. I suggest you read that entire thread to learn more.

 

[Shelby]

Your Additional Libraries path is this (see red border)
View attachment 155021
but you put android-database-sqlcipher-4.5.4.aar into project folder not Additional folder
View attachment 155022
You should put the android-database-sqlcipher-4.5.4.aar into folder C：\Users\HP\Desktop\Projects\Additional Libraries\B4A

View attachment 155023

How do I mark an individual post a solution?

 

[teddybear]

How do I mark an individual post a solution?

At the post #48 you can see this

 

[aeric]

How do I mark an individual post a solution?

you can ignore me this time.

 

[Shelby]

you can ignore me this time.

Thanks, but I don't want to ignore you.