This entry already exists-error

209 Views

hai experts,

I have designed one form and bound to table of "Document Type"

I can add records.

But some times it shows errors as follows:

Exclusive code already exists , '16' [Message 173-13]

This entry already exists in the following tables (ODBC -2035) [Message 131-183]

I get Docentry field value to add new record as

Dim recordst As SAPbobsCOM.Recordset

recordset = ocompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

qry = "SELECT T0.[DocEntry] FROM [dbo].[@TI_ddd] T0"

recordset.DoQuery(qry)

Dim sno As Integer

If recordset.RecordCount = 0 Then

sno = 1

Else

recordset.MoveLast()

sno = CInt(recordset.Fields.Item("DocEntry").Value) + 1

End If

Any help is appreciated.

Thanks & Regards,

Parvatha Solai.N