Example

mlt edited this page Mar 10, 2013 · 2 revisions
Clone this wiki locally

Simple example demonstrates how to

  • establish DSN-less connection
  • prepare a statement
  • bind columns
    • including overloaded binding function

For my sample DB it produces the following output

mlt@nb:~/workspace/odbc/build(master)$ ./example/sqlite_test 
 SQLiteTest constructor has been called
 Running
 We got       3  columns
   speed_max   start                                               track
           7   2012      7     22     15     33      0           0 0722101
           4   2012      7     22     16     40      0           0 0722102
          39   2012      7     22     19     21      0           0 0722103
          38   2012      7     23     19     45      0           0 0723101
          43   2012      7     23     20     53      0           0 0723102
           0   2012      7     24     20     42      0           0 0724102
          34   2012      7     25     17     57      0           0 0725101
          46   2012      7     28     18     26      0           0 0728101
          42   2012      7     28     18     52      0           0 0728102
 SQLiteTest destructor has been called

You may want to

sudo apt-get install libsqliteodbc gfortran cmake