Re: [sqlite] Newbie question on Data Source
Michael, #1 Thanks for the comments. I have the book, The Definitive Guide to SQLite from Apress by Michael Owens, but it is the 2006 first edition. Do you, or anyone, know if the new or 2nd edition is worth buying or does it just cover 1 new item? I am not afraid to buy books. You should see my VB6 collection. :) Can you recommend a must have well written database design book? #2 Believe me, I know it is hard to get out of my VB6 and if I knew it would work forever, I probably wouldn't. But Microsoft dropped support years ago. I started with a TI994A and moved up to a Commodore C64 and actually ran a BBS with SCSI hard drives attached to it. Did the same with a Commodore C128. Still have the equipment and it still works. I build all my computers. I have the Visual Studio Pro so I can look at C# but I had C++ in my Classic Studio and stayed with Visual Basic. For my needs it is powerful enough. #3 This list has helped me get set up as I found the old ADO provider (1.0.66) and had some questions on the correct package to download from the System.Data.SQLite. Then the designer was missing but now I see it is almost ready and will come out next release. That is good. My database needs or wants are simple at the present time. When I wrote my main app that is shareware I couldn't quite figure out the data base stuff and I also was worried someone would just steal my data base and use it to form a competing product. The password with Access seemed easy to break if you Googled it. So I hard coded my data into the app but that made it a bunch of extra work to add new items in the proper order that was necessary as there were multiple fields. As I rewrite the app, the main reason for all this upgrading, I will surely come up with new situations and challenges. Simple things come to mind like allowing the end user to change the data, but if they muck it up, allow them to get back to the default data base. My app deals with formulas that require accuracy and hard coding data preserves that. The another reason I stayed away from .NET as I read how easy it was for people to steal your hard work. I read about Obfuscation and it seemed like it may or may not work all that good, but it looks like that is all we have so I have to trust it. Visual Studio Pro comes with a standard or basis Obfuscator but I have found other ones for free and some costing in the thousands. Dave On 11/29/2011 6:17 AM, Black, Michael (IS) wrote: I'll note a few things here... #1 If you want to learn about "database design" or "how to code in language X" get a book on those and not on a particular product (you may want the product book too if you need it but those tend to be less helpful). #2 Your first language will be hard to get "out of". I've done over 60 languages now and C# is one of only a few that I was impressed with and worth the trouble to learn. Ada was the other one (but for completely different reasons). I still prefer C though C++ can be more helpful at times (advanced data structures). #3 This list is probably one of the best learning things you can do that doesn't take "study time". When somebody poses a problem try to solve it yourself without seeing the "answer" that inevitably comes up here. One of the better ways of learning is doing. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/29/2011 12:17 PM, Black, Michael (IS) wrote: > I'll note a few things here... [snip] Much good advice. Seconded! ABS - -- Alaric Snell-Pym http://www.snell-pym.org.uk/alaric/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk7UzwwACgkQRgz/WHNxCGo8YQCfbuHuGn+TswVZvoaBdKvvUTfc LuIAnRklSLS0P/KgE29lF6GHuvlnnonq =U2zn -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
I'll note a few things here... #1 If you want to learn about "database design" or "how to code in language X" get a book on those and not on a particular product (you may want the product book too if you need it but those tend to be less helpful). #2 Your first language will be hard to get "out of". I've done over 60 languages now and C# is one of only a few that I was impressed with and worth the trouble to learn. Ada was the other one (but for completely different reasons). I still prefer C though C++ can be more helpful at times (advanced data structures). #3 This list is probably one of the best learning things you can do that doesn't take "study time". When somebody poses a problem try to solve it yourself without seeing the "answer" that inevitably comes up here. One of the better ways of learning is doing. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Dave [thesche...@cox.net] Sent: Monday, November 28, 2011 5:24 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Newbie question on Data Source On 11/28/2011 4:59 PM, Simon Slavin wrote: > On 28 Nov 2011, at 10:44pm, Dave wrote: > >> On 11/28/2011 4:37 PM, Simon Slavin wrote: >>> Just to stress that the filename includes the bit after the '.'. You can >>> have any number of files with the same part before the '.' but different >>> extensions. To tell the operating system which one you want you must >>> include the bit after the '.'. >> Actually, I knew that. Just having a bit of a multiple crash course...all >> at once. I just recently built this pc and have been on XP until recently >> too. I do some graphic stuff and have many same named pics with the various >> .jpg, .bmp, .gif extensions. > My job involves dealing with lots of people who aren't good at computers and > the fact that, by default, the OS hides file extensions confuses the hell out > of them. I'm not taking a shot at Windows here: the Macintosh OS does the > same thing. > > It also means you see files with names like 'paper.doc.docx.docx.PDF'. > > Simon. I hear you... I once had a shareware app that I bought that the guy that coded it had a weird way of saving progress by nesting folders all named the same. I was watching a backup app once and thought, wtf, when I saw \Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\. I am pretty good with computers actually but still can get caught looking like a nob here and there. :-) I am one of the guys that was a diehard VB6 Classic user and when I upgraded to .NET 2002 I was instantly mad at the so called VB7 as it was nothing like the upgrade we were expecting or wanting. I got the $20 update for .NET 2003 and looked at it and stayed with VB6 Classic. I looked at Delphi, RealBASIC, and PowerBasic, and realized I like VB. Now I thought I better get caught up before Win8 starts messing with legacy apps. And as far as data base programming, I am still a noob. I read all the thick Access books years ago and spent a lot of time trying to learn but always reached a point where I got totally confused when it came to design and primary and foreign keys and relationship designer views. So here I go again. I don't give up easy. Thanks, Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
On 11/28/2011 4:59 PM, Simon Slavin wrote: On 28 Nov 2011, at 10:44pm, Dave wrote: On 11/28/2011 4:37 PM, Simon Slavin wrote: Just to stress that the filename includes the bit after the '.'. You can have any number of files with the same part before the '.' but different extensions. To tell the operating system which one you want you must include the bit after the '.'. Actually, I knew that. Just having a bit of a multiple crash course...all at once. I just recently built this pc and have been on XP until recently too. I do some graphic stuff and have many same named pics with the various .jpg, .bmp, .gif extensions. My job involves dealing with lots of people who aren't good at computers and the fact that, by default, the OS hides file extensions confuses the hell out of them. I'm not taking a shot at Windows here: the Macintosh OS does the same thing. It also means you see files with names like 'paper.doc.docx.docx.PDF'. Simon. I hear you... I once had a shareware app that I bought that the guy that coded it had a weird way of saving progress by nesting folders all named the same. I was watching a backup app once and thought, wtf, when I saw \Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\\Folder1\. I am pretty good with computers actually but still can get caught looking like a nob here and there. :-) I am one of the guys that was a diehard VB6 Classic user and when I upgraded to .NET 2002 I was instantly mad at the so called VB7 as it was nothing like the upgrade we were expecting or wanting. I got the $20 update for .NET 2003 and looked at it and stayed with VB6 Classic. I looked at Delphi, RealBASIC, and PowerBasic, and realized I like VB. Now I thought I better get caught up before Win8 starts messing with legacy apps. And as far as data base programming, I am still a noob. I read all the thick Access books years ago and spent a lot of time trying to learn but always reached a point where I got totally confused when it came to design and primary and foreign keys and relationship designer views. So here I go again. I don't give up easy. Thanks, Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
On 28 Nov 2011, at 10:44pm, Dave wrote: > On 11/28/2011 4:37 PM, Simon Slavin wrote: >> Just to stress that the filename includes the bit after the '.'. You can >> have any number of files with the same part before the '.' but different >> extensions. To tell the operating system which one you want you must >> include the bit after the '.'. > Actually, I knew that. Just having a bit of a multiple crash course...all at > once. I just recently built this pc and have been on XP until recently too. I > do some graphic stuff and have many same named pics with the various .jpg, > .bmp, .gif extensions. My job involves dealing with lots of people who aren't good at computers and the fact that, by default, the OS hides file extensions confuses the hell out of them. I'm not taking a shot at Windows here: the Macintosh OS does the same thing. It also means you see files with names like 'paper.doc.docx.docx.PDF'. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
Thanks Simon, Actually, I knew that. Just having a bit of a multiple crash course...all at once. I just recently built this pc and have been on XP until recently too. I do some graphic stuff and have many same named pics with the various .jpg, .bmp, .gif extensions. Dave On 11/28/2011 4:37 PM, Simon Slavin wrote: On 28 Nov 2011, at 10:32pm, Igor Tandetnik wrote: On 11/28/2011 5:23 PM, Dave wrote: Ok, I switched that and now my original database file has a .db added whereas the one created by my app stays the same. It doesn't have .db added. It had it all along, you just couldn't see it. Anyway, now you can name your file however you want. Make sure that, whichever name you choose, you use the same name in the connection string. Just to stress that the filename includes the bit after the '.'. You can have any number of files with the same part before the '.' but different extensions. To tell the operating system which one you want you must include the bit after the '.'. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
Thanks Igor, I am just getting started so I am bound to get tripped up a little. :-) That was going to be my next question anyhow, about the database name. I was thinking we *had* to have the extension .db3 but you have answered that. I just have been using VB.Net less than 30 days and that doesn't help any. Cheers, Dave On 11/28/2011 4:32 PM, Igor Tandetnik wrote: On 11/28/2011 5:23 PM, Dave wrote: Ok, I switched that and now my original database file has a .db added whereas the one created by my app stays the same. It doesn't have .db added. It had it all along, you just couldn't see it. Anyway, now you can name your file however you want. Make sure that, whichever name you choose, you use the same name in the connection string. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
On 28 Nov 2011, at 10:32pm, Igor Tandetnik wrote: > On 11/28/2011 5:23 PM, Dave wrote: >> Ok, I switched that and now my original database file has a .db added >> whereas the one created by my app stays the same. > > It doesn't have .db added. It had it all along, you just couldn't see it. > > Anyway, now you can name your file however you want. Make sure that, > whichever name you choose, you use the same name in the connection string. Just to stress that the filename includes the bit after the '.'. You can have any number of files with the same part before the '.' but different extensions. To tell the operating system which one you want you must include the bit after the '.'. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
On 11/28/2011 5:23 PM, Dave wrote: Ok, I switched that and now my original database file has a .db added whereas the one created by my app stays the same. It doesn't have .db added. It had it all along, you just couldn't see it. Anyway, now you can name your file however you want. Make sure that, whichever name you choose, you use the same name in the connection string. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
Thanks John. On 11/28/2011 4:18 PM, John Drescher wrote: You probably have "Hide extensions for known types enabled in windows" When this is enabled windows does not display the extension for known types so that if you have more than 1 file with the same base name they will appear as the same but with a different icon in the explorer view. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
Ok, I switched that and now my original database file has a .db added whereas the one created by my app stays the same. Thanks, Dave On 11/28/2011 4:14 PM, Igor Tandetnik wrote: On 11/28/2011 5:13 PM, Dave wrote: I just looked again and renamed my original database file back to add the .db3 to it and it remains in the same folder as the other file with one exception. The properties for my database shows: type: Data Base File Where the one generated at 0K with the same name is: type: DB3 File Go to Control Panel | Folder Options | View. Uncheck "Hide extensions for known file types" setting, and click OK. Now you can see *real* names of your files. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
On 11/28/2011 5:13 PM, Dave wrote: I just looked again and renamed my original database file back to add the .db3 to it and it remains in the same folder as the other file with one exception. The properties for my database shows: type: Data Base File Where the one generated at 0K with the same name is: type: DB3 File Go to Control Panel | Folder Options | View. Uncheck "Hide extensions for known file types" setting, and click OK. Now you can see *real* names of your files. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
Yes, that is what I am trying to connect to. The problem is that it apparently doesn't connect to it as it cannot see the tables in it. So it creates another database file that has 0K in size. My database file has the correct icon next to it's name with a little key in the pic where the one that is created just has an icon that looks like a sheet of paper. Dave On 11/28/2011 4:09 PM, Igor Tandetnik wrote: On 11/28/2011 5:08 PM, Dave wrote: I just checked and the 0K file that is created is the same name except it has .db3 added to it's name. Why is this suprising? Your connection string requests a file named MyDatabase.db3. Is this not the file you want to connect to? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
On Mon, Nov 28, 2011 at 5:13 PM, Davewrote: > > > On 11/28/2011 3:59 PM, Igor Tandetnik wrote: >> >> On 11/28/2011 4:52 PM, Dave wrote: >>> >>> I am trying to learn VB.Net and SQLite at the same time. I have used VB6 >>> Classic in the past. I have VB Studio 2010 Pro and am just trying to >>> open a small simple database and have made some progress but hit a >>> problem I cannot figure out after plenty of trying. I keep getting the >>> error message: >>> >>> SQLite Error >>> no such table: MyTableName >>> >>> I have the database in the project folder on my Win7 64 Pro system. The >>> app, when run, creates an empty database file of the same name as my >>> database file which is 13KB in size. >> >> What do you mean, of the same name? It's impossible to have two files with >> the exact same name in the same folder. The two names must be different in >> some way. Figure out what this difference is, then it probably will become >> clear why it happens. > > I just looked again and renamed my original database file back to add the > .db3 to it and it remains in the same folder as the other file with one > exception. The properties for my database shows: > type: Data Base File > > Where the one generated at 0K with the same name is: > type: DB3 File > You probably have "Hide extensions for known types enabled in windows" When this is enabled windows does not display the extension for known types so that if you have more than 1 file with the same base name they will appear as the same but with a different icon in the explorer view. John M. Drescher ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
On 11/28/2011 3:59 PM, Igor Tandetnik wrote: On 11/28/2011 4:52 PM, Dave wrote: I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit a problem I cannot figure out after plenty of trying. I keep getting the error message: SQLite Error no such table: MyTableName I have the database in the project folder on my Win7 64 Pro system. The app, when run, creates an empty database file of the same name as my database file which is 13KB in size. What do you mean, of the same name? It's impossible to have two files with the exact same name in the same folder. The two names must be different in some way. Figure out what this difference is, then it probably will become clear why it happens. I just looked again and renamed my original database file back to add the .db3 to it and it remains in the same folder as the other file with one exception. The properties for my database shows: type: Data Base File Where the one generated at 0K with the same name is: type: DB3 File Thanks, Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
On 11/28/2011 5:08 PM, Dave wrote: I just checked and the 0K file that is created is the same name except it has .db3 added to it's name. Why is this suprising? Your connection string requests a file named MyDatabase.db3. Is this not the file you want to connect to? -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
On 11/28/2011 3:59 PM, Igor Tandetnik wrote: On 11/28/2011 4:52 PM, Dave wrote: I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit a problem I cannot figure out after plenty of trying. I keep getting the error message: SQLite Error no such table: MyTableName I have the database in the project folder on my Win7 64 Pro system. The app, when run, creates an empty database file of the same name as my database file which is 13KB in size. What do you mean, of the same name? It's impossible to have two files with the exact same name in the same folder. The two names must be different in some way. Figure out what this difference is, then it probably will become clear why it happens. I just checked and the 0K file that is created is the same name except it has .db3 added to it's name. Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
On 11/28/2011 4:52 PM, Dave wrote: I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit a problem I cannot figure out after plenty of trying. I keep getting the error message: SQLite Error no such table: MyTableName I have the database in the project folder on my Win7 64 Pro system. The app, when run, creates an empty database file of the same name as my database file which is 13KB in size. What do you mean, of the same name? It's impossible to have two files with the exact same name in the same folder. The two names must be different in some way. Figure out what this difference is, then it probably will become clear why it happens. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Newbie question on Data Source
I think this is a bug in SQL Lite I just came across this today and found that there is an update pending that claims to resolve it Not sure if this is the link but it is the site... http://system.data.sqlite.org/index.html/timeline M -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dave Sent: Monday, November 28, 2011 4:53 PM To: General Discussion of SQLite Database Subject: [sqlite] Newbie question on Data Source I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit a problem I cannot figure out after plenty of trying. I keep getting the error message: SQLite Error no such table: MyTableName I have the database in the project folder on my Win7 64 Pro system. The app, when run, creates an empty database file of the same name as my database file which is 13KB in size. My SQLconnect.ConnectionString = "data source =C:\Users\Dave\Documents\Visual Studio 2010\Projects\WindowsApplication5\MyDatabase.db3" Anything to help me get off to a good start will be much appreciated. I am using the latest 1.0.77.0 SQLite dll. Thanks, Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Newbie question on Data Source
I am trying to learn VB.Net and SQLite at the same time. I have used VB6 Classic in the past. I have VB Studio 2010 Pro and am just trying to open a small simple database and have made some progress but hit a problem I cannot figure out after plenty of trying. I keep getting the error message: SQLite Error no such table: MyTableName I have the database in the project folder on my Win7 64 Pro system. The app, when run, creates an empty database file of the same name as my database file which is 13KB in size. My SQLconnect.ConnectionString = "data source =C:\Users\Dave\Documents\Visual Studio 2010\Projects\WindowsApplication5\MyDatabase.db3" Anything to help me get off to a good start will be much appreciated. I am using the latest 1.0.77.0 SQLite dll. Thanks, Dave ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users