Browse by Tags

error in dll or visual studio? is this a bug or what?

from this link http://sqlite.phxsoftware.com/forums/p/2209/8934.aspx#8934 i found the problem of my project i got a Can't find PInvoke DLL 'SQLite.Interop.065.DLL error when i insert images in the imagelist toolbox. I prefer to use imagelist than inserting images in the database because its easier...

Posted to General (Forum) by amw403 on 02-11-2010
Can't find PInvoke DLL 'SQLite.Interop.065.DLL - Bug?

Few days ago i can execute my program in a mobile device and emulator without any problem. But now i have the following error Can't find PInvoke DLL 'SQLite.Interop.065.DLL when i execute it in a mobile device but i can execute my program in an emulator (windows mobile 5 ppc r2 emulator) and...

Posted to General (Forum) by amw403 on 02-09-2010
exception is unhandled

private void GetImage() { SQLiteConnection sqlite_con = new SQLiteConnection("Data Source=|DataDirectory|dbasedict.s3db;Version=3;New=False;Compress=True;"); String querry2 = "select id, word, iimages from dictionario where word = '" + searchBox.Text + "'"; SQLiteDataAdapter...

Posted to How To (Forum) by amw403 on 02-07-2010
Re: Reading blob for pocket pc 5, c#, .net cf 3.5

I try this code private void GetImage(string fullName) { SQLiteConnection sqlite_con = new SQLiteConnection("Data Source=|DataDirectory|dbasedict.s3db;Version=3;New=False;Compress=True;"); String querry2 = "select iimages from dictionario where word = '" + searchBox.Text + "'";...

Posted to How To (Forum) by amw403 on 02-02-2010
Reading blob for pocket pc 5, c#, .net cf 3.5

i develop a mobile dictionary(ppc 5) with pictures i've searched this site and i found this thread: http://sqlite.phxsoftware.com/forums/t/1684.aspx the problem is that it gives me error because i think that some of the syntax(like fromstream and memomystream) is not supported in windows mobile any...

Posted to How To (Forum) by amw403 on 02-02-2010
Re: Can't find PInvoke DLL 'SQLite.Interop.059.DLL'.

I'm using SQLite 065 and I had the same problem. Deploying BOTH SQLite.Interop.065.DLL and SQLite.Interop.065.lib along with the main sqlite dll solved the problem and it's working like a charm. One more thing to mention is: SQLite is waaaaaaaaaaaaay much faster than SqlCe and I'm gonna fall...

Posted to General (Forum) by mmsaffari on 01-27-2010
Re: Foreign Key Support Version?

Hi Robert, Proper foreign key support is something l'd like to take advantage of with sqlite version >= 3.6.19. Do you have any idea when you'll be releasing the new provider? Great project btw. Thanks -Dano

Posted to Feature Requests (Forum) by dano_labrosse on 01-26-2010
System.Data.ConstraintException

Hi Guys, This is my first time using SQLite and I've run into an issue. I've got a SQLlite Database keeping a list of people and associated cost centres, it's pretty basic: Two tables, both with an ID column which is unique, autoincrement and primary key. Some other various columns, name...

Posted to General (Forum) by turkeywelder on 01-25-2010
fastest way to insert 100.000 records from one database to another

Hello, I have a mobile application. My client has a large data set ~100.000 records. It's updated frequently. When we sync we need to copy from one database to another. I have attached the second database to the main, and run a insert into table select * from sync.table This is extremely slow, it...

Posted to General (Forum) by pentium10 on 01-23-2010
can create database in winforms but cannot create database in windows mobile...

I try this code in winforms application in c# using System.Data.SQLite SQLiteConnection.CreateFile("Test3.s3db"); using (SQLiteConnection conn = new SQLiteConnection("Data Source=Test3.s3db;")) { conn.Open(); String Select = "CREATE TABLE if not exists Products2 (ProductNumber...

Posted to How To (Forum) by amw403 on 01-17-2010

Page 1 of 6 (54 items) 1 2 3 4 5 Next > ... Last »