Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Changing Fields in UFT

HI All

I created a UFT with no object Type. I want to insert muliple rows in tables with one code ,But bydefault fields (Code and Name) are act as Primary Key, so with these fields i am unable to insert data in UFT.

Is There any Idea to change the type of these Fields or any Other Solution.

Thaks In Advance



If your table is NO_OBJECT table when use this method:

- for Code column you can use function what read MAX(Code) and return the value MAX(Code + 1).

- set Name=Code.


Sierdna S.

Note: it may be "00000001", "00000002", "000000AA", "000000AB", "0000AAAZ",...

so you need some function what make convertion...

Public Function getStrNextCode(ByVal sTableName As String) As String
  Dim oRecordset As SAPbobsCOM.Recordset
  oRecordset = SBO_Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)
  Dim sRetValue As Long = -1
  Dim code As String
      oRecordset.DoQuery("SELECT COALESCE(MAX(code), '00000000') AS code FROM " & _
                          sTableName & " WHERE LEN(Code) = 8 ")
      If oRecordset.RecordCount > 0 Then
	  code = oRecordset.Fields.Item(0).Value
	  If code = "" Then code = "0"
	  sRetValue = code
      End If
  Catch ex As Exception
      sRetValue = -1
      oRecordset = Nothing
  End Try
  Return (sRetValue + 1).PadLeft(8, "0")
End Function

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question