Skip to Content
0
Former Member
Sep 18, 2007 at 09:20 AM

unexpected behaivor setting UserFieldsMD.LinkedTable property

47 Views

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