Shelby Well-Known Member Licensed User Longtime User Jun 29, 2024 #1 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. Code: 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
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. Code: 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
Solution teddybear Jun 29, 2024 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
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 Well-Known Member Licensed User Longtime User Jun 29, 2024 #21 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 Upvote 0
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
Shelby Well-Known Member Licensed User Longtime User Jun 29, 2024 #23 aeric said: View attachment 155010 Click to expand... Thanks, checking; my paths configuration seems to be ok Upvote 0
aeric said: View attachment 155010 Click to expand... Thanks, checking; my paths configuration seems to be ok
teddybear Well-Known Member Licensed User Jun 29, 2024 #25 List files in the folder as aeric posted #22. Upvote 0
Shelby Well-Known Member Licensed User Longtime User Jun 29, 2024 #26 Lastly I've looked all through my project and the only squiggly line is in my Main module B4X: Sub Activity_Create(FirstTime As Boolean) I suppose it not important Last edited: Jul 7, 2024 Upvote 0
Lastly I've looked all through my project and the only squiggly line is in my Main module B4X: Sub Activity_Create(FirstTime As Boolean) I suppose it not important
Shelby Well-Known Member Licensed User Longtime User Jun 29, 2024 #27 Shelby said: Lastly I've looked all through my project and the only squiggly line in in my Main module B4X: Sub Activity_Create(FirstTime As Boolean) I suppose it not important Click to expand... But my additional libraries is in my projects folder. Do you think I should change the folder location and then change the path configuration? Upvote 0
Shelby said: Lastly I've looked all through my project and the only squiggly line in in my Main module B4X: Sub Activity_Create(FirstTime As Boolean) I suppose it not important Click to expand... 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 Well-Known Member Licensed User Longtime User Jun 29, 2024 #28 teddybear said: View attachment 155012 List files in the folder as aeric posted #22. Click to expand... 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? Upvote 0
teddybear said: View attachment 155012 List files in the folder as aeric posted #22. Click to expand... 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 Well-Known Member Licensed User Jun 29, 2024 #29 Shelby said: But my additional libraries is in my projects folder. Do you think I should change the folder location and then change the path configuration? Click to expand... No, just show the folder, see if the android-database-sqlcipher-4.5.4.aar is existed Upvote 0
Shelby said: But my additional libraries is in my projects folder. Do you think I should change the folder location and then change the path configuration? Click to expand... No, just show the folder, see if the android-database-sqlcipher-4.5.4.aar is existed
Shelby Well-Known Member Licensed User Longtime User Jun 29, 2024 #30 Shelby said: 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? Click to expand... 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. Upvote 0
Shelby said: 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? Click to expand... 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.
teddybear Well-Known Member Licensed User Jun 29, 2024 #32 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 Upvote 0
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 Well-Known Member Licensed User Longtime User Jun 29, 2024 #33 teddybear said: 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 Click to expand... Yeah I think I'm all set with that; thanks. Upvote 0
teddybear said: 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 Click to expand... Yeah I think I'm all set with that; thanks.
teddybear Well-Known Member Licensed User Jun 29, 2024 #35 Put android-database-sqlcipher-4.5.4.aar into B4A folder Upvote 0
Shelby Well-Known Member Licensed User Longtime User Jun 29, 2024 #36 This couldn't make any difference right? My Main module. Upvote 0
aeric Expert Licensed User Longtime User Jun 29, 2024 #37 Shelby said: View attachment 155016 This couldn't make any difference right? My Main module. Click to expand... 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. Upvote 0
Shelby said: View attachment 155016 This couldn't make any difference right? My Main module. Click to expand... 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 Well-Known Member Licensed User Longtime User Jun 29, 2024 #38 teddybear said: Put android-database-sqlcipher-4.5.4.aar into B4A folder View attachment 155017 Click to expand... I did it but no cigar. Upvote 0
teddybear said: Put android-database-sqlcipher-4.5.4.aar into B4A folder View attachment 155017 Click to expand... I did it but no cigar.
Shelby Well-Known Member Licensed User Longtime User Jun 29, 2024 #39 layout file mainpage.bal is not used. Are you missing a call to Activity.LoadLayout? (warning #16) That's the squiggly line hovered message. Upvote 0
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 Well-Known Member Licensed User Longtime User Jun 29, 2024 #40 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. Upvote 0
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.
