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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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