Michael Lackhoff wrote:
I know my question is not strictly about DBD::SQLite but hopefully close
enough.

That question is off-topic for this list, even if the module in question only works over SQLite. It might be on topic if it were exposing a bug in or a feature request for DBD::SQLite itself, but yours isn't.

You should ask instead to a forum specific to ORLite, or ask its author directly, or failing that, ask in the dbi-users forum instead.

-- Darren Duncan

ORLite seems like a good way to do the processing at hand and everything
went very well as long as I was inserting but I felt very stupid when I
couldn't find a method to update/save a row/record.

ORLite even has an iterator so I used it to select the records I have to
update, then within the sub:
$_->somefield('a new value');
but then none of these worked:
$_->update; # no such method
$_->save; # no such method
$_->base->do('update mytable ...'); # database locked

Is there really no way to update a record? Even a grep for 'update' in
the source doesn't return any result. On the other hand I cannot believe
that such a well thought out module doesn't have a way to update. I
guess I could get away with the last variant (do) if I also do not use
the iterator but since I have really a lot of records I would like to
use the iterator.

Any ideas?


_______________________________________________
DBD-SQLite mailing list
DBD-SQLite@lists.scsys.co.uk
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbd-sqlite

Reply via email to