Datenbank ODBC Rückgabewert

int OpenDB(void)

{

//...

  MYSQL *err;

  mysql = mysql_init(NULL);

  // mit Datenbank verbinden

  err = mysql_real_connect(mysql, dbname, NULL, NULL, NULL, MYSQL_PORT, NULL, 0);

  if (err==NULL)

  {

    OutputDebugString(mysql_error(mysql));

    OutputDebugString("\n");

    return 0;

  }

  mysql_select_db(mysql, "Name_der_Datenbank");

  OutputDebugString("OpenDB ok\n");

  return 1;

}

int InitDB(void)

{

  MYSQL_RES * res;

  int status;

  if (!OpenDB()) return 0;

  res = mysql_list_dbs(mysql, "Name_der_Datenbank");

  if (mysql_fetch_row(res)==NULL)

  {

    mysql_free_result(res);

    mysql_query(mysql, "CREATE DATABASE Name_der_Datenbank");

  } else mysql_free_result(res);

  status = mysql_select_db(mysql, "Name_der_Datenbenk");

  if (status) 

  {

    OutputDebugString("SELECT DB: ");

    OutputDebugString(mysql_error(mysql));

    OutputDebugString("\n");

    mysql_close(mysql);

    return 0;

  }

  // Tabellen anlegen, falls nicht schon vorhanden

  status = mysql_query(mysql, 

    "CREATE TABLE IF NOT EXISTS Projekte ("\

    "ID INT UNSIGNED NOT NULL AUTO_INCREMENT,"\

    "NAME TEXT,"\

    "BEMERKUNG TEXT,"\

    "PRIMARY KEY(ID))");

  if (status) 

  {

    OutputDebugString("CREATE PROJEKTE: ");

    OutputDebugString(mysql_error(mysql));

    OutputDebugString("\n");

    mysql_close(mysql);

    return 0;

  }

//...

}

....

  sprintf(qs, "SELECT FELD1 /* ... */ FROM /*...*/ "\

    "LEFT JOIN FELD2 ON /*...*/ "\

    "WHERE /*...*/=%d", akt);

  mysql_query(mysql, qs);

  res = mysql_store_result(mysql);

  for (;;)

  {

    row = mysql_fetch_row(res);

    if (row==NULL) break;

    if (atoi(row[0]) != xxx)

    {

                        /*...*/

      it.pszText = row[0];

    }

    OemToChar(row[1], qs);

    it.pszText = qs;

  }

  mysql_free_result(res);