Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tMysqlLastInsertId returns the FIRST inserted ID???

Hello,
I can anyone tell me what happens here? I have to insert some rows in a MySQL table, then to retrieve the last inserted ID. The insertion is correctly executed, but tMysqlLastInsertId returns not the LAST, but the FIRST inserted ID !! I can't believe it! This happens either if I commit the insertion or without committing them, please advise!

Thank you.

PS
Working on TOS Version: 3.1.3/ Build id: r26090-20090629-1316t
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hello
Change a little in your job:
...
|
onsubjobok
|
tMysqlLastInsertID---tLogRow---tMysqlCommit.

Best regards

shong