Hello,
i have a problem with a screen that i have made,
when the table has zero records and i try to insert a record this error appears.
but when there is one or more records in the table, the insert happens successfully.
Appreciate your feedback.
Answer
Error when inserting in table for the first time
+1Best answer by Naveen Boga
And, here is the sample DAC field.
#region TESTID
[PXDBString(30, IsKey = true, IsUnicode = true, InputMask = "")]
[PXDefault()]
[PXUIField(DisplayName = "TEST ID", Required = true)]
[PXSelector(typeof(Search<MySetup.TransferNbr>), typeof(MySetup.TransferNbr), typeof(MySetup.description), typeof(MySetup.isActive))]
public virtual string TransferNbr { get; set; }
public abstract class transferNbr : BqlString.Field<transferNbr> { }
#endregion
+1
This is my DAC
+19Hi
If this is the case, can you please mark TransferNbr as a key field at DAC level ( Is Key = True ) and check once?
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
+1Hi
If this is the case, can you please mark TransferNbr as a key field at DAC level ( Is Key = True ) and check once?
When i make this, when i write something in the transfer number it disappears after i click on another field
+19+1you mean, make the edit and show you it ?
+19And, here is the sample DAC field.
#region TESTID
[PXDBString(30, IsKey = true, IsUnicode = true, InputMask = "")]
[PXDefault()]
[PXUIField(DisplayName = "TEST ID", Required = true)]
[PXSelector(typeof(Search<MySetup.TransferNbr>), typeof(MySetup.TransferNbr), typeof(MySetup.description), typeof(MySetup.isActive))]
public virtual string TransferNbr { get; set; }
public abstract class transferNbr : BqlString.Field<transferNbr> { }
#endregion
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
+1And, here is the sample DAC field.
#region TESTID
[PXDBString(30, IsKey = true, IsUnicode = true, InputMask = "")]
[PXDefault()]
[PXUIField(DisplayName = "TEST ID", Required = true)]
[PXSelector(typeof(Search<MySetup.TransferNbr>), typeof(MySetup.TransferNbr), typeof(MySetup.description), typeof(MySetup.isActive))]
public virtual string TransferNbr { get; set; }
public abstract class transferNbr : BqlString.Field<transferNbr> { }
#endregion
It Seems like the PXDefault was the solution, thank you so much for your time and effort.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.