Please check this SQLite demo I found on the net

@Beja: I downloaded it. It works fine using v2.52. Just unzip the file and open it in the IDE. It is a nice little example of the SQLite usage. Once the main screen opens up, simply enter any user text and a password text in the appropriate boxes to play with and then click 'Add' to add a record to the database table.

Thanks Mahares for the quick response!

Then I think the problem it doesn't work well in 2.71
It couldn't find the layout file although it was there.. also generated endless
directories for it's path. ------ a total mess

Now it is working fine.. I removed spaces from the folder name where I saved it.
It is really cool and a complete sample with all basic record functions, like add, delete, edit...etc. and then it saved new records automatically.

I have been looking for this kind of tutorial example since a long time.