can you help me to solve this problem:
insert into testhristo (
) values (?,?,?,?)
insert into kunde (
) 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 (
) values (last_insert_id(),' at line 8
You can only specify an insert statement at one time.
Thank you for help :-)
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?