Delete after insert?

From: Gentry, Michael \(Contractor\) ("Gentry,)
Date: Tue Dec 14 2004 - 15:33:32 EST

  • Next message: Todd O'Bryan: "Cross-platform SQL scripts"

    Does anyone know of any issues (Cayenne 1.1) with deleting a row
    immediately after inserting it?

    In a nutshell, if I do:

    Insert, sets (relationships only), commit, reset (a method which
    refetches the detail page data), delete (same object just inserted),
    commit, it dies while trying to figure out the update clause on
    something I didn't change.

    However, this sequence seems to work:

    Insert, sets (relationships only), commit, reset, reset (again), delete
    (same object just inserted), commit, it works. It's just slower because
    the reset does a fetch, so it is doubly-fetched.

    Thanks,

    /dev/mrg

    This archive was generated by hypermail 2.0.0 : Tue Dec 14 2004 - 15:33:37 EST