Re: [sqlite] Providing incrementing column to query

Actually I just need a unique number - but sorted in code now. Thank You 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

Re: [sqlite] Providing incrementing column to query

Of course, if the traversal order is different than the row return order then you will not get ascending logical row numbers unless you do something like: select logicalrow() as SequenceNumber, t.* from (...query ...) as t; If you need logical row numbers it is much better (and far

Re: [sqlite] Providing incrementing column to query

Hmm thanks Clemens Have written an extension to do it - some of my tables are very big and feel that the extension might be a better route. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786

Re: [sqlite] Providing incrementing column to query

Paul Sanderson wrote: > I Have a number of queries to which I want to supply an incrementing column, > some of these queries involve without rowid tables. > > Is there a way of doing this with a SQL query? First, define a sort order, and ensure that it does not have duplicates. Then use a

Re: [sqlite] sqlite3 interactive shell failed assertions and segmentation faults

Thanks for the report. Thanks to Simon for verifying that these are all associated with the command-line shell only and not with the SQLite core. Note to Ryan: Please make sure your fuzzer is running inside a sandbox, in case the fuzzer discovers pernicious dot-commands like ".sy rm -rf ~" On

[sqlite] Providing incrementing column to query

I Have a number of queries to which I want to supply an incrementing column, some of these queries involve without rowid tables. I have no control over the design of the tables. So for a table defined as: CREATE TABLE (name text, age integer) with values Steve, 34 Eric, 27