Hi Gerry, thanks for you comments and words of luck, I will certainly need them.
Keep all your comments coming people. Thanks again. John. -----Original Message----- From: Gerry Snyder [mailto:[EMAIL PROTECTED] Sent: 13 December 2005 18:07 To: [email protected] Subject: Re: [sqlite] Final Year Project/Dissertation help required!!!! Robert L Cochran wrote: > .... It's better to learn something new than to sit in a lawn chair > swatting flies! This thread has been interesting to follow, since one of my main uses for computers is finding projects to work on in a futile but enjoyable attempt to keep my brain from ossifying. The latest has been writing a GUI for sqlite in Tcl/Tk. It started when in my musings with sqlite I realized I couldn't remember the names of my tables and the fields in them, and always had to have two instances of the CLI program and/or Tcl open; one for the work at hand and one to show the structure of the file. So the first need was for a window to show that. Of course it had to be able to open an existing file or create a new one. Since my understanding of my needs kept growing so did my data tables, and I added a complete Alter Table function. This is one of the biggest hunks of the script. A much smaller one is used to add a new table. Several of my tables have optional fields at the end, not always supplied by the input source, so I wrote an Import function, with user-defined delimiters, which has the option of rejecting or padding input lines which have an insufficient number of fields. As I did things in various directories I kept losing little Tcl routines I used for various functions, so I added the capability to store them in and execute them from the database. [puts] and [gets] were redefioned to work in the Tk environment. There are also windows for executing single lines of SQL or Tcl. When I got tired of the data displays not being aligned I started using tktable. This allowed spreadsheet-like editing of data--before that I had used stand-alone editing windows. When I decided to bite the bullet and make the move from SQLite2 to SQLite3 I added a conversion function (bidirectional). About the only other thing it does, and very poorly at that, is a Help function, which currently merely lists a text file. I wrote my own because I hate using a tool that does _almost_ everything I want, but needs help from another program or two to finish the task. So, my job has been much easier than Mr. Newby's. I had the luxury of creating things as needed, no need to implement the desire of others, and, at least most of the time, doing it on my own schedule. Good luck Mr. Newby, and have fun. SQLite is a wonderful environment, and this list is a great resource. Gerry -- This message has been scanned for viruses and dangerous content by the NorMAN MailScanner Service and is believed to be clean. The NorMAN MailScanner Service is operated by Information Systems and Services, University of Newcastle upon Tyne. ==== This e-mail is intended solely for the addressee. It may contain private and confidential information. If you are not the intended addressee, please take no action based on it nor show a copy to anyone. Please reply to this e-mail to highlight the error. You should also be aware that all electronic mail from, to, or within Northumbria University may be the subject of a request under the Freedom of Information Act 2000 and related legislation, and therefore may be required to be disclosed to third parties. This e-mail and attachments have been scanned for viruses prior to leaving Northumbria University. Northumbria University will not be liable for any losses as a result of any viruses being passed on.
