> I cite from http://sqlite.org/faq.html#q6:
>
> "The restriction on moving database connections across threads was
> relaxed somewhat in version 3.3.1. With that and subsequent versions, it
> is safe to move a connection handle across threads as long as the
> connection is not holding any fcntl()
This is an auto-replied message. I have left Oracle. My new e-mail address is
n...@cryptonector.com.
Nico
--
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
This is an auto-replied message. I have left Oracle. My new e-mail address is
n...@cryptonector.com.
Nico
--
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 2/4/2011 11:14 AM, Scott Baker wrote:
> On 02/04/2011 04:00 AM, sqlite-users-requ...@sqlite.org wrote:
>> On 2/3/2011 12:10 PM, Scott Baker wrote:
#3) Query for customers who bought exactly 2 apples?
>> select CustomerID from Customers
>> group by CustomerID
>> having sum(Type = 'Apple')
On 02/04/2011 04:00 AM, sqlite-users-requ...@sqlite.org wrote:
> On 2/3/2011 12:10 PM, Scott Baker wrote:
>> > CREATE Table Customers (
>> >EntryID INTEGER PRIMARY KEY,
>> >CustomerID INT,
>> >Type ENUM
>> > );
>> >
>> > #1) Query for customers who*ONLY* bought apples
> select
On Fri, Feb 4, 2011 at 7:26 AM, Simon Slavin wrote:
>
> On 4 Feb 2011, at 9:42am, Dan Kennedy wrote:
>
> > The problem is that the trigger version is creating a statement journal
> > for each INSERT statement. It doesn't *really* need to, as there is no
> > way that this
On 4 Feb 2011, at 9:42am, Dan Kennedy wrote:
> The problem is that the trigger version is creating a statement journal
> for each INSERT statement. It doesn't *really* need to, as there is no
> way that this statement/trigger can hit a constraint after modifying
> any rows. However at the moment
On 02/04/2011 01:04 AM, Tiberio, Sylvain wrote:
> You're right!
>
> I checked the Solaris documentation the correct flag to compile
> multithread program is -D_REENTRANT.
>
> I have reconfigured and remade sqlite libs:
>./configure --enable-threadsafe CFLAGS=-D_REENTRANT
>make
>
> I have
On 02/04/2011 03:24 PM, Kevin Wojniak wrote:
>
> On Feb 3, 2011, at 10:35 PM, Dan Kennedy wrote:
>
>> Do you have a test program that we can use to reproduce this phenomenon?
>>
>> Dan.
>
> Here is a complete program:
> http://pastie.org/pastes/1527560
>
> Set USE_TRIGGER to see the trigger
On 4 February 2011 07:38, Andreas Otto wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hi,
>
> with "sqlite2_open" the parameter "filename" is used to specify the
> database location.
>
> Q: how I can retrieve this parameter from an open handle?
On Feb 3, 2011, at 10:35 PM, Dan Kennedy wrote:
> Do you have a test program that we can use to reproduce this phenomenon?
>
> Dan.
Here is a complete program:
http://pastie.org/pastes/1527560
Set USE_TRIGGER to see the trigger version.
Thanks,
Kevin
11 matches
Mail list logo