Results from ExecuteImmediate w/ SQLDMOExec_ParesOnly option?

• Matt Gauch

  SSC Enthusiast

  Points: 194

  More actions

  June 24, 2004 at 11:44 am

  #87710

  How do you get results back from the ExecuteImmediate method with the SQLDMOExec_ParseOnly option?  How do I know if my query parsed successfully or not?

  TIA,

  Matt

  Kindest Regards,

  Matt Gauch

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 24, 2004 at 12:57 pm

  #511854

  If it doesn't parse successfully it will throw an error. However keep in mind it is Parse Only you are using.

  So say I have a database object name dmoDB and I do the following.

  dmoDB.ExecuteImmediate "SELECT * FROM X", SQLDMOExec_ParseOnly

  Even thou I don't have a table name "X" it will parse successfully as there is nothing wrong with the syntax.

  However if I do.

  dmoDB.ExecuteImmediate "SELEC * FROM X", SQLDMOExec_ParseOnly

  I get an error because SELECT is missing the T.