database problem

[Rondo23]

Hi,

I have a problem concerning access a database from another application on my device.
i have created an application which used "QSQLITE" and i have created "person" table.
Now, i want to access this table ("person" table) from another application.
Is that possible? and if yes, how can i do in order to access this table ???

i have searched the wiki and i didn't found any useful solution.

Regards

[symbianyucca]

Basically with symbian, then you should save tyhe database file in a folder that can be accessed through multiple processes (i.e. not in your own private folder), and then depending on API, you might need to close the database after each usage (since some APIs do not allow using database same time by multiple applications).

[Rondo23]

Basically with symbian, then you should save tyhe database file in a folder that can be accessed through multiple processes (i.e. not in your own private folder), and then depending on API, you might need to close the database after each usage (since some APIs do not allow using database same time by multiple applications).

yes, i realized that my database is saved in the application private folder.
but how can i save it in a specific path ???
i have open it like the following :

{
db = QSqlDatabase::addDatabase("QSQLITE");

QString privatePathQt(QApplication::applicationDirPath());
QMessageBox::information(this,"path of the database",privatePathQt);

db.setDatabaseName("my.db.sqlite");

return db.open();
}

[Rondo23]

Basically with symbian, then you should save tyhe database file in a folder that can be accessed through multiple processes (i.e. not in your own private folder), and then depending on API, you might need to close the database after each usage (since some APIs do not allow using database same time by multiple applications).

ahhhh, i think that the save method is provided by the "db.setDatabaseName()"
right ????

[symbianyucca]

you could try always defining the full path with the setDatabaseName.

ok, was distracted, thus did not notice your anwer in the middle. Yep just try it and see what happens. Also do remember specify the drive

[danhicksbyron]

Yes, you need to use the full path for setDatabaseName. Further, the path must be in Symbian/Windows forn (with backslashes) rather than Qt form. So you might code "C:\\somedir\\anotherdir\\myDb.db". Note that you need to double-up your backslashes.

I prefer to find the file with QFileInfo (and verify its existence), extract the full path from that object, and then replace the slashes using QDir::toNativeSeparators.

[Rondo23]

thank you all.
it works well