Forum Discussion

Scripter's avatar
Scripter
Occasional Contributor
9 years ago

Groovy script for database manipulation using project property

I want to execute simple delete query with the schema name taken from project properties, but I am not sure how to pass the value to it, current way doesn't work for me.   import groovy.sql.Sql imp...
  • rupert_anderson's avatar
    rupert_anderson
    9 years ago

    Hmm.. ok, maybe its a clash of placeholder syntax, what if we try an java style way of adding the schema string e.g.

    "DELETE FROM ["+dbschema1+"].[dbo].[JOB] WHERE EMPNAME = 'NAME1'"
    

    ?