Adrian, Thanks but that's not the issue here. When a dDataSet is created it takes the data tuple and creates the SQLite table, as you mentioned. However, if the dataset info is modified (via a delete statement in this case), the info does not flow back up to the data tuple.
Larry > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of Adrian Klaver > Sent: Tuesday, August 25, 2009 4:16 PM > To: Dabo Users list > Subject: Re: [dabo-users] Dataset question > > > > ----- [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] > > [excessive quoting removed by server] _______________________________________________ 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/!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAafA2fnYuPUOMNFpIYnBEQcKAAAAQAAAADgWlXnMNZ0mKd5mTbRv8/[email protected]
