2. ASPRunner.NET General questions
  3. REST Support - Sql View for Update or Insert
This topic is locked

REST Support - Sql View for Update or Insert

 		7/6/2020 9:09:52 PM
ASPRunner.NET General questions
FrankR_ENTA author

Have any of you defined a Sql View for Update or Insert and then invoked that via the API, passing parameters, to successfully update or insert a record?
If you have, can you post your example? It would be a big help. Thank you.
FrankR_ENTA author 7/8/2020

Thanks to great help from Xlinesoft, we have identified the error of my ways <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=91906&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> and, I have Insert and Update examples working now.
Tomorrow, I will write up the basics of two Insert scenarios with SQL Views - the first with embedded SQL and the second with an invocation of a Stored Procedure.