AnsweredAssumed Answered

Exporting found records to MS SQL table

Question asked by bkolb on Feb 5, 2014

Title

Exporting found records to MS SQL table

Post

     My script finds specific records and then uses an ExecuteSQL command to insert them into a SQL table.  Unfortunately, I seem to only be able to insert them one record at a time, so 6000+ found records can take a few minutes and the user is forced to watch the list of found records scroll up as they are written to SQL.   

     In other words,  once I've found the records I want, I then do the following:

 Go to Record/Request/Page[First]

 Loop

    Set Variable[$sqlIO; Value:"INSERT INTO......."]

    Execute SQL[No Dialog;DSN; ........]

    Go to Record/Request/Page [Next;Exit after last]

End Loop

     Is there a way to write these found records all in one step instead of having to loop through each record to write it to my MS SQL table?

Outcomes