Sample sqllite application

anansath

Member
Hi Fren,
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?

thks in advance.

anant:)
 

anansath

Member
Hi Erel,
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.
 

Scubaticus

Active Member
Licensed User
Please see the setup instructions of the SQL library: www.basic4ppc.com/Downloads.html
I followed the instructions partially again as I have the same problem. I don't have b4ppc installed on my ppc.

I have the following files from SQL1.2.zip in a directory stored on my sd-card:

Northwind.sl3
SQLDevice.dll
sqlsample.exe (compiled dev version of SQL.sbp)
System.Data.SQLite.DLL
TreeView.dll

When I start sqlsample.exe, the device responds with "Error loading program. IOException"


On my PC I had a same sort of error (System.Io.File ....) but solved that one by putting the system.data.sqlite.dll in the directory the compiled exe is stored.

.NET is installed. Other compiled b4ppc program runs without problem (but they are not using one of the above mentioned dll's)


What did I overlooked?

Scub.
 

Scubaticus

Active Member
Licensed User
Thanks for your quick response Erel.

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?

Scub
 

Scubaticus

Active Member
Licensed User
Oke thanks for that one. I didn't read that whole story because it was assuming you had to have b4ppc installed on the Dev which I haven't. But it could have give me a clue .....

Much to eager to finish my first app instead with you great program!

Scub.
 
Top