/**********************************************************************
 kz_odbc.h  ODBC API̊ȈՃbp[NX
 Authors	Katsuhisa Ohfuji
 Version	0.1a(JŁj2008/03/11
 Version	0.2a(JŁj2008/04/14 NULLl̎擾G[̏C
									iNULLl󕶎ƂĎ擾j
 Version	0.3a(JŁj2008/05/16 J^O֐(tables,columns)̒ǉ
 Version	0.4a(JŁj2009/01/06 LinuxΉi{ꕔ֐̒ǉj
 Version	0.5a(JŁj2009/02/12 colinfo̓Y
 Version	0.6a(JŁj2009/02/27 gUNVΉ
									Fetch֐inextj̒ǉ
 Version	0.7a(JŁj2009/04/10 f[^擾̃oOC
 Version	0.7b(JŁj2009/05/07 ̃f[^^̒
 
 giVer0.6gς܂j
    1.kz_odbcIuWFNg쐬iRXgN^ODBCڑwj

     kz_odbc db("DSN=myaccess", false);
   
     DSNŃf[^[\[X̎ŵقADriverł̎w
     RXgN^2ڂ̈̓R~bg[hw肷
	   trueŎ蓮R~bg[hAfalseŎR~bg[h
	   蓮R~bg[hɂꍇAŌCommit()ĂяoKvB
	   
    2.SQL̔s
	 stmtIuWFNg쐬ASQL𔭍sB
	 
     kz_stmt stmt(&db);

     stmt, "INSERT INTO TEST(col1, col2) VALUE(?, ?)", "val1", 10, endsql;

     evfJ}(,)ŋ؂
     ŏkz_odbcIuWFNgw肵ASQL𕶎Ŏw肷B
     p[^[iHɑ΂lj𑱂Ďw
     p[^[Ŏwł^́A(eint)Aichar*)A
       _idouble,floatjAԁistruct tm)
       ȊǑ^w肷SQLsȂiŜjB
     0p[^Ɏw肷鎞͈xϐɓĂw肷B
     @iC++RpCł́A0́ANULL|C^Ɖ߂̂Łj
     ŌendsqlƋLqiLqȂSQLsȂjB
     
    3.lԂSQL̔s
    
     kz_resultset_array result = (stmt, "SELECT * FROM TEST", endsqlrs);
    
      ʃZbǵAkz_resultset_arrayiqjŕԂ
      SQLs̃J}̑Ŝ()ŊB
        Zq̗D揇ʂ̊֌WőŜȂƒlԂȂB
      ṒAendsqlrsƋLqiendsqlł͒lԂȂjB
    
    4.ʃZbg̎Qƕ@
     ʃZbgikz_resultset_arrayj́AȉtypdefɂȂĂB
     	std::vector< std::map< std::string, std::string> >
     SELECŤʂSĎ󂯎
     svectorɗmapi񖼂ƒlmap)ɂȂĂB
     @@cout << result[1]["ID"]
     @̂悤ɃANZXłB
     ʃZbǵAɕϊĕԂ
    5.G[̊mF
	 iserro֐ŃG[̗L
	 errorso֐ŃG[񂪎擾ł
	 @ʂ́Akz_string_array( std::vector< std::string > )ŕԂB
 Tv
@kz_odbc_sample.cppQƉB
 
  1.Windows
   VC++ .NET 2003 / WINDOWS XP Pro 64i32rbgRpCj
   Access 2000 / SQL Server 2005iDeveloper Edition)
  2.Linux
   GCC 3.3.6 / unixODBC 2.2.11 / Vine Linux 4.2
   MySQL 5.0.27 / SQLite3
   ODBChCóAVine Linuxɂ͂ȂAʓrCXg[B
   MySQL-Connector/ODBĆAMySQL̃TCg_E[hiRPMA3.51j
     http://dev.mysql.com/downloads/connector/odbc/3.51.html
     RPM̃CXg[ɃG[oPSELECT͂ł
   SQLite3ODBChCóAȉ̃TCg_E[hi0.79j
     http://www.ch-werner.de/sqliteodbc/
     \[XRPM_E[hARpCACXg[
 ̑
 @LӂĂ̂݁ARɂgpB
 @@E쌠͕܂B
 @@ẼvOgĐ@Ȃ鑹Q͐ӔC𕉂
 @@@B 
 @@EJłł̂ŁA{ԊŎgpꍇAgp҂̐ӔC
 @@@eXgACsĉBVer0.6ȉɂ́Aobt@𒴂
 @@@f[^擾ɃoO܂B
 @@E͈؂̃T|[gs܂B
 @@ET|[g͂܂񂪁AmF̕񍐁AoO|[gAӌ
 @@@܂AuÕRgɂ肢v܂B
 @@ER[ḧꕔ̗p\܂񂪁AɎgpꍇ́Ao
 @@@܂Rg΂ꂵ肵܂B
**********************************************************************/
