Basic4ppc - Windows Mobile Development  

Go Back   Basic4ppc - Windows Mobile Development > Main Category > Code Samples & Tips
Home Register FAQ Members List Search Today's Posts Mark Forums Read

Code Samples & Tips Share your recent discoveries and ideas with other users.


Sample sqllite application


Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-28-2007, 02:49 PM
Newbie
 
Join Date: May 2007
Location: Malaysia
Posts: 6
Send a message via Yahoo to anansath
Default Sample sqllite application

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
Reply With Quote
  #2 (permalink)  
Old 05-28-2007, 03:20 PM
Erel's Avatar
Administrator
 
Join Date: Apr 2007
Posts: 2,778
Default

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.
Reply With Quote
  #3 (permalink)  
Old 05-29-2007, 07:41 AM
giannimaione's Avatar
Senior Member
 
Join Date: Apr 2007
Location: Naples, Italy
Posts: 124
Send a message via Skype™ to giannimaione
Default

A little demo of sql

Gianni
Attached Files
File Type: zip demoSQL.zip (9.1 KB, 229 views)
Reply With Quote
  #4 (permalink)  
Old 05-29-2007, 06:16 PM
Knows the basics
 
Join Date: May 2007
Posts: 82
Default

I open this sample and it's error (see attach). How can fix it ?
Attached Images
File Type: jpg SQLerror.jpg (14.1 KB, 78 views)
Reply With Quote
  #5 (permalink)  
Old 05-29-2007, 06:21 PM
Erel's Avatar
Administrator
 
Join Date: Apr 2007
Posts: 2,778
Default

You need to first install .Net 2.0.
See this page: www.basic4ppc.com/netcf2.html
Reply With Quote
  #6 (permalink)  
Old 05-29-2007, 06:50 PM
Knows the basics
 
Join Date: May 2007
Posts: 82
Default

Thank Erel, you answer so fast !
Reply With Quote
  #7 (permalink)  
Old 06-08-2007, 05:03 PM
Newbie
 
Join Date: May 2007
Location: Malaysia
Posts: 6
Send a message via Yahoo to anansath
Default

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.
Reply With Quote
  #8 (permalink)  
Old 06-08-2007, 05:27 PM
dzt's Avatar
dzt dzt is offline
Basic4ppc Veteran
 
Join Date: May 2007
Location: Greece
Posts: 353
Awards Showcase
Forum Contributer 
Total Awards: 1
Default

Extract from the attached zip the dbasic.exe.config in your b4ppc folder (where dbasic.exe exists)
Attached Files
File Type: zip Dbasic.exe.config.zip (282 Bytes, 75 views)
__________________
Dimitris Zacharakis
http://www.terracom.gr
Reply With Quote
  #9 (permalink)  
Old 06-08-2007, 06:44 PM
Erel's Avatar
Administrator
 
Join Date: Apr 2007
Posts: 2,778
Default

Please see the setup instructions of the SQL library: www.basic4ppc.com/Downloads.html
Reply With Quote
  #10 (permalink)  
Old 06-27-2007, 06:31 PM
Knows the basics
 
Join Date: Jun 2007
Location: Netherlands (Arnhem)
Posts: 71
Default

Quote:
Originally Posted by Erel View Post
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.
__________________
PPC: IPAQ 2210, 2GB, CF GPS, CF Wireless
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQLLite staement syntax aureolevoyager Questions & Help Needed 2 04-02-2008 10:14 PM
Hex To Dec To Hex Sample badkarma Code Samples & Tips 0 04-01-2008 05:26 PM
SQLLITE, Images blobs and 2.8 markbarrett_1 Questions & Help Needed 2 11-06-2007 06:02 AM
Problem compile SQLlite manu Questions & Help Needed 12 08-02-2007 08:26 AM
Problema SQLlite manu Spanish Forum 1 05-13-2007 06:36 PM


All times are GMT. The time now is 11:42 PM.


Powered by vBulletin® Version 3.6.10
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.1.0