Open a database.
return_bool = dbopen(db_str, user_str, password_str)
return_bool - True if successful, else false
db_str - Name of the database, as known to the ODBC manager
user_str - Name of database account (may be optional)
password_str - Password for database account (may be optional)
True if successful.
Open a database connection. NLP++ currently allows only one database to be open at a time.
@CODE
dbopen("test","root","mypassword");
dballocstmt();
dbexecstmt("SELECT * FROM table;");
dbbindcol(1,"varchar",50,&G("employee name"),&G("result1"));
while (dbfetch())
{
"output.txt" << "employee name: ";
if (G("result1"))
"output.txt" << G("employee name") << "\n";
else
"output.txt" << "NULL" << "\n";
}
dbfreestmt();
dbclose();
@@CODE