Re: [sqlite] Connection Problem in Client machine [May not be the real sender, open with care]

2011-08-21 Thread Madhankumar Rajaram
FYI, I am using Windows application (.Net2010 C# with sqlite) 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. //conn

[sqlite] update required

2011-08-21 Thread Amy
Hello, my computer needs to update its SQlite program but when I get to your site for updates there's a lot of options and I don't know which I should try to download. Also I picked one randomly and it opened a window that requires to type some commands. I don't know the commands to type. Could you

Re: [sqlite] update required

2011-08-21 Thread Stephan Beal
On Sun, Aug 21, 2011 at 4:08 AM, Amy wrote: > Hello, my computer needs to update its SQlite program but when I get to > your > site for updates there's a lot of options and I don't know which I should > Why are you so certain that your PC needs a new SQLite? If a specific program is telling you

Re: [sqlite] update required

2011-08-21 Thread Richard Hipp
On Sun, Aug 21, 2011 at 6:20 AM, Stephan Beal wrote: > On Sun, Aug 21, 2011 at 4:08 AM, Amy wrote: > > > Hello, my computer needs to update its SQlite program but when I get to > > your > > site for updates there's a lot of options and I don't know which I should > > > > Why are you so certain t

Re: [sqlite] SQLite + unicode

2011-08-21 Thread NOCaut
Thanks i change 1251 to CP_UTF8 All work :jumping: -- View this message in context: http://old.nabble.com/SQLite-%2B-unicode-tp32296232p32301685.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@s

Re: [sqlite] select distinct

2011-08-21 Thread Yonnas Beyene
Yep, index on columns in the where close in the order they appear solved this problem. In fact, it was twice as fast as sql server. On Tue, Aug 16, 2011 at 4:47 PM, Simon Slavin wrote: > > On 16 Aug 2011, at 10:05pm, Yonnas Beyene wrote: > > > SELECT distinct Table1.Column1, Table2.Column2, Tab