Hi I am trying to select (list) records by their index sequence BUT keep getting the SQL error.
"SQL error can't use index: Surname" . Indices showes the index ;---------------------------------------------------------------- ;Sample INDEX program ; CREATE TABLE "APPLE" ("MyName", "MySurname", "MyAge", PRIMARY KEY ("MyAge")); CREATE INDEX "Surname" on "APPLE" ("MySurname"); INSERT INTO "APPLE" VALUES ('Greg','Hooper', 54); INSERT INTO "APPLE" VALUES ('Daniel','Hooper', 30); INSERT INTO "APPLE" VALUES ('Nicole','Lvester', 32); INSERT INTO "APPLE" VALUES ('Rhonda','Grin', 50); Select * From "APPLE" INDEX BY "Surname"; Regards Greg. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users