Re: [sqlite] sqlite + .net cf

2008-08-03 Thread Tom Lancaster
On Fri, Aug 1, 2008 at 5:49 PM, Στράτος Νικολαΐδης <[EMAIL PROTECTED]> wrote: > Tom Lancaster wrote: >> >> i'm considering using sqlite as a replacement for sql server ce in a >> mobile device that periodically syncs with a web server. > > It's the right thing to do. I did it and everything's

[sqlite] More on 'Works only for short strings'

2008-08-03 Thread David Nelson
More on 'works only for small strings': I replaced the sqlite3_exec code with sqlite3_prepare(), sqlite3_step() and sqlite3_finalize() only to find that it produced the same 'logic error' [SQLITE_ERROR] in the step() function. Then, I changed the way I create the record (below) to where I create

Re: [sqlite] More on 'Works only for short strings'

2008-08-03 Thread Alexey Pechnikov
Hello! If you can't write C++ code then write C code. I did send C example some time ago and there are a lot of examples in internet. Try to write and compile C code and after that you'll can start to learn C++. Best regards, Alexey. ___ sqlite-users

Re: [sqlite] More on 'Works only for short strings'

2008-08-03 Thread David Nelson
must be something i said that was confusing... I've been developing in C++ for over 20 years, programming in general for 45 years! dave On Sun, Aug 3, 2008 at 9:41 AM, Alexey Pechnikov <[EMAIL PROTECTED]> wrote: > Hello! > > If you can't write C++ code then write C code. I did send C example

Re: [sqlite] More on 'Works only for short strings'

2008-08-03 Thread Alexey Pechnikov
Hello! В сообщении от Sunday 03 August 2008 17:57:33 David Nelson написал(а): > must be something i said that was confusing...  I've been developing > in C++ for over 20 years, programming in general for 45 years! But why you wan't to try C code? Problem may be with MCF CString or your

Re: [sqlite] More on 'Works only for short strings'

2008-08-03 Thread David Nelson
ok, good idea and easy to do, so i did it converted CStrings to char szQ[32768] unfortunately, same problem On Sun, Aug 3, 2008 at 11:06 AM, Alexey Pechnikov <[EMAIL PROTECTED]>wrote: > Hello! > > В сообщении от Sunday 03 August 2008 17:57:33 David Nelson написал(а): > > must be something

Re: [sqlite] More on 'Works only for short strings'

2008-08-03 Thread David Nelson
for anyone still having patience with me, here are links to the created database and a log4.txt file which is the result of sqlite.exe cmd line doing a select * this is a link to the database http://www.savoysoft.com/EvtMgrRequestx05A this is a link to the log file

Re: [sqlite] More on 'Works only for short strings'

2008-08-03 Thread David Nelson
for anyone still having patience with me, here are links to the created database and a log4.txt file which is the result of sqlite.exe cmd line doing a select * this is a link to the database http://www.savoysoft.com/EvtMgrRequestx05A this is a link to the log file (corrected)

Re: [sqlite] More on 'Works only for short strings'

2008-08-03 Thread Hans-Juergen Taenzer
David Nelson ([EMAIL PROTECTED]) wrote: > Am now thinking there's something wrong with how sqlite gets > compiled (using MS Vers 6 Visual Studio) Switch off all optimisations when compiling. I more often had problems with MSVC in the past. Hans-Jürgen

Re: [sqlite] More on 'Works only for short strings'

2008-08-03 Thread Alexey Pechnikov
Hello! See code http://paste.pocoo.org/show/81137/ Compile as gcc sqlite_test.c -o sqlite_test -lsqlite3 Create table log in database log.db as $ sqlite3 log.db SQLite version 3.5.9 Enter ".help" for instructions sqlite> create table log(value); sqlite> .q Start program ./sqlite_test And

Re: [sqlite] More on 'Works only for short strings'

2008-08-03 Thread David Nelson
PROBLEM SOLVED Thank you Hans-Jürgen. Your suggestion to disable msvc compiler optimizations seems to have solved the problem... I can now create large records. MSVC optimizations apparently limited the size to 1024. Sorry for all the trouble I caused. Perhaps we learned something... for

Re: [sqlite] More on 'Works only for short strings'

2008-08-03 Thread Teg
Hello David, Sunday, August 3, 2008, 3:29:10 PM, you wrote: DN> PROBLEM SOLVED DN> Thank you Hans-Jürgen. DN> Your suggestion to disable msvc compiler optimizations seems to DN> have solved the problem... I can now create large records. MSVC DN> optimizations apparently limited the size to

[sqlite] Updating same tables in attached databases.

2008-08-03 Thread A. H. Ongun
I have two databases, an in memory main database consisting of a single table, and a disk based database consisting of multiple tables one of which is also the same table as the one in memory database. Let's say in memory database table "foo" consists of records 1-4000. The "foo" table in