Skip to Content
0
Former Member
Jan 02, 2009 at 09:06 AM

CFL for user table

105 Views

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