|
My biggest problem with SQL is how does it set up the SQL database on the 'users' computer. Do they have to manually set up the ODBC settings? I guess I could create a small sample program and deploy it on one of my other computers.
I tried writing one today. I can easily create the SQL database, but I had to manually create the tables. I am looking for an easy way to just import all of the CSV files into a SQL database. I guess I do not need all of them. Once I get them into a SQL database, manipulating the data will not be too hard for me. I have read quite a bit on writing SQL code.
I did have one event that made me throw my hands up in the air and hit that X in the corner. I created a sample database, and everything worked good. (I have SQL 2008 on here), but when I manually entered some data, then closed the program, then reopened it, the data was not there. It dawned on me later that there was a setting that had to do something with copying the database to the work folder or something. I remember having this problem a couple of years ago when I started to tackle the problem.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it!  New show every Monday!! New Blues HOF![/COLOR][/FONT]
|