[mdb-dev] Question concerning the use of MdbSQL

[Horst K. <md...@kn...>]

In your examples you use 

MdbSQL* sql=mdb_sql_init();

According to the documentation of mdb_init()  it should be called only once in 
an application.   mdb_sql_init() calls mdb_init() so  I presume it should 
also be called only once from an application.

If I need to open 2 or more Access databases at the same time, I will need 
more than one handle (is this really correct?). 

Is creating a second handle with the following code safe?

MdbSQL *sql= (MdbSQL *) g_malloc0(sizeof(MdbSQL));
 sql->columns = g_ptr_array_new();
 sql->tables = g_ptr_array_new();
 sql->sarg_tree = NULL;
 sql->sarg_stack = NULL;
 sql->max_rows = -1;
    
and then using it with 
mdb_sql_open(sql,"mydatabase.mdb");


Regards

Horst