Re: [sqlite] Problem with SQLite in BCB 4

2010-03-08 Thread a1rex
- Original Message >From: Simon Davies >The return from sqlite3_column_text is not valid after subsequent calls to any >of >sqlite3_step/sqlite3_reset/sqlite3_finalize. Yes. What about void *p = sqlite3_column_blob()? >From my tests it looks

Re: [sqlite] Problem with SQLite in BCB 4

2010-03-08 Thread a1rex
>> 2010/3/6 Chimerian : >> values.push_back((char*)sqlite3_column_text(statement, col)); >> // HERE IS ERROR ! >From: Simon Davies >What error? >I can not see why THIS line should provoke any error; This line will produce a runtime error when sqlite3_column_text(statement,

Re: [sqlite] Problem with SQLite in BCB 4

2010-03-08 Thread Simon Davies
2010/3/6 Chimerian : > I have a problem with SQLite in BCB 4.0. I wrote my own application - > I found very useful information on > http://www.dreamincode.net/forums/index.php?showtopic=122300 > > On form (Form1) I have: Memo1 and Button3. > > File Unit1.cpp: > > . . . .>        

Re: [sqlite] Problem with SQLite in BCB 4

2010-03-08 Thread a1rex
Chimerian, I compiled and tested the tutorial example (which you pointed out) with VC++ on XP Pro. Example is fine, except with the problem of not checking for NULL pointer, which I fixed for you. DB is created and values are stored and retrieved. No problem with SQLite or STL. I do not

Re: [sqlite] Problem with SQLite in BCB 4

2010-03-08 Thread Chimerian
Unfortunately I cant print the value of val before it's pushed to the values vector because when do that I got this same error - I think the problem is with pointer: char * ptr = (char*)sqlite3_column_text(statement, col); Maybe it hold wrong address ? I compile this code on Borland C++ Builder 6

Re: [sqlite] Porting Sqlite to MQX Operating system

2010-03-08 Thread GeoffW
Hi I wasted another entire day on this without really being able to grasp what the problem is. The call sequence is for the sqlite3OsClose() function Working Windows version pager_unlock() pPager->jfpd where pMethods =0 releaseAllSavepoints() pPager->sjfpd where pMethods =0 above 2 lines

Re: [sqlite] SQL Server 2005 and SQLite data types

2010-03-08 Thread Simon Slavin
On 8 Mar 2010, at 10:33am, Preeti1 wrote: > I want to do some mappings for SQL Server and SQLite data types.I went > through the link http://www.sqlite.org/datatype3.html for the data types.But > still confused with few data type mappings from sql server to sql ce. > Can anyone please tell me

[sqlite] SQL Server 2005 and SQLite data types

2010-03-08 Thread Preeti1
Hi, I want to do some mappings for SQL Server and SQLite data types.I went through the link http://www.sqlite.org/datatype3.html for the data types.But still confused with few data type mappings from sql server to sql ce. Can anyone please tell me the equivalent data type for sqlite for the

Re: [sqlite] Question about using SQLite3 on Windows Mobile 6+

2010-03-08 Thread noel frankinet
Anthony Papillion a écrit : Hello Anthony, Your windows Mobile device has a Arm processor, you will need to recompile sqlite.dll for that processor (with evc3+evc4 or visual studio 2005/2008) Best wishes Noël Frankinet > Hello Everyone, > > I'm totally new to SQLite and am trying to use it in