Hi,
I’m creating a pretty simple new table / DAC to create a validated list of cities for custom usage.
This table consists of 2 fields, a CityID (int) identifier and a CityName (string).
I want the CityName to be multi-lingual, so based on what I found in documentation, I’m creating it with the [PXDBLocalizableString(50, IsUnicode = true)] attribute.
When I try to open a simple grid view screen I get this error “Invalid object name 'UsrCityKvExt'.”
The field is displayed and I see the language selector in it, but data can’t be displayed/inserted/updated.
When I just use a PXDBString instead, I have no errors, and I can do everything in a single language.
This is a snippet of the DAC I’m using for UsrCity (it also has the typical Acumatica system fields CreatedBy, TStamp, etc.)
#region CityID
[PXDBIdentity(IsKey = true)]
[PXUIField(DisplayName = "City ID", Enabled = false)]
public virtual int? CityID { get; set; }
public abstract class cityID : PX.Data.BQL.BqlInt.Field<cityID> { }
#endregion
#region NoteID
[PXNote()]
public virtual Guid? NoteID { get; set; }
public abstract class noteID : PX.Data.BQL.BqlGuid.Field<noteID> { }
#endregion
#region CityName
[PXDBLocalizableString(50, IsUnicode = true)]
//[PXDBString(50, IsUnicode = true)]
[PXUIField(DisplayName = "City")]
public virtual string CityName { get; set; }
public abstract class cityName : PX.Data.BQL.BqlString.Field<cityName> { }
#endregion
Any idea what I’m missing to get this to work as expected?
