RE: [sqlite] Unable to load DLL Help!

2005-11-20 Thread Matt
No, it doesn't appear to be related to this. -Matt -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Sunday, November 20, 2005 3:19 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Unable to load DLL Help! Was it related to this bug? Ticket 1474: SQLITE3.DLL

RE: [sqlite] Unable to load DLL Help!

2005-11-20 Thread Joe Wilson
Was it related to this bug? Ticket 1474: SQLITE3.DLL fails to load if address 0x6090 occupied http://www.sqlite.org/cvstrac/tktview?tn=1474 --- Matt <[EMAIL PROTECTED]> wrote: > For the archives...I finally solved this problem. I don't think the > distributed windows dll works with windows

Re: [sqlite] index question

2005-11-20 Thread Bert Verhees
Wilfried Mestdagh wrote: Hi, I'm a little confused how to create indexes. (beginners question, but I could not find or understeand clearly in FAQ). I have on a table following 3 selects: 'select distinct Name ' + 'from Rx ' + 'where RxDT >= ' + DT + ' ' + 'order by Name' 'select * ' +

[sqlite] index question

2005-11-20 Thread Wilfried Mestdagh
Hi, I'm a little confused how to create indexes. (beginners question, but I could not find or understeand clearly in FAQ). I have on a table following 3 selects: 'select distinct Name ' + 'from Rx ' + 'where RxDT >= ' + DT + ' ' + 'order by Name' 'select * ' + 'from Rx ' + 'where RxDt

Re[2]: [sqlite] query to get count of fields with different values

2005-11-20 Thread Wilfried Mestdagh
Hi Guillaume, > select distinct name from table_name; This does exacly what I want ! Thx :) --- Rgds, Wilfried http://www.mestdagh.biz

RE: [sqlite] Unable to load DLL Help!

2005-11-20 Thread Matt
For the archives...I finally solved this problem. I don't think the distributed windows dll works with windows 2003 (sp1). I downloaded the source and compiled it manually and everything works fine! Thanks Matt -Original Message- From: Chris Schirlinger [mailto:[EMAIL PROTECTED] Sent:

Re: [sqlite] query to get count of fields with different values

2005-11-20 Thread Guillaume MAISON
Wilfried Mestdagh a écrit : Hello, I'm not sure if subject make sence (English is not my mothers tongue), I try to explain: I have a table and a field called 'Name' can have a lot of the same but also different values. I want (if exists of course) to do a query where I only get as result the

[sqlite] query to get count of fields with different values

2005-11-20 Thread Wilfried Mestdagh
Hello, I'm not sure if subject make sence (English is not my mothers tongue), I try to explain: I have a table and a field called 'Name' can have a lot of the same but also different values. I want (if exists of course) to do a query where I only get as result the exclusive names. I give example