[sqlite] Connection Problem in Client machine

2011-08-20 Thread Madhankumar Rajaram
Hi, Can u please let me know how to make the connection string in Sqlite, so that it works both in my local development machine and client machine. As of now it works in my development machine, but not in client machine. Where should i place my sqlitedatabase (employee.db) file. Should i pl

Re: [sqlite] Suggest some Tools for Sqlite

2011-08-20 Thread Paul Linehan
2011/8/18 Madhankumar Rajaram : > I hope there should be some good Free or Licence Tools for using Sqlite. > For ex : Toad for Oracle. Hmmm Toad for SQLite - there's a thought. ;) > so, Kindly suggest the best Free / Licence Tool for using Sqlite > Thanks Try the Firefox extension - I t

Re: [sqlite] SQL query help

2011-08-20 Thread Paul Sanderson
Hmm thanks Roger Table could have a few million rows, i'll have a play and see what the run time is. The relevant column is indexed On 20 August 2011 17:14, Roger Andersson wrote: >  On 08/20/11 05:42 PM, Paul Sanderson wrote: >> Hi all >> >> I am trying to create a query that works to craete a

Re: [sqlite] SQL query help

2011-08-20 Thread Roger Andersson
On 08/20/11 05:42 PM, Paul Sanderson wrote: > Hi all > > I am trying to create a query that works to craete a subset of a table > based on duplicate items > > Examples work best so consider the contrived table with the following rows > 10 socata > 7 socata > 13 cessna > 2 piper > 7 piper > 55 pip

[sqlite] SQL query help

2011-08-20 Thread Paul Sanderson
Hi all I am trying to create a query that works to craete a subset of a table based on duplicate items Examples work best so consider the contrived table with the following rows 10 socata 7 socata 13 cessna 2 piper 7 piper 55 piper 1 diamond I want to see the subset that is 10 socata 7 socata 2

Re: [sqlite] SQLite + unicode

2011-08-20 Thread Jean-Christophe Deschamps
>I try this function. Do you have Visual Studio. i show you my example. > >NOCaut wrote: > > > > > > char * unicode_to_1251(wchar_t *unicode_string) Why are you converting Unicode to 1251? This is a lossy conversion in the general case. Work with Unicode strings end-to-end, using the UTF encod

Re: [sqlite] SQLite + unicode

2011-08-20 Thread NOCaut
this is my example spellings on the VS2008 http://www.4shared.com/file/RDzSVPZq/SQLite_example.html -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32301433.html Sent from the SQLite mailing list archive at Nabble.com. __

Re: [sqlite] SQLite + unicode

2011-08-20 Thread NOCaut
I try this function. Do you have Visual Studio. i show you my example. NOCaut wrote: > > > char * unicode_to_1251(wchar_t *unicode_string) > { > int err; > char * res; > int res_len = WideCharToMultiByte( > 1251, // Code page >

Re: [sqlite] SQLite + unicode

2011-08-20 Thread Kees Nuyt
On Sat, 20 Aug 2011 01:45:42 -0700 (PDT), NOCaut wrote: > For "" and '' i know thanks, and why you write ? > i want write arabic symbul Apparently your utf-8 Arabic characters were dropped and replaced by ?, probably by my mail reader. My apologies. Replace the '?'

Re: [sqlite] SQLite + unicode

2011-08-20 Thread NOCaut
For "" and '' i know thanks, and why you write ? i want write arabic symbul مثالمثالمثالمثال -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32300446.html Sent from the SQLite mailing list archive at Nabble.com. __