how to get the max key.data?
779829Jun 17 2010 — edited Jul 22 2010My application is transfered from sqlite3, I don'n know how to get the max key.data and the sql like below:
SELECT * FROM t1 WHERE key1>=%d ORDER BY pkey;
The orginal sqlite3 table is like below:
create table t1 (pkey INTEGER PRIMARY KEY, key1 INTEGER, data1 INTEGER, data2 BLOB);