Working with SQLite Databases

[Rolf Brandt]

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

[Martin Francom]

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.
 

[Rolf Brandt]

Yes, Marty, I will look at it.

[Martin Francom]

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.
 

[Rolf Brandt]

I noticed Dr. Marcus Welbee in your Doctors table. Reminded me of Robert Young in "Marcus Welby, M.D".
Looooooooooong, long time ago!

[Martin Francom]

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

[Rolf Brandt]

I didn't catch that one...

[Martin Francom]

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.

[Gary Stout]

Marty,

Don't keep us is suspense...what did you find???

Gary