MULIPLE INSERTS ExecuteRemoteQuery

mariolu

Member
Licensed User
Longtime User
PLEASE HELP WITH MULTIPLE INSERTS FOR ExecuteRemoteQuery COMMAND.

I WANT TO INSERT MULTIPLE RECORDS IN SINGLE COMMAND!!

I HAVE TRIED THE FOLLOWING WITH

IT ONLY WORKS WITH ONE INSERT COMMAND.

IS MY SYNTAX NOT CORRECT IN ANY ONE OF THESE COMMANDS

OPTION 1
"ExecuteRemoteQuery(INSERT INTO...VALUES(...);INSERT INTO...VALUES(...)


OPTION 2
"ExecuteRemoteQuery(INSERT INTO...VALUES(...), VALUES(...)

OPTION 3
"ExecuteRemoteQuery(START TRANSACTION; INSERT INTO...VALUES(...);INSERT INTO...VALUES(...);COMMIT;_

PLEASE ADVISE!!!
 

mariolu

Member
Licensed User
Longtime User
follow up

sorry for the upper case, not screaming at all
i am not to familiar with php!!

i have tried sending series of single command inserts with a loop, when i sending them in debug mode, they insert with no issues , as i am stepping through each line, (i guess because there is a delay between each command)

when i send them by running in real time, only the first inserts gets executed, do i need a additional command, or do i need a pause, please advise!!!

thanks
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…