On Aug 25, 2009, at 12:06 PM, <[email protected]>
<[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
>
> myds
>
> How do I re-synch?
You cannot execute an SQL delete statement against a dataset and have
it propagate back to the database. If you want to just get the
resulting dataset, you can run:
newds = myds.execute(...)
... and newds will contain the result.
Maybe if you explain a bit more about what you're trying to
accomplish, I might be able to suggest a better solution.
-- Ed Leafe
_______________________________________________
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]
