1) Can someone share me a simple application and usage on how to manage, handle and load sqllite file into application eg load, update, search and delete record?
2) Can the data in sqllite encrypted and how we can handle it in B4ppc?
See the SQL example here: www.basic4ppc.com/Downloads.html (there are two versions, compiled application and source code).
The table can't be encrypted as a complete encrypted table.
Using the Crypto library you can encrypt the important data before inserting it to the table.
I already installed the .net 2 as instructed. But I still this error when I try to open the demosql (demosql.zip above). I also get error on "Could not load or assembly System.Data.SQLite........ System could not find the file specified.
I am using trial B4P5.
Your sample worked and after I figured out I had to name the .exe.config the name of the application, my sample worked to! Perhaps something to add to the steps to take to get it work quickly? Or is there already a Wiki?