Skip to Content
0
Former Member
Aug 12, 2005 at 11:54 AM

Deleting a record form UserTable

35 Views

Hello,

I need to delete a record form my usertable called @TMPS

to add a record I use:

        Dim oUsrTbl As SAPbobsCOM.UserTable

        oUsrTbl = oCompany.UserTables.Item("MTPS")

        oUsrTbl.Code = CInt(sProduct)
        oUsrTbl.Name = CChar(sProduct)
        oUsrTbl.UserFields.Fields.Item("U_Depot").Value = "depot"
        oUsrTbl.UserFields.Fields.Item("U_Date").Value = CDate(dDate)
        oUsrTbl.Add()

oUserTbl.Remove exsists and I want to use it..but how.

Is there a way to select one record and then do

oUserTbl.Remove() ?

Thank you,

Michiel Kramer