RE: [sqlite] SQL to renumber values in a column?

Hi Dave If you query the database with order by, the result sequence is the order you are looking for, so you donot need to update at all. Like: select * from table order by order_number Row 1: a, 1 Row 2: c, 3 Row 3: d, 4 The result-set row number is the order you are looking for. Regards. Xu

RE: [sqlite] Follow up question about security

I understand that I got to encrypt and decrypt it, but what happened for the indexed column? If I have a collate column at Chinese PINYIN, after you encrypt it, the sorting method will be broken, so is there any encrypt algorithm donot loose sorting sequence? Or collate and encrypt need to have

[sqlite] Follow up question about security

I have a follow up question about this too. In case I did password protection, does it encrypt the data, what happened if somebody use HEX reader to read the original database file? If we encrypt the whole database, then sorting (specially COLLATE sorting) will have trouble, how to deal with t

RE: [sqlite] Problems after installation.

Hi, Aghiles SQLite use posix file locking, it doesnot work at some NFS system, also it doesnot work at clearcase MVFS too. You should douoble check your file system. Regards. Xuezhang. -Original Message- From: Aghiles Kheffache [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 1

RE: [sqlite] SQL Commands Again

Hi, John SQLITE have the SQL syntax in the helper page(http://www.sqlite.org/lang.html), I donot think most of the SQL statement will work in SQLite. Xuezhang. -Original Message- From: John Mistler [mailto:[EMAIL PROTECTED] Sent: Sunday, August 01, 2004 8:03 PM To: [EMAIL PROTECTED] S