inserting new objects using transaction update

Using transaction mode

note that all the standard columns commented out is optional in the insert statement or is not required when inserting a new record

--SET TABLE FOR TRANSACTION MODE IN MFCLASS TABLE

select * from MFClass
Update MFClass
set IncludeInApp = 2
where MFID = 78

-- INSERT NEW RECORD

INSERT INTO dbo.MFCustomer
        (
        -- GUID ,
        -- MX_User_ID ,
          Address_Line_1 ,
          Address_Line_2 ,
          City ,
          -- Class ,
          -- Class_ID ,
          -- Country ,
          Country_ID ,
          -- Created ,
          -- Created_by ,
          -- Created_by_ID ,
          Customer_Name ,
          -- MF_Last_Modified ,
          -- MF_Last_Modified_By ,
          -- MF_Last_Modified_By_ID ,
       -- Name_Or_Title ,
          -- Single_File ,
          -- State ,
          -- State_ID ,
          Stateprovince ,
          Telephone_Number ,
          Web_Site ,
          -- Workflow ,
          -- Workflow_ID ,
          Zippostal_Code ,
          -- LastModified ,
          Process_ID
          -- ObjID ,
          -- ExternalID ,
          -- MFVersion ,
          -- Deleted ,
          -- Update_ID
          ,MFSQL_Message

        )
        values
        ('Building'
        ,'Street Name'
        ,'London'
        ,(select MFID_ValuelistItems from MFvwCountry where name_ValueListItems = 'United Kingdom')
        ,'ABC Customer'
    -- ,'ABC Customer'
        ,'Hampshire'
        ,'090987098'
        ,'www.abccompany.com'
        ,'PO6 1HT'
        ,1
        ,'Transaction Update'

        )

-- UPDATE INSERTED RECORDS FROM SQL INTO M-FILES

-- note that M-Files will automatically be updated

-- CHECK TABLE

select * from mfcustomer WHERE Customer_Name LIKE '%abc%'

-- RESET THE CLASS TABLE AFTER EXPLORING THIS EXAMPLE

Update MFClass
set IncludeInApp = 1
where MFID = 78

-- DELETE THE TEST RECORD

update MFCustomer
set Process_ID = 10
 where Customer_Name = 'ABC Customer'

 exec spMFDeleteObjectList @TableName = 'MFCustomer',@Process_ID = 10 , @DeleteWithDestroy = 0