Execute sql script in a form script

Legacy Contributor

 I know how to execute a stored procedure on a form script using the IdoName of "SP!", but can anyone tell me how, if possible, to directly execute SQL without the need for a stored proc? 

Thanks,

Matt

Legacy Contributor

You can run SQL statements in FormScript by approaching it as if you were writing your own VB.Net application outside of Mongoose. You would need to define, open, and close the SQL connection strings and SQL user credentials within the form. So, it is possible, however, not recommended as it circumvents the IDO layer and the security it provides.