[odb-users] executing native sql queries

[Lidia Kalinovsky]

Hello

I need to migrate old database to the new one that I've created and use
through odb.
Database is sqlite.

Table and columns names are different in these 2 databases.
So, I thought to run native sql query to do it, something like :

db = create_db(<new_db>);
db->execute("insert into Activity (wrntyID) Select zwrntyID from " + <old
db> + ".dbo.ZActivity");

Clear it does not work as I don't know how to relate to old db ( by path
??? ).
I don't want to create odb objects for old database.
Is there some way to get result of execute ( not only number of rows
affected ) ?

Could somebody advice please ? May be some another approach ?

Thanks.
Lidia.

-- 
Software integration and outsourcing services,
Lemur-Soft, Giv'at Nili
Israel, 37825
Phone : (+972) 545748325
Fax : (+972) 775345383
Email : lidia at lemur-soft.com
Web: www.lemur-soft.com