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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
