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
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
Finally my friend here on the forum (Geoff T) has straightened me out. It appears that one of the primary mistakes I made was to think I could edit the code after the first time I built the project with the Cipher db Browser. Editing my records is as easy a task as ever but editing the code in the project can bring some unwanted results. Special thanks to Aeric and Teddybear for your patience and stamina while helping me.