Hi, My current database is mainly names and addresses. Most of my record viewing is done by: "select * from TableName order by Zip,Address,No"
Zip, Address and No (house number) have separate indexes. On other databases I have used, I have combined these three columns into one index, and used that index to display records I tried creating a new index, "create index DefView on TableName(Zip,Address,No)" SQLite didn't complain about that, but when I tried to use the index, by using "select * from TableName order by DefView" I didn't get any records returned to view I have obviously got the wrong end of the stick about indexes! Could someone put me right, or point me gently in the right direction? Thanks, Brian Pugh
