Internal error " (UDO2) (-2007) occurred CFL

[Former Member]

Hello,

I have a Form defined in the screen Painter.

In it i have a editText field which is linked to a CFL that chooses values from the UDO that the form is connected to.

when i hit the key in the fild with no text in it e recive a error message <b>Internal error(-1003) occurred [Message 131-183]</b> when i hit the key in the field with some text in it and that text is not in the dataBase e get an error

<b>Internal error " (UDO2) (-2007) [Message 131-183]</b>

When i hit the key in the field with some text in it and that text is in the database the CFL autoCompleat the field and works fine

Complex problem

Thanks For your HELP

Pedro Gomes

[Trinidad · Accepted solution]

Hi Pedro,

Which B1 version are you working with?

User defined CFL should work the same way as B1 CFL and then work fine even if the EditText is empty... strange

Regards

Trinidad.

[Former Member · Accepted solution]

Hi Trinidad,

I'm using

SPA B1 SP01SAP Business One 2005 A (6.80.318) SP: 01 PL: 12

In the same form i have other CFL that work fine only the one that uses the form UDO as Object Type thows the errors

Thanks for your help.

Pedro Gomes

[Trinidad · Accepted solution]

Hi,

I have tried with SP01 PL11 and it works fine for my UDO...

Here is my code

'Add EditText to the form for User Object

oItem = oForm.Items.Add("EdTxtUO", SAPbouiCOM.BoFormItemTypes.it_EDIT)

oItem.Left = 105

oItem.Top = 50

oItem.Width = 100

oEdit = oItem.Specific

'Add UserDataSource for the EditText UserObject

etUDSuo = oForm.DataSources.UserDataSources.Add("ET_UDS_UO", SAPbouiCOM.BoDataType.dt_SHORT_TEXT)

'Link UDS to EditText

oEdit.DataBind.SetBound(True, "", "ET_UDS_UO")

' Add ChooseFromList for EditText to the form

oCFLCPuo = SB1_App.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams)

oCFLCPuo.ObjectType = "TT_MD"

oCFLCPuo.UniqueID = "UserObjectCFL"

oCFLuo = oForm.ChooseFromLists.Add(oCFLCPuo)

'Link CFL to EditText

oEdit.ChooseFromListUID = "UserObjectCFL"

oEdit.ChooseFromListAlias = "Code"

Hope it helps

Trinidad.

[Former Member · Accepted solution]

Hi Again,

I have something like

oEdit.DataBind.SetBound(True, "@MGCF", "U_CCode")

and the UDO uses @MGCF as a master Table

is this possible ???

Thanks

[Trinidad · Accepted solution]

Hi,

I have tried to asign a DBDataSource (same table as the UDO main table of the CFL) to the EditText I want to open the CFL and it works fine... strange...

Are you linking the "Code" field of your UDO to the ChooseFromListAlias of your EditText or another field? Please try to use Code for the ChooseFromListAlias property of the EditText and see if it changes something.

In my code I'm working with the Code field.

Regards

Trinidad.

[Former Member · Accepted solution]

Hi,

The @MGCF table is a document therefor it doesn't have a Code column so i use the U_CCode as a UDF that represent the Code of the Document

should i user the DocEntry Column ???

Thanks again for your Help

Regards

Pedro Gomes.

[Trinidad · Accepted solution]

I think it si worth to give it a try.

[Former Member · Accepted solution]

Hi,

Problem Solved

The DocEntry Column solve it

Thanks for your suport

Regards. Pedro Gomes

[former_member909389]

Hi,

In Your user defined table Go to

1. Sap Client -> Tools -> Customization Tools -> "Select" object registration wizard

2. Choose updating existing object, then select your table for that form

3. next Move to Modifying service wizard, Check "Find" Option check box is Checked or not, if not please check

Thanks

[former_member763929]

Thanks for coming to SAP Community for answers. Please post your question as a new question here:

Since you're new in asking questions here, check out our tutorial about asking and answering questions (if you haven't already), as it provides tips for preparing questions more effectively, that draw responses from our members.

Please note, that your post here won't be answered.