10/27/18 Thanks so much Clements, Respectfully yours, Alex Stavis ---------- Original Message ---------- From: Clemens Ladisch <clem...@ladisch.de> 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
