5 Replies Latest reply: May 5, 2014 1:39 PM by Sam David RSS

    Problem executing multiple SQL statements

      Team,

       

      I successfully established ODBC connection.

       

      Now when I write multiple SQL Statements, one after another, only the 1st one executes successfully whereas the subsequent one fails/doesn't do anything.

       

      I wan to understand the following:

       

      1. Why only  the first one executes? How can I make 2nd SQL satement work? When it didn't work in the same tab I created another tab and put it there and reloaded script still it executed first one but the second one remained untouched. DO I need ODBC connection string in each tab? Do I need Load statement for each SQL, if YES, why the 1st one executed without Load statement?

      2. Is there a way I can go to Edit Script --> Data Tab --> Select --> Create Select Statement window --> Script and write my SQL there so that it executes against my Database that I am connected to and get my desired results?

       

      Thanks.

      Samuel