Re: [sqlite] Help!
10/27/18 Thanks so much Clements, Respectfully yours, Alex Stavis -- Original Message -- From: Clemens Ladisch To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Help! Date: Sat, 27 Oct 2018 21:55:28 +0200 am...@juno.com wrote: > how do I make a field wrap the text. In other words, rather than having > the text in a field keep going from right to left, when I hit the right > hand margin, how do I make the text automatically go to the next line. The purpose of SQLite is to store data, and to give it back to you unchanged. How the data is formatted for displaying is not the database's concern. It is likely that the software that you're using to display fields has an option for automatic word wrapping, but nobody here knows what software that is. > how do I simultaneously nest two or more fields. For instance, if I have > four fields: name, department, clock number, department, how do I nest so > that I alphabetically, sort by the clock number, then last name within > each department, and ten clock number within in each name? Just put the column names in this order in the ORDER BY clause when doing the SQL query. (Assuming that whatever software you're using allows you to customize the query.) Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users No More Tinnitus: 1 Odd Trick Ends The Ringing Overnight fighttinnitusnow.com http://thirdpartyoffers.juno.com/TGL3131/5bd4e14437d6a61444dd4st04vuc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!
10/27/18 Thanks so much Clements, Respectfully yours, Alex Stavis -- Original Message -- From: Clemens Ladisch To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Help! Date: Sat, 27 Oct 2018 21:55:28 +0200 am...@juno.com wrote: > how do I make a field wrap the text. In other words, rather than having > the text in a field keep going from right to left, when I hit the right > hand margin, how do I make the text automatically go to the next line. The purpose of SQLite is to store data, and to give it back to you unchanged. How the data is formatted for displaying is not the database's concern. It is likely that the software that you're using to display fields has an option for automatic word wrapping, but nobody here knows what software that is. > how do I simultaneously nest two or more fields. For instance, if I have > four fields: name, department, clock number, department, how do I nest so > that I alphabetically, sort by the clock number, then last name within > each department, and ten clock number within in each name? Just put the column names in this order in the ORDER BY clause when doing the SQL query. (Assuming that whatever software you're using allows you to customize the query.) Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Study Reveals What Just A Single Diet Soda Does To Your... nucific.com http://thirdpartyoffers.juno.com/TGL3131/5bd4e08e9cb8608d3d62st04vuc ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!
Hi, On Sat, Oct 27, 2018 at 1:41 PM am...@juno.com wrote: > > 10/27/18 Dear Good People: I have two issues which I have not been able to > solve. Hopefully at least one of you good people know how to do these. The > first is: how do I make a field wrap the text. In other words, rather than > having the text in a field keep going from right to left, when I hit the > right hand margin, how do I make the text automatically go to the next line. > The second is: how do I simultaneously nest two or more fields. For instance, > if I have four fields: name, department, clock number, department, how do I > nest so that I alphabetically, sort by the clock number, then last name > within each department, and ten clock number within in each name? As always, > if you have any questions, need more information, and/or need any > clarifications, ask away. Respectfully yours, Alex Stavis On top of all other people told you - you most likely have an error in you schema. The department field appears twice in you table. Thank you. > > Gut Doctor Begs Americans - "Throw This Vegetable Now" > food-frauds.com > http://thirdpartyoffers.juno.com/TGL3131/5bd4b12c4eb0b312c7c70st03vuc > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Help!
am...@juno.com wrote: > how do I make a field wrap the text. In other words, rather than having > the text in a field keep going from right to left, when I hit the right > hand margin, how do I make the text automatically go to the next line. The purpose of SQLite is to store data, and to give it back to you unchanged. How the data is formatted for displaying is not the database's concern. It is likely that the software that you're using to display fields has an option for automatic word wrapping, but nobody here knows what software that is. > how do I simultaneously nest two or more fields. For instance, if I have > four fields: name, department, clock number, department, how do I nest so > that I alphabetically, sort by the clock number, then last name within > each department, and ten clock number within in each name? Just put the column names in this order in the ORDER BY clause when doing the SQL query. (Assuming that whatever software you're using allows you to customize the query.) Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Optmize queries on ranges
> Keith Medcalf wrote: > .. Am I doing something wrong here .. No! The query with order by + limit 1 is superior, also in my test. Still I am surprised that the rtree extension is available by default (at least in the sqlite version 3.25 command line) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users