Re: [sqlite] Segmentation Fault With Trigger

2013-10-14 Thread techi eth
Please provide me hint to solve the issue. Thanks.. On Fri, Oct 11, 2013 at 7:58 PM, techi eth wrote: > It is giving same trace what i have sent last time. > > It is possible by some one to send test code snapshot of scenario of > selecting user defined function while

Re: [sqlite] Consistent reads

2013-10-14 Thread Simon Slavin
On 14 Oct 2013, at 5:32pm, Jared Albers wrote: > Do SELECT statements automatically start a transaction in order to > obtain the SHARED lock? In other words, is the SHARED lock started as > a result of the SELECT statement or as a result of the transaction? I > was

Re: [sqlite] creating a random sub group

2013-10-14 Thread Gert Van Assche
Perfect! Wonderful. Thanks Igor. 2013/10/14 Igor Tandetnik > On 10/14/2013 11:36 AM, Gert Van Assche wrote: > >> my table contains a boolean SubGroup field that is set to 0 by default. >> I would like to update it so that for instance 100 of the 1000 records are >>

Re: [sqlite] Consistent reads

2013-10-14 Thread Jared Albers
Do SELECT statements automatically start a transaction in order to obtain the SHARED lock? In other words, is the SHARED lock started as a result of the SELECT statement or as a result of the transaction? I was reading the "SQL as Understood by SQLite" documentation and it says the following: "No

Re: [sqlite] creating a random sub group

2013-10-14 Thread Igor Tandetnik
On 10/14/2013 11:36 AM, Gert Van Assche wrote: my table contains a boolean SubGroup field that is set to 0 by default. I would like to update it so that for instance 100 of the 1000 records are randomly set to 1. Is this something that can be done using an SQL instruction? Try something like

[sqlite] creating a random sub group

2013-10-14 Thread Gert Van Assche
All, my table contains a boolean SubGroup field that is set to 0 by default. I would like to update it so that for instance 100 of the 1000 records are randomly set to 1. Is this something that can be done using an SQL instruction? Thanks Gert ___

Re: [sqlite] Performing Multiple SQL Statements Within A Transactions Using TCL

2013-10-14 Thread Tilsley, Jerry M.
>>-Original Message- >>From: sqlite-users-boun...@sqlite.org >>[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gerry Snyder >>Sent: Thursday, October 10, 2013 6:33 PM >>To: General Discussion of SQLite Database >>Subject: Re: [sqlite] Performing Multiple SQL Statements Within A

[sqlite] Slow debugging

2013-10-14 Thread Lukas Gebauer
Hello, I have a problem with latest 3.8.0.2 SQlite DLL (Win32). Some operations are very slow when my application is running inside debugger. I am using SQlite in my Delphi XE2. When I try to debug my application, SQlite operatiosn are slow. When I run same EXE outside debugger, all runing