8 Replies Latest reply on Oct 4, 2015 1:04 PM by rrrichie

    SQL Can you use it to Insert or Delete a record from a table?

    Tom_Droz

      I have been updating my FM12 solution to take advantage of the popover and slider features in 14.

       

      In that I have come across a few situation where I would like to create a record in a table and set a field

      Example:  Table "Loan" I want to create a record and set the IDField to $ID.

       

      And I want a SQL to delete that same record.  Is this doable?  If so any examples of how to write it?

       

      thank you!

       

      Tom