Re: [sqlite] TCL Binding with VC6

yazan wasfi wrote: Hi All, I'm trying to compile sqlite with TCL enabled under VC6, Ive installed ActiveTCL8.4, and Added the include, lib, bin, to my VC6 project, when compiling the sqlite, I dont get any errors, but when trying to link it I get 49 errors like this Linking... tclsqlite.obj :

[sqlite] TCL Binding with VC6

Hi All, I'm trying to compile sqlite with TCL enabled under VC6, Ive installed ActiveTCL8.4, and Added the include, lib, bin, to my VC6 project, when compiling the sqlite, I dont get any errors, but when trying to link it I get 49 errors like this Linking... tclsqlite.obj : error LNK2001: unres

Re: [sqlite] Make test under windows

Thanks very Much, A.J. Millan, That works, - Original Message From: A.J.Millan <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, April 30, 2007 10:37:40 AM Subject: Re: [sqlite] Make test under windows Surely You must link those two files explicitly in yours project. A.J.M

Re: [sqlite] Re: Need Help with SQL Statement

This should do it: select * from Options o1 where rowid in ( select o2.rowid from Options o2 where o1.StockSymbol = o2.StockSymbol and o1.ExpiryDate=o2.ExpiryDate and o2.StrikePrice < o2.StockPrice limit 4); Thanks Igor, this doesn't work (no results are displayed) which may w

Re[2]: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

Hello drh, I'm happy with the new source release method. I was fine with the old way too. The new method is slightly more convenient for me when I upgrade. C Monday, April 30, 2007, 5:46:19 PM, you wrote: dhc> Martin Jenkins <[EMAIL PROTECTED]> wrote: >> >> As fas as I know, the dev team is

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

[EMAIL PROTECTED] wrote: Martin Jenkins <[EMAIL PROTECTED]> wrote: I agree, it is slightly odd for neither of them to reply. Why is it odd? Because you normally reply to these things, if only to say something lie "the pre-processed source for Windows is provided as a courtesy". ;) We hav

RES: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

-Mensagem original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 30 de abril de 2007 18:46 Para: sqlite-users@sqlite.org Assunto: Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14? Martin Jenkins <[EMAIL PROTECTED

RES: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

-Mensagem original- De: Bennett, Patrick [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 30 de abril de 2007 19:28 Para: sqlite-users@sqlite.org Assunto: RE: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14? People (myself being one of them)

[sqlite] Re: Need Help with SQL Statement

[EMAIL PROTECTED] wrote: I have a file with the columns: StockSymbol, OptionSymbol, StockPrice, StrikePrice, ExpiryDate For each StockSymbol, ExpiryDate, I would like to list just 4 of the records where the StrikePrice is lower than the StockPrice. This should do it: select * from Options o1

RE: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

People (myself being one of them) were asking if it could be put back the way it was. Several of us (those that replied at least) stated our dislike of the new single .c file format. It was also a question (hence the subject line). No one ever replied. It seemed like something worthy of at leas

RE: [sqlite] Need Help with SQL Statement

Use LIMIT 4 Thanks - Jon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, April 30, 2007 6:10 PM To: sqlite-users@sqlite.org Subject: [sqlite] Need Help with SQL Statement I have a file with the columns: StockSymbol, OptionSymbol, StockPrice, StrikeP

Re: [sqlite] Need Help with SQL Statement

see the LIMIT option On 4/30/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I have a file with the columns: StockSymbol, OptionSymbol, StockPrice, StrikePrice, ExpiryDate For each StockSymbol, ExpiryDate, I would like to list just 4 of the records where the StrikePrice is lower than the Sto

[sqlite] Need Help with SQL Statement

I have a file with the columns: StockSymbol, OptionSymbol, StockPrice, StrikePrice, ExpiryDate For each StockSymbol, ExpiryDate, I would like to list just 4 of the records where the StrikePrice is lower than the StockPrice. The following is close to what I want except it gives me all the row

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

Martin Jenkins <[EMAIL PROTECTED]> wrote: > > As fas as I know, the dev team is Dr Hipp and Dan Kennedy (apologies if > there's someone else and I missed you) and I agree, it is slightly odd > for neither of them to reply. > Why is it odd? The issue is not something that needs replying to. T

RES: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

-Mensagem original- De: Martin Jenkins [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 30 de abril de 2007 18:25 Para: sqlite-users@sqlite.org Assunto: Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14? Bennett, Patrick wrote: > I wasn't

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

Bennett, Patrick wrote: I wasn't sure who maintained the binary distribution and based on the recent list activity, I assumed someone who was responsible would've already replied. As fas as I know, the dev team is Dr Hipp and Dan Kennedy (apologies if there's someone else and I missed you) an

RE: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

Ok, thanks for pointing that out. I wasn't sure who maintained the binary distribution and based on the recent list activity, I assumed someone who was responsible would've already replied. Patrick -Original Message- From: Martin Jenkins [mailto:[EMAIL PROTECTED] Sent: Monday, April 30

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

Bennett, Patrick wrote: No comment at all? That's three users asking for this now. :( Dr Hipp usually responds pretty quickly, but sometimes he's away on business. You know, supporting the paying customers... ;) Martin --

RE: [sqlite] sqlite and borland c++ builder

Thanks for the response, people have generously sent me file that work and I'm up and running! Thanks - Jon -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Monday, April 30, 2007 10:31 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite and borland c++ buil

Re: [sqlite] Make test under windows

Surely You must link those two files explicitly in yours project. A.J.Millan > Hi All, > > I'm trying to compile sqlite3.3.16 under windows using MinGW, and MSYS, when typing make, it compiles correctly, but make test, give me 2 errors > gcc.exe user32.lib [no such file or directory] > gcc.exe

[sqlite] Make test under windows

Hi All, I'm trying to compile sqlite3.3.16 under windows using MinGW, and MSYS, when typing make, it compiles correctly, but make test, give me 2 errors gcc.exe user32.lib [no such file or directory] gcc.exe advapi32.lib [no such file or directory] I've checked the 2 files and they are on the

RE: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

No comment at all? That's three users asking for this now. :( Patrick -Original Message- From: Clark Christensen [mailto:[EMAIL PROTECTED] Sent: Friday, April 27, 2007 11:12 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] May I ask why the source distribution mechanism was changed

Re: [sqlite] sqlite and borland c++ builder

Jonathan Kahn wrote: When I try to use the header I get errors [C++ Error] sqlite3.h(1778): E2232 Constant member 'sqlite3_index_info::nConstraint' in class without constructors Jonathan, This is indeed a bug in the Borland/CodeGear compiler. It has been discussed on their mailin