On Tuesday 25 August 2009 01:16:15 pm Adrian Klaver wrote: > ----- [email protected] wrote: > > I have a dataset that i want to remove records from. > > I issued... > > > > myds.execute('delete from dataset where id=whatever") > > > > I then ran > > > > myds.execute('select * from dataset") > > > > and the values were gone, however the values still show up when I > > issue > > > > mydsd > > Not sure what you are doing above? > > > How do I re-synch? > > A dataset is just an in memory SQLite db. Sounds like there is a COMMIT > missing in the sequence and when you revisit the db it has rolled back the > DELETE. > > > Thanks, > > Larry > > Adrian Klaver > [email protected]
Ok - but how can Larry execute the 'commit' on the dataset. What I think is happening is just what he said. The dataset is no longer in sync with the tuple(dict) that the dataset is associated with. The data that was retrieved (in this case mydsd) is the result of a select statement. That becomes the dataset (SQLite). If you delete a record from the dataset it appears the records in the dataset no longer match the tuple associated with the dataset. I believe that can be seen in dDataSet.py-> _populate() Johnf _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
