can you help me to solve this problem:
insert into testhristo (
firstName,
surName,
federateState,
email
) values (?,?,?,?)
insert into kunde (
testPersonID, statusOfHearing
) values (last_insert_id(), ?)
Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into kunde (
testPersonID, statusOfHearing
) values (last_insert_id(),' at line 8
Views
Replies
Total Likes
You can only specify an insert statement at one time.
Views
Replies
Total Likes
Thank you for help :-)
Views
Replies
Total Likes
You can use Execute Sql Statment operation to run multiple SQL commands at a time.
Provided that you must separate each statement with a semi-colon.
I've tried this with Sql Server 2008. Are you using a different database?
Nith
Views
Replies
Total Likes