Re: [sqlite] Trigger or sql to preserve order

On 3/13/2012 11:41 AM, Marco Bambini wrote: I have a table defined like: foo (id INTEGER, pid INTEGER, oid INTEGER) id is an unique identification number pid is parent_id oid is order_id and with some data like: id pid oid 74 1 1 42

[sqlite] Trigger or sql to preserve order

Hello, I have a table defined like: foo (id INTEGER, pid INTEGER, oid INTEGER) id is an unique identification number pid is parent_id oid is order_id and with some data like: id pid oid 74 1 1 42 1 2 28 0