Re: [sqlite] TCL Binding with VC6

2007-04-30 Thread Arjen Markus

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 : error LNK2001: unresolved external symbol __imp__Tcl_PkgProvide
tclsqlite.obj : error LNK2001: unresolved external symbol __imp__Tcl_Free
tclsqlite.obj : error LNK2001: unresolved external symbol __imp__Tcl_DStringFree
tclsqlite.obj : error LNK2001: unresolved external symbol __imp__Tcl_SetResult
tclsqlite.obj : error LNK2001: unresolved external symbol __imp__Tcl_Alloc
tclsqlite.obj : error LNK2001: unresolved external symbol 
__imp__Tcl_WrongNumArgs

I've included the c:/tcl/lib to my projects settings, but I'm not sure if there 
should be any other folders/files that should be added,
  
It looks as if you have left out a library in the link statement. The 
relevant library is tcl84.lib or if you compile

with stubs, tclstub84.lib in c:/tcl/lib.

Regards,

Arjen


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] TCL Binding with VC6

2007-04-30 Thread yazan wasfi
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: unresolved external symbol __imp__Tcl_PkgProvide
tclsqlite.obj : error LNK2001: unresolved external symbol __imp__Tcl_Free
tclsqlite.obj : error LNK2001: unresolved external symbol __imp__Tcl_DStringFree
tclsqlite.obj : error LNK2001: unresolved external symbol __imp__Tcl_SetResult
tclsqlite.obj : error LNK2001: unresolved external symbol __imp__Tcl_Alloc
tclsqlite.obj : error LNK2001: unresolved external symbol 
__imp__Tcl_WrongNumArgs

I've included the c:/tcl/lib to my projects settings, but I'm not sure if there 
should be any other folders/files that should be added,

Best regards, Yazan Wasfi

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: [sqlite] Make test under windows

2007-04-30 Thread yazan wasfi
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.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 advapi32.lib [no such file or directory]
>
> I've checked the 2 files and they are on the my path, anyone has any idea,
>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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

2007-04-30 Thread [EMAIL PROTECTED]




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 well 
be that I haven't implemented your solution correctly but it has 
certainly given me some idea about where to look and how to use LIMIT 4 
in a way that generates more than just a total of 4 rows.


I wouldn't be surprised if it turns out to be faster to just retrieve 
all records and skip over all but the first four in each group in your 
program.
I will explore this suggestion as well as your first suggestion seems to 
take an inordinately long time (even to display no records :) )


Thanks,
 Roger



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Teg
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 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.
>> 

dhc> Why is it odd?  The issue is not something that needs replying
dhc> to.  This is not a bug.  There has been a request for a different
dhc> kind of partially-compiled code distribution for the convenience
dhc> of some users.  We have observed the request. What more needs to 
dhc> be said?

dhc> --
dhc> D. Richard Hipp <[EMAIL PROTECTED]>


dhc> 
-
dhc> To unsubscribe, send email to [EMAIL PROTECTED]
dhc> 
-




-- 
Best regards,
 Tegmailto:[EMAIL PROTECTED]


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Martin Jenkins

[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 have observed the request. What more needs to be said?


Well, it appears the OP wanted something more to be said. I was just 
pointing out that you might be off-site.


Martin


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Marketing


-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]> 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.  This is not a bug.  There has been a request for a different
kind of partially-compiled code distribution for the convenience
of some users.  We have observed the request. What more needs to 
be said?

--
D. Richard Hipp <[EMAIL PROTECTED]>



-
To unsubscribe, send email to [EMAIL PROTECTED]

-


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/1/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/1/2003
 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Marketing


-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) 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 least a reply.

- Patrick Bennett

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 30, 2007 5:46 PM
To: sqlite-users@sqlite.org
Subject: 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.  This is not a bug.  There has been a request for a different
kind of partially-compiled code distribution for the convenience
of some users.  We have observed the request. What more needs to 
be said?

--
D. Richard Hipp <[EMAIL PROTECTED]>




-
To unsubscribe, send email to [EMAIL PROTECTED]

-


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/1/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/1/2003
 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Re: Need Help with SQL Statement

2007-04-30 Thread Igor Tandetnik

[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
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);


I wouldn't be surprised if it turns out to be faster to just retrieve 
all records and skip over all but the first four in each group in your 
program.


Igor Tandetnik 



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Bennett, Patrick
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 least a reply.

- Patrick Bennett

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, April 30, 2007 5:46 PM
To: sqlite-users@sqlite.org
Subject: 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.  This is not a bug.  There has been a request for a different
kind of partially-compiled code distribution for the convenience
of some users.  We have observed the request. What more needs to 
be said?

--
D. Richard Hipp <[EMAIL PROTECTED]>



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



RE: [sqlite] Need Help with SQL Statement

2007-04-30 Thread Jonathan Kahn
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, 
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 rows 
where the StrikePrice is less than StockPrice but I only want 4 rows (2 
PUTs & 2 CALLs) for each Stock and associated ExpiryDate.

SELECT StockSymbol,
OptionSymbol,
ExpiryDate,
StrikePrice,
StockPrice
FROM Options
WHERE nStrikePrice < StockPrice
ORDER BY StockSymbol,sExpiryDate, nStrikePrice DESC;

I would appreciate any suggestions on how I can generate an appropriate 
SQL statement.

Thanks,
  Roger


-
To unsubscribe, send email to [EMAIL PROTECTED]

-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Need Help with SQL Statement

2007-04-30 Thread P Kishor

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 StockPrice.

The following is close to what I want except it gives me all the rows
where the StrikePrice is less than StockPrice but I only want 4 rows (2
PUTs & 2 CALLs) for each Stock and associated ExpiryDate.

SELECT StockSymbol,
OptionSymbol,
ExpiryDate,
StrikePrice,
StockPrice
FROM Options
WHERE nStrikePrice < StockPrice
ORDER BY StockSymbol,sExpiryDate, nStrikePrice DESC;

I would appreciate any suggestions on how I can generate an appropriate
SQL statement.

Thanks,
  Roger

-
To unsubscribe, send email to [EMAIL PROTECTED]
-





--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
-
collaborate, communicate, compete
=

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Need Help with SQL Statement

2007-04-30 Thread [EMAIL PROTECTED]
 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 rows 
where the StrikePrice is less than StockPrice but I only want 4 rows (2 
PUTs & 2 CALLs) for each Stock and associated ExpiryDate.


SELECT StockSymbol,
   OptionSymbol,
   ExpiryDate,
   StrikePrice,
   StockPrice
FROM Options
WHERE nStrikePrice < StockPrice
ORDER BY StockSymbol,sExpiryDate, nStrikePrice DESC;

I would appreciate any suggestions on how I can generate an appropriate 
SQL statement.


Thanks,
 Roger

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread drh
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.  This is not a bug.  There has been a request for a different
kind of partially-compiled code distribution for the convenience
of some users.  We have observed the request. What more needs to 
be said?

--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Marketing


-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 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) and I agree, it is slightly odd 
for neither of them to reply.

In the interim, could you find an old PC, install Linux on it and build 
the preprocessed sources locally? Another option might be to install 
something like Cygwin on one of your Windows boxes.

Martin


-
To unsubscribe, send email to [EMAIL PROTECTED]

-


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/1/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/1/2003
 


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Martin Jenkins

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) and I agree, it is slightly odd 
for neither of them to reply.


In the interim, could you find an old PC, install Linux on it and build 
the preprocessed sources locally? Another option might be to install 
something like Cygwin on one of your Windows boxes.


Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Bennett, Patrick
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, 2007 4:09 PM
To: sqlite-users@sqlite.org
Subject: 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


-
To unsubscribe, send email to [EMAIL PROTECTED]

-




-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Martin Jenkins

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

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Jonathan Kahn
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++ 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 mailing lists several times and is currently in their 
bug tracking system http://qc.codegear.com/wc/qcmain.aspx?d=32959.

I just posted a message when I ran into the same problem trying to use a 
current version of sqlite see  
http://groups.google.ca/group/borland.public.cppbuilder.language.cpp/browse_
frm/thread/f04139e048a2f55/98b6a1c5616057b4?lnk=st&q=sqlite+E2232+&rnum=1#98
b6a1c5616057b4
I forgot that I had ran into this problem earlier. It hasn't been a huge 
issue for me since most of my sqlite use is done with an older version 
of sqlite (3.2.7) that doesn't trigger this problem.

You can work around the problem by creating a modified sqlite3.h header 
that eliminates the const qualifiers from the offending declarations. 
You could also comment out the entire structure definition and change 
the type of the second argument to xBestIndex to a void pointer if you 
are not going to use the virtual table interfaces. or you could use an 
older version from before June of 2006 when these items were added to 
the header file.

I have had no problems building either a dll or a static library using 
the Borland compiler in C mode. The problems occur when you try to 
include the standard sqlite3.h header into a C++ source file.

It might help to post to the newsgroups saying you are also having 
problems, or to vote on the bug in the QC system.

HTH
Dennis Cote




-
To unsubscribe, send email to [EMAIL PROTECTED]

-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] Make test under windows

2007-04-30 Thread A.J.Millan
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 advapi32.lib [no such file or directory]
>
> I've checked the 2 files and they are on the my path, anyone has any idea,
>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] Make test under windows

2007-04-30 Thread yazan wasfi
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 my path, anyone has any idea,
 
Thankx

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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

2007-04-30 Thread Bennett, Patrick
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 starting with 3.3.14?

In general, I agree.  I miss the zipped set of pre-processed C source.

Since you have the Linux-based build system at your disposal, you can
get what you're used to having with

make target_source

on the Linux system.  This creates a tsrc directory containing the
familiar pre-processed C source for use in your Windows build.

For what it's worth, I was able to build the sqlite3.dll on Windows
(VC6) from the "amalgam" sqlite3.c file without having to have lemon or
any of the other SQLite-specific build components - except that pesky
sqlite3.def file.  I still have to download the precompiled Win32 DLL to
get that.

Looking at the generated makefile (from the configure script) on Linux,
I see there's a rule for making sqlite3.def.  The algorithm (grep ... |
sed ...) basically works on Windows, using the sqlite3.obj, but the
resulting def is short a few lines compared to the one I downloaded.

Last, I tried to build the shell from the compiled amalgam, but it
errors-out on the link phase complaining about unresolved externals
(sqlite3_iotrace or somesuch).  And I don't have time right now to
figure it out.  I'm not a C programmer, and am unfamiliar with
compilers, linkers, compiler options, and all that.  I usually just have
to do trial and error (lots of error) and eventually I figure it out.

 -Clark

- Original Message 
From: "Bennett, Patrick" <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, April 27, 2007 6:57:38 AM
Subject: [sqlite] May I ask why the source distribution mechanism was
changed starting with 3.3.14?

The last time I downloaded SQLite was version 3.3.12.
For that version (and many prior versions), I could download a
preprocessed archive containing all of the source code, except parse.h,
parse.c and opcode.h(? - this is from memory) were the 'generated'
versions.
The source for the command-line shell was there as well as all other
source code.  This was close to ideal for me, as I was able to use it in
our (custom) build system and build for Windows and Linux with almost no
effort at all.
Now, I have two choices:  
1) Download a tar of everything and have a version of lemon available
(which nothing else here uses), as well awk and other tools which don't
fit well within our windows-side compiles, or..
2) Download a preprocessed archive that contains only two files
(sqlite3.c and sqlite3.h) losing the ability to easily track changes (or
make local patches / fixes if necessary) as well as no longer having the
shell code.  I'll have to download both archives and piece together my
own build.

Hopefully this doesn't come off as too much of a nag, but the way it was
before was quite convenient and the new method seems to have taken the
'preprocessed' notion to the extreme.  
If this is how it's going to be from now on, I'll just have to adjust,
but if there wasn't any specific reason for changing, you can count this
as a vote for the 'old' way.  :)

Cheers...
Patrick Bennett



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



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

2007-04-30 Thread Dennis Cote

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 mailing lists several times and is currently in their 
bug tracking system http://qc.codegear.com/wc/qcmain.aspx?d=32959.


I just posted a message when I ran into the same problem trying to use a 
current version of sqlite see  
http://groups.google.ca/group/borland.public.cppbuilder.language.cpp/browse_frm/thread/f04139e048a2f55/98b6a1c5616057b4?lnk=st&q=sqlite+E2232+&rnum=1#98b6a1c5616057b4
I forgot that I had ran into this problem earlier. It hasn't been a huge 
issue for me since most of my sqlite use is done with an older version 
of sqlite (3.2.7) that doesn't trigger this problem.


You can work around the problem by creating a modified sqlite3.h header 
that eliminates the const qualifiers from the offending declarations. 
You could also comment out the entire structure definition and change 
the type of the second argument to xBestIndex to a void pointer if you 
are not going to use the virtual table interfaces. or you could use an 
older version from before June of 2006 when these items were added to 
the header file.


I have had no problems building either a dll or a static library using 
the Borland compiler in C mode. The problems occur when you try to 
include the standard sqlite3.h header into a C++ source file.


It might help to post to the newsgroups saying you are also having 
problems, or to vote on the bug in the QC system.


HTH
Dennis Cote



-
To unsubscribe, send email to [EMAIL PROTECTED]
-