I have created a user table as,
CREATE TABLE [dbo].[@U_TCHN] (
[Code] [nvarchar] (8) COLLATE SQL_Latin1_General_CP850_CI_AS NOT NULL ,
[Name] [nvarchar] (30) COLLATE SQL_Latin1_General_CP850_CI_AS NOT NULL ,
[U_PODocNum] [int] NULL ,
[U_ChangeDate] [datetime] NULL ,
[U_ProductCode] [nvarchar] (20) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
[U_ChangeType] [smallint] NULL ,
[U_ItemCode] [nvarchar] (20) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
[U_OldItemCode] [nvarchar] (20) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
[U_Quantity] [nvarchar] (10) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
[U_ChangedBy] [nvarchar] (20) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
[U_Remark] [nvarchar] (254) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
[U_Machine_Name] [nvarchar] (20) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
[U_Machine_IP] [nvarchar] (20) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ,
[U_OldQuantity] [nvarchar] (10) COLLATE SQL_Latin1_General_CP850_CI_AS NULL
)
In this table , I am savinf the details of updated production orders.I want CFL for U_PODocNum.
What is the objecttype in ChooseFromListCreationParams for this table ?
Dim objPara As SAPbouiCOM.ChooseFromListCreationParams
objPara = SBO_Application.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams)
objPara.MultiSelection = False
objPara.ObjectType = "93"
objPara.UniqueID = "CFL1"
objCFL = objCFLS.Add(objPara)
txtOrderNo = objForm.Items.Item("txtOrderNo").Specific
txtOrderNo.DataBind.SetBound(True, "", "DSPO")
txtOrderNo.ChooseFromListUID = "CFL1"
txtOrderNo.ChooseFromListAlias = "U_PODocNum"
I am getting error as,
Data Source - Alias Not Found
Edited by: Dilip Kumbhar on Jan 2, 2009 2:43 PM