Has anyone successfully used execute statement with sql server database?
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?
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.