BuddyPress.org

I haven’t time to dig through answers for your questions, but if you’ve updated or replaced a record, you can get the ID immediately afterwards via $wpdb->insert_id.