in reply to Re^2: SQLite: INSERT into a unique column and retrieve rowid
in thread SQLite: INSERT into a unique column and retrieve rowid

I don't understand your comment about the state hash. I copied this subroutine into my actual program, which calls insert_unique() repeatedly for six different tables, and it worked correctly.
  • Comment on Re^3: SQLite: INSERT into a unique column and retrieve rowid

Replies are listed 'Best First'.
Re^4: SQLite: INSERT into a unique column and retrieve rowid
by hippo (Archbishop) on May 05, 2024 at 10:55 UTC

    You are quite right. I had somehow missed that you were keying the hash on the table and testing for this one level down. Mea culpa.

    🦛

[reply]

In Section Seekers of Perl Wisdom