Sample sqllite application

anansath · #1 (**permalink**) 05-28-2007, 02:49 PM

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

Erel · #2 (**permalink**) 05-28-2007, 03:20 PM

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.

giannimaione · #3 (**permalink**) 05-29-2007, 07:41 AM

A little demo of sql

Gianni

conf · #4 (**permalink**) 05-29-2007, 06:16 PM

I open this sample and it's error (see attach). How can fix it ?

Erel · #5 (**permalink**) 05-29-2007, 06:21 PM

You need to first install .Net 2.0.
See this page: www.basic4ppc.com/netcf2.html

conf · #6 (**permalink**) 05-29-2007, 06:50 PM

Thank Erel, you answer so fast !

anansath · #7 (**permalink**) 06-08-2007, 05:03 PM

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.

dzt · #8 (**permalink**) 06-08-2007, 05:27 PM

Extract from the attached zip the dbasic.exe.config in your b4ppc folder (where dbasic.exe exists)

Erel · #9 (**permalink**) 06-08-2007, 06:44 PM

Please see the setup instructions of the SQL library: www.basic4ppc.com/Downloads.html

Scubaticus · #10 (**permalink**) 06-27-2007, 06:31 PM

Quote:

Originally Posted by Erel

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.