Wenton Thomas wrote:
> Now in my system I used sqlite to manage 2 database file A.db and
> B.db, and each has a connection handle cA, cB. My operation perform
> like this:
>
>
> sqlite3_exec( select records from cA)
> sqlite3_exec("begin transaction");
> insert all records into cB;
> sqlite3_exec("commit transaction");
>
> All return value is normal.,but when I execute
> rc = sqlite3_close(),
> return value rc always be SQLITE_BUSY.
How precisely do you implement "insert all records" part? Do you use
prepared statements, by any chance? If so, you need to finalize all such
statements before you can close the connection.
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
