Search the mail list for "Column name as a variable" for a similar discussion
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work
On Thu, 19 Feb 2015 07:21:17 -0800
Roger Binns wrote:
> There is a lot that would have to be done with it:
>
> - - make the IR stable across releases
> - - add more general instructions beyond only what is needed for SQL
> - - expose an API that takes the IR
> - - possibly redesign it to make
On 2/24/2015 8:42 PM, russ lyttle wrote:
> The 'a' table defines spaces to be controlled, the 'b' tables the
> control schedules and parameters.
> It would not be unreasonable to assume the 'a' table has >100 rows.
> Each row in the 'a' table is associated with 3 'b' tables, all the names
> known
On Wed, 18 Feb 2015 14:16:32 +0100
Staffan Tylen wrote:
> I suspect that this is wrong as nobody has suggested it but isn't
> this what triggers are meant to solve?
Triggers were invented before SQL defined what we now call Declarative
Referential Integrity (DRI). It is (I'm going to say)
ng list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
-- next part --
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL:
<http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150224/c2381c45/attachment.pgp>
On Wed, 18 Feb 2015 08:55:37 +0100
gunnar wrote:
instead of
> SELECT *
> FROM ordercallback
> WHERE account=@ACCOUNT
>AND cb_seq_num>(
> SELECT cb_seq_num
> FROM ordercallback
> WHERE cb_uuid=@CBUUID);
SELECT *
FROM ordercallback ocb
WHERE account=@ACCOUNT
AND exists (
Maybe a smaller number of downloads and a more readable download page would
improve the user experience here.
Mvh / Regards
Erik Ejlskov Jensen
http://twitter.com/erikej
Unusual output when trying a SQL Select statement from the command line
SQLite version 3.8.8.2 2015-01-30 14:30:45
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open taxi-invoicing-db
sqlite> .stats on
On 2/24/2015 4:37 PM, russ lyttle wrote:
> I'm trying to create a field in a table to hold the name of a second
> table, then retrieve that name for use.
You can't. SQL doesn't work this way. Reconsider your design.
--
Igor Tandetnik
--- next part --
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL:
<http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150224/3389318b/attachment.pgp>
On 24 February 2015 at 15:20, Simon Davies
wrote:
> On 24 February 2015 at 15:02, Grisha Vinevich wrote:
>> There seems to be some problem with left outer join in Windows version of
>> sqlite3.
>> I try to use the following (simplified) schema:
>>
.
.
.
>> When I run this on
On 24 February 2015 at 15:02, Grisha Vinevich wrote:
> There seems to be some problem with left outer join in Windows version of
> sqlite3.
> I try to use the following (simplified) schema:
>
> CREATE TABLE "A" ( "Name" text);
> CREATE TABLE "Items" ( "ItemName" text , "Name" text );
> INSERT
There seems to be some problem with left outer join in Windows version of
sqlite3.
I try to use the following (simplified) schema:
CREATE TABLE "A" ( "Name" text);
CREATE TABLE "Items" ( "ItemName" text , "Name" text );
INSERT INTO "Items" VALUES('Item1','Parent');
INSERT INTO "Items"
Thanks to Richard Hipp and Hick Gunter for their replies on this topic.
Given that support for support for BLOBs in virtual tables differs from that
for BLOBs in physical tables, is there any method or function available to the
sqlite3_x() caller that can be used to distinguish tables
On 2/24/2015 12:42 PM, Jonathan Camilleri wrote:
> Unusual output when trying a SQL Select statement from the command line
So what's unusual about it? What specifically seems to be the problem?
--
Igor Tandetnik
Hi,
When SQLite fails to create a file it tries reopening readonly and only if that
fails too it logs the error.
However by that time the original error (for file creation) is lost.
Testcase:
$ cat >testcase.sh
Erik Ejlskov Jensen wrote:
>
> Maybe a smaller number of downloads and a more readable download page
> would improve the user experience here.
>
Various parties have, at one time or another, requested each and every one
of the release package "variations" listed on the download page.
Do you
On 2/24/15, Grisha Vinevich wrote:
> There seems to be some problem with left outer join in Windows version of
> sqlite3.
Thanks for the report. This appears to be a query planner bug
introduced for SQLite version 3.8.8 by the check-in at
https://www.sqlite.org/src/timeline?c=d95d03
We'll
A possible (and small alternative) to readline would be Antirez "linenoise".
Steve Bennet's fork adds windows portability and some other things.
https://github.com/antirez/linenoise
https://github.com/msteveb/linenoise
That is small enough to be directly built as part of the shell, I
Incremental BLOB I/O makes certain assertions that cannot be guaranteed (much
less verified at runtime) for virtual tables (e.g. 1: unique rowids that 2: can
be used for access) and needs to know how to read/write them (which is under
the control of the virtual table author).
20 matches
Mail list logo