Thanks for the advice, both. In the mean time we know that it indeed something else causing the problem.
gert 2013/5/2 Simon Slavin <[email protected]> > > On 2 May 2013, at 9:26am, Gert Van Assche <[email protected]> wrote: > > > I have a table with 2 fields that need to be exported to 2 TXT files but > > the order of the lines in the export should be exactly the same as in the > > table. > > Tables do not have order. Really. A table is a set of rows, not an > ordered set of rows. If you do not specify ORDER BY on a unique set of > values, the same SELECT can returns the same rows in different orders. > > > I tried to do it like this: > > SELECT [FieldA] FROM [T1] ORDER BY rowid; > > and > > SELECT [FieldB] FROM [T1] ORDER BY rowid; > > but the rowid order is not followed. The two TXT files that are created > are > > not in sync. > > If you have unique values in rowid, and really are doing those two > commands in the same transaction (so nothing can write to the table between > them), and getting rows returned in different orders, something is weird > about your setup. > > In your software do > > SELECT [FieldA],[FieldB] FROM [T1] ORDER BY rowid > > Use your software to make one text file from the first values and another > from the second values. It will be faster too ! > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
