Re: [sqlite] select ... where [=] or [like]

2011-11-09 Thread hmas
Pavel Ivanov-2 wrote: > > On Wed, Nov 9, 2011 at 10:31 AM, hmas <i...@iode-informatique.fr> wrote: >>>> Thanks for your answer. >>>> foocol contains a string of numbers. >>>> The result of typeof(foocol) is text. >>> >>> And

Re: [sqlite] select ... where [=] or [like]

2011-11-09 Thread hmas
Pavel > > > On Tue, Nov 8, 2011 at 12:11 PM, hmas <i...@iode-informatique.fr> wrote: >> >> >> Simon Slavin-3 wrote: >>> >>> >>> On 8 Nov 2011, at 10:58am, hmas wrote: >>> >>>> My application insert into a table a

Re: [sqlite] select ... where [=] or [like]

2011-11-08 Thread hmas
Simon Slavin-3 wrote: > > > On 8 Nov 2011, at 10:58am, hmas wrote: > >> My application insert into a table a string of numbers (for exemple >> '98011295918220'. >> if I do (either from command line or from my c++ program) >> select foocol from footabl

[sqlite] select ... where [=] or [like]

2011-11-08 Thread hmas
select ... where [=] or [like] My application insert into a table a string of numbers (for exemple '98011295918220'. if I do (either from command line or from my c++ program) select foocol from footable where foocol = '98011295918220' the result set is empty but if I do select foocol

Re: [sqlite] Error (LOCKFILE_EXCLUSIVE_LOCK) at building sqlite project for pocket pc

2011-06-03 Thread hmas
we are trying to decide which devices to target... cleverly... Could you recommend good litterature on this topic and point us in the right direction? Thanks again for your time. Sincerely, -- hmas -- View this message in context: http://old.nabble.com/Error-%28LOCKFILE_EXCLUSIVE_LOCK%29-at-buildin

Re: [sqlite] Error (LOCKFILE_EXCLUSIVE_LOCK) at building sqlite project for pocket pc

2011-06-01 Thread hmas
Thank you for your answer. Actually, I managed to make it work by selecting "Windows Mobile 5.0 Pocket PC SDK" instead of "Pocket PC 2003" for the SDK in the procedure described in my first post. All the best, -- hmas -- View this message in context: http://

Re: [sqlite] Error (LOCKFILE_EXCLUSIVE_LOCK) at building sqlite project for pocket pc

2011-06-01 Thread hmas
was talking about. So, I was wondering if the problem mentionned above was fixed or not... and what I have to do. Thank you and all the best, -- hmas hmas wrote: > > Hi, > > Thank you for reading my post. > > I have downloaded the following archive: > http://www.sqlite.or

[sqlite] Error (LOCKFILE_EXCLUSIVE_LOCK) at building sqlite project for pocket pc

2011-06-01 Thread hmas
"Source files" section of the project, I added the existing item: - sqlite3.c When I choose "Build sqlite6", I get the following error: = Error 1 error C2065: 'LOCKFILE_EXCLUSIVE_LOCK' : undeclared identifier c:\sqlite\sqlite-amalgamation-3070603\sqlite3.c 32390 ==