Has anyone successfully used execute statement with sql server database?

0
I’m trying a simple test to see how this works.  I’m trying to get this syntax right.  Does anyone know? 'INSERT INTO Instrument (TAG_NO, Description, AuditResult) VALUES ( "' + $Instrument/TAG_NO + '" , "' + $Instrument/Description + '"  , "' + $Instrument/AuditResult + '" )' I’m getting a syntax error in mendix almost like it’s not reading the column names after instrument.  Can someone post a picture or text showing a sql statement that works with this execute statement?  
asked
1 answers
0

If anyone tries this in the future.  Have a look.  This worked good for me.  Here’s the structure of the query to pass in a variable into the sql query.

 

answered