Home

Examples

Download

Documentation

Changelog

Guestbook

Contact



Kompex SQLite Wrapper for C++ - Examples


Here you can see some examples.
It shows a part of the functionality of the wrapper and how you can use it.
You can find more examples in the example application (contained in download package).


1. open a database and create a statement instance for sql queries/statements
  1.  
  2.  
  3.  
  4.  


2. create a new table and fill it with data
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  
  12.  
  13.  
  14.  
  15.  
  16.  


3. use some aggregate functions
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  


4. execute and process a sql query
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  


5. execute a simple transaction
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  


6. here you can see the exception handling
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  
  12.  


7. work with a memory database
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  
  12.  
  13.  


8. get some result values via column name (more flexible and a little bit slower than the common way)
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  


9. two possibilities to update data in the database
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  
  12.  
  13.