https://www.proggen.org/ 2026-04-12T16:50:54+0200 https://www.proggen.org/ https://www.proggen.org/lib/tpl/proggenX/images/favicon.ico text/html 2022-09-22T19:58:57+0200 Anonymous (anonymous@undisclosed.example.com) https://www.proggen.org/doku.php?id=dbs:sqlite:libsqlite3:communicate:sidebar&rev=1663869537 Community * Forum * Links * FAQs * Autorenportal * User-Websites Datenbanken * Startseite * MySQL * SQLite Startseite * libsqlite3 Startseite SQL-Kommandos ausführen * sqlite3_exec * sqlite3_get_table * Prepared Statements text/html 2022-09-22T19:58:57+0200 Anonymous (anonymous@undisclosed.example.com) https://www.proggen.org/doku.php?id=dbs:sqlite:libsqlite3:communicate:sqlite3_exec&rev=1663869537 sqlite3_exec C-Code Codeschnipsel für C sqlite3* dbs; char command[300]; char *ptr_command = command; char *error_exec=NULL; printf("SQL Kommando eingeben:"); fgets(ptr_command,300,stdin); if (sqlite3_exec(dbs,ptr_command,callback,NULL,&error_exec) != SQLITE_OK) printf("SQLite Fehler: %s\n",error_exec); { sqlite3_free(error_exec); error_exec=NULL; } text/html 2022-09-22T19:58:57+0200 Anonymous (anonymous@undisclosed.example.com) https://www.proggen.org/doku.php?id=dbs:sqlite:libsqlite3:communicate:sqlite3_get_table&rev=1663869537 sqlite3_get_table C-Code Codeschnipsel für C sqlite3* dbs; char command[300]; char* ptr_command = command; char* error_get_table=NULL; char** result=NULL; int column=0; int row=0; printf("SQL Kommando eingeben"); fgets(ptr_command,300,stdin); if (sqlite3_get_table(dbs,ptr_command,&result,&row,&column,&error_get_table)) { printf("SQLite Fehler: %s",error_get_table); sqlite3_free(error_get_table); error_get_table=NULL; } print_result(result,row,column); sqlite3_free_table(result); re… text/html 2022-09-22T19:58:57+0200 Anonymous (anonymous@undisclosed.example.com) https://www.proggen.org/doku.php?id=dbs:sqlite:libsqlite3:communicate:sqlite3_prepared&rev=1663869537 Der Weg über sqlite3_prepare und sqlite3_step C-Code sqlite3* dbs; sqlite3_stmt *stmt; char command[300]; char* ptr_command = command; int cols; int i; char* col_name; char* col_value; printf("SQL Kommando eingeben:\n"); fgets(ptr_command,300,stdin); if (sqlite3_prepare_v2(dbs,ptr_command,strlen(command),&stmt,0)!=SQLITE_OK) { printf("SQL-Fehler: %s\n",sqlite3_errmsg(dbs)); } cols = sqlite3_column_count(stmt); while (sqlite3_step(stmt) == SQLITE_ROW) { for (i=0;i<cols;i++) { …