0 Replies Latest reply on Feb 5, 2014 12:41 PM by bkolb

    Exporting found records to MS SQL table

    bkolb

      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?