Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I need Update data to in UDF attribute

Status
Not open for further replies.

MAS123456

Programmer
Sep 1, 2009
9
US
Hi,

Please let me know how to update a data in user defined field.

I can Insert the new item to setting the key . below sample code is

retVal = oCIItem.nSetKey("1001-Hon-H252")
If CBool(oCIItem.nSetValue("ItemCode$", "10001-Hon-H252")) Then
retVal = oCIItem.nSetValue("ItemCodeDesc$", "itemNumber34")
retVal = oCIItem.nSetValue("ItemType$", "1")
retVal = oCIItem.nGetValue("ExtendedDescriptionKey$", itemNumber)
retVal = oCIItem.nSetValue("UseInSO$", "Y")
retVal = oCIItem.nSetValue("UseInPO$", "Y")
retVal = oCIItem.nSetValue("UseInAR$", "Y")
retVal = oCIItem.nSetValue("ProductLine$", "C&A")
retVal = oCIItem.nSetValue("UDF_ALIASITEM$", "1")
retVal = oCIItem.nWrite()
End If

I need to add a corresponding item to be update in User defind field(UDf).How to set the key & value.


Thanks,
Vairavan
 
Can I ask why you have created an Alias Item UDf when there is already an Alias Item table?
 
Thnaks for quick replay.

I need to generate UPC number for corresponding alias item. So I planned to create a UDF/UDT field and Update it. If U have any alternate solution to Update UPC Number for corresponding alias item.

Vairavan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top