Can someone please help. I have never worked with databases and began a project to learn. The more I read the more I become confused with SQL, SQLite and DBUtils. Each seem to be the best choice and the tutorials seem to jump from 0 to 100. I was a VB user and over the last year I believe my B4A knowledge has become fairly descent but trying to create a database has beaten me.
I chose my project because I thought it was simple while covering the basics yet broad enough that would allow me to expand future projects.
My project adds 1 record at a time to the database. Add a value included in the records into a sum if the value exists and turns the value to zero once read. Add the date the record was added to the database then delete records if the added date surpasses 90 or so days past todays date.
While examples probably have all of the answers but can not seem the answers with all of the extras. Delete the tables then create tables and fields by loading maps. When I remove the maps and retreat to the basics, or what I understand per the manuals are the basic commands the examples quit working.
I am stuck and asking if someone would please provide a simplified example or provide a direction that I should study.
I chose my project because I thought it was simple while covering the basics yet broad enough that would allow me to expand future projects.
My project adds 1 record at a time to the database. Add a value included in the records into a sum if the value exists and turns the value to zero once read. Add the date the record was added to the database then delete records if the added date surpasses 90 or so days past todays date.
While examples probably have all of the answers but can not seem the answers with all of the extras. Delete the tables then create tables and fields by loading maps. When I remove the maps and retreat to the basics, or what I understand per the manuals are the basic commands the examples quit working.
I am stuck and asking if someone would please provide a simplified example or provide a direction that I should study.
