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

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 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 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 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 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
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 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
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! 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