cancel
Showing results for 
Search instead for 
Did you mean: 

unexpected behaivor setting UserFieldsMD.LinkedTable property

Former Member
0 Kudos

He all

I have a user form created for maintain a group o userfields added to the OITM table (object 4). The form property Object type, in design tame, was set to 4 and AutoManaged property to true.

Three fields are referenced to another user tables (with their UDO and type MasterData) with the property LinkedTable.

When the form obtains the info in these three fields referenced I see the "ItemCode" value writo into.

If I not stablish the property LinkedTable the form runs ok, showing the values of the fields well, updating and loading data from db. But there is not a good solution but I lost the referential integritiy.

Any idee about this? I have omited any step? This is a bug? A limitation?

Thanks in advance

-



            oUserFieldsMD = oCompany.GetBusinessObject(BoObjectTypes.oUserFields)
            oUserFieldsMD.TableName = "OITM"
            oUserFieldsMD.Name = "XX_MARCA"
            oUserFieldsMD.Description = "Marca"
            oUserFieldsMD.Type = BoFieldTypes.db_Alpha
            oUserFieldsMD.SubType = BoFldSubTypes.st_None
            oUserFieldsMD.EditSize = 8
            oUserFieldsMD.Mandatory = BoYesNoEnum.tNO
            oUserFieldsMD.LinkedTable = "XX_MARCA"
            oUserFieldsMD.DefaultValue = ""
            Try
                UserFieldsAdd(oUserFieldsMD)
#If DEBUG Then
                Console.Write("...Ok")
#End If
            Catch ex As Exception
#If DEBUG Then
                Console.Write("...Fail")
#End If
            End Try

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Sorry by these post, the error is the table name linked.

AdKerremans
Active Contributor
0 Kudos

Hi Alfonso,

Should the name of the linked table not be @xx_MARCA?

Regards

Ad