Hi, I have this business object connected to a sqlite database. On
pressing a button I want to connect to a new user selected database and
replace the contents of the original database with the selected one.
So I create a temporary connection, and temporary business object in
order to get the data set (ds) of the selected database. Then
deleteAll() the records of the original business object and append the
new data set to the original business object. Right now I was expecting
to have a copy of the selected database in my original database but all
I get is an empty table.
Note: the database has only one table (Tarjetas) and both tables, the
original one and the user selected one are equal (except the data). I
use the same business class (TarjetasBizobj) to create both business
objects, bizTjtas and bizCargar, just with a different connection).
Anyone knows what I'm doing wrong?
------------------------- Code
-----------------------------------------------------------
def onCargarArchivo(self, evt):
nombreDB = dabo.ui.getFile('db',
message='Elija una base de datos',
defaultPath='db',
multiple=False)
if nombreDB:
ci = dabo.db.dConnectInfo(DbType='SQLite')
ci.Database = os.path.join('db', nombreDB)
try:
conn = dabo.db.dConnection(ci)
except dException.DBFileDoesNotExistException:
dabo.ui.exclaim(title='Atención',
message=('No me pude conectar con la
base\n'
'No he cargado ningún archivo'))
return
else:
bizCargar = self.Application.biz.TarjetasBizobj(conn)
ds = bizCargar.getDataSet()
bizTjtas = self.Form.getBizobj(dataSource='Tarjetas')
bizTjtas.deleteAll()
bizTjtas.appendDataSet(ds)
self.Form.save(dataSource='Tarjetas')
self.Form.requery(dataSource='Tarjetas')
self.Form.GridTarjetas.refresh()
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
