Download the free trial version
Basic4android Video
Features
Tutorials and manuals
Showcase
Screenshots

Go Back   Android Development Forum - Basic4android > Basic4ppc (Windows Mobile) > Questions (Windows Mobile)
Documentation Wiki Register Members List B4P Search Today's Posts Mark Forums Read

Questions (Windows Mobile) Post any question regarding Basic4ppc.

Another sqlite problem!

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-12-2007, 08:20 AM
giannimaione's Avatar
Basic4ppc Veteran
 
Join Date: Apr 2007
Location: Naples, Italy
Posts: 244
Send a message via Skype™ to giannimaione
Awards Showcase
Beta Tester 
Total Awards: 1
Default Another sqlite problem!

Hi all,

1) i have Basic4ppcV4-Full
2) i have not a pocket pc
3) i am using for my test Standalone Device Emulator 1.0 with Windows Mobile OS Images
4) i am testing sqlite

Now,
program test work fine on desktop compiled, but there is a follow message on ppc compiled when write (insert) data on mydb.sl3 :
some kind of disk i/o error occured.
where do i wrong?
Reply With Quote
  #2 (permalink)  
Old 05-12-2007, 08:51 AM
Erel's Avatar
Administrator
 
Join Date: Apr 2007
Posts: 15,732
Awards Showcase
Basic4ppc Founder 
Total Awards: 1
Default

Did you succeed running this sql example: http://www.basic4ppc.com/files/SQLExample.zip ?

What does the error message say?
Reply With Quote
  #3 (permalink)  
Old 05-12-2007, 09:46 AM
giannimaione's Avatar
Basic4ppc Veteran
 
Join Date: Apr 2007
Location: Naples, Italy
Posts: 244
Send a message via Skype™ to giannimaione
Awards Showcase
Beta Tester 
Total Awards: 1
Default

Hi Erel,
SQLExample work fine, no error message.
And also sqlcompiled (desktop and device) are not problem!!!!

in my case, the problem is command INSERT INTO .....
in SQLExample there is not INSERTO INTO ..... command

Can you post a your sample sbp with command INSERT ???

Grazie,
Gianni Maione
Reply With Quote
  #4 (permalink)  
Old 05-12-2007, 10:33 AM
Erel's Avatar
Administrator
 
Join Date: Apr 2007
Posts: 15,732
Awards Showcase
Basic4ppc Founder 
Total Awards: 1
Default

Add this code at the end of Sub App_Start:
Code:
  Cmd.CommandText = "INSERT INTO orders (OrderID, CustomerID) VALUES (98765,'ABCDE')"
    Cmd.ExecuteNonQuery
Reply With Quote
  #5 (permalink)  
Old 05-12-2007, 11:54 AM
giannimaione's Avatar
Basic4ppc Veteran
 
Join Date: Apr 2007
Location: Naples, Italy
Posts: 244
Send a message via Skype™ to giannimaione
Awards Showcase
Beta Tester 
Total Awards: 1
Default

no no no...
not work.
i have add code

Cmd.CommandText = "INSERT INTO orders (OrderID, CustomerID) VALUES (98765,'ABCDE')"
Cmd.ExecuteNonQuery

but i have same error:
some kind of disk i/o error occured.

Erel, listen me:
i use Standalone Device Emulator 1.0 with Windows Mobile OS Images,
and i have installed (first time) a demo of software "ORDERS",
and this software have installed:
microsoft sql, net cf 2.0 [it] and another.

After i start to testing sqlite,and i have not sure to follow your instruction about net cf and sqlite.

Now i reinstall all follow your instruction step by step.

I will notice you later.
Reply With Quote
  #6 (permalink)  
Old 05-13-2007, 07:25 AM
giannimaione's Avatar
Basic4ppc Veteran
 
Join Date: Apr 2007
Location: Naples, Italy
Posts: 244
Send a message via Skype™ to giannimaione
Awards Showcase
Beta Tester 
Total Awards: 1
Default

Hi Erel,
it is OK!
Problem is "Shared folder" in emulator Properties:
I have set c:\MyFolder as Storage Card,
but SQLITE do not write on it!!!!

see http://www.sqlite.org/c_interface.html
#define SQLITE_IOERR 10 /* Some kind of disk I/O error occurred */
and
SQLITE_IOERR

This value is returned if the operating system informs SQLite that it is unable to perform some disk I/O operation. This could mean that there is no more space left on the disk.
I have moved all files in a another folder of emulator "My Device\Temp" and
now is all ok!!!
Grazie, thanks you
Gianni
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 Off
Pingbacks are Off
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQlite problem Ricky D Questions (Windows Mobile) 1 10-04-2008 08:35 AM
Regarding SQLite problem mozaharul Questions (Windows Mobile) 0 04-02-2008 09:28 AM
Problem Converting CSV to SQLite tcgoh Questions (Windows Mobile) 5 11-01-2007 02:50 AM
SQLite Update Problem david Questions (Windows Mobile) 1 10-10-2007 11:22 AM
Problem mit SQLite und CheckBox Fontanus German Forum 6 05-06-2007 03:03 PM


All times are GMT. The time now is 06:20 AM.


Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0