If you like to use SQLite and SQLitening but need help with SQL statements this is a place where you will find all kinds of examples:
http://sqlite.awardspace.us/syntax/sqliteindex.htm (http://sqlite.awardspace.us/syntax/sqliteindex.htm)
Rolf,
I have begun a new Sqllitening project. I am using the original AdBook as a template. This project will eventuall have a dozen tablets and each table will have 20 to 40 columns.
I have been able to get the database structure designed and the createdb routine seems to be creating the Database correctly. Using your SQLMAN program I am able to view the database structure and all seems correct.
My problem is that when i try to run the program, and error message repport that the table does exists. But I can clearly see it when the database in loaded by SQLMAN.
Would you have the time and be agreeable to take a quick look at the program? Maybe you can see an obvious mistake that I can not see. If so, I can attach it here. I will work with it a bit more this evening but I have been chasing my tail all day with out much success.
Yes, Marty, I will look at it.
Rolf,
Here's the project I am having problems with.
The project will create a SQLite3 database and you can add records, but I am doing something wrong in the browse routine and am not able to move up or down through the records with out getting an SQLite error.
I have placed MsgBox at various points to show what is happening. I just can't see how to fix it.
When you start the program click the "Start-DB" to initialize and open the database. If you can show me what I am doing wrong I would be most pleased. Thank you.
I noticed Dr. Marcus Welbee in your Doctors table. Reminded me of Robert Young in "Marcus Welby, M.D".
Looooooooooong, long time ago!
Quote from: Rolf Brandt on December 09, 2009, 10:40:16 AM
I noticed Dr. Marcus Welbee in your Doctors table. Reminded me of Robert Young in "Marcus Welby, M.D".
Looooooooooong, long time ago!
Did you notice the pun... Mak Us Wel
I didn't catch that one...
Rolf,
Thanks for your willingness to look at my code to see if you could find my error. Good News. I found the problem. It was staring me in the face for several days. I looked right at it and could not find it. Once I did see it, it was so obvious.
You need look no more for that problem. Thanks again for your help.
Marty,
Don't keep us is suspense...what did you find???
Gary