Clear Sql Data

[Ajay]

Hello

We have a desktop application, from where we had exported data to SQL (which has to be updated frequently) and copied in a folder on mobile sd card,

our problem is whenever we put new database in mobile it is not showing the latest updated data but it is showing old data which we had copied first time.

Can any one help us on how to show latest updated data.

Rgds

 

[hdtvirl]

sql data

Hello, are you sure you are opening the correct data base, is your path correct, if you copied the database from your PC to the device into what you think is the SD card then you need to copy the database from your external SD card to your internal sd card, there is. a post on this site which gives the different paths to the external SD card.

I don't have access to my laptop at present so I cant give you the actual info but if you do a search on external SD cards it should give you posting. Hope this helps.

Regards

BOB

 

[fatman]

Clear SQL-Data

Hi Ajay,

here is my approach. I wrote an application for scanners which i must update twice a year.
My pogram is running on a sd-card in the scanner in ONE directory (prog and sqlite.file) which works very well. Be sure to add a line like this in your program:
databaseFile = AppPath & "\database.lit"
I always create a NEW/BLANK Sqlite database due to this i´m sure having actual data.
I import the data from csv-files the first line of the csv contains the headernames of the rows too.
Im using Firefox with SQLITE MANAGER for working with sqlite tables. Very fast import!
Im using TOTAL COMMANDER with a plugin for WINDOWS CE Devices. This is cool cause you have full control over the device: copy/delete whatever you want where ever you want on the device.

Hope I could help a little bit.