Hi All,
I created a virtual DAC and linked that to my graph but when opening the screen it gives this error.
can someone help me out?
Incorrect syntax near the keyword 'WHERE'.
My DAC and Graph
[PXCacheName("HMRCVendorRegisterDetailDummy")]
[PXVirtual]
public class HMRCVendorRegisterDetailDummy : IBqlTable
{
#region Hmrcregid
public virtual int? Hmrcregid { get; set; }
public abstract class hmrcregid : PX.Data.BQL.BqlInt.Field<hmrcregid> { }
#endregion
#region VendorID
[PXUIField(DisplayName = "Vendor", Required = true)]
[PXInt]
[PXCheckUnique(typeof(bAccountID))]
[PXUnboundDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)]
public virtual int? BAccountID { get; set; }
public abstract class bAccountID : PX.Data.BQL.BqlInt.Field<bAccountID> { }
#endregion
#region Utrno
[PXString(256, IsUnicode = true, InputMask = "")]
[PXUnboundDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)]
[PXUIField(DisplayName = "UTR No", Required = true)]
public virtual string Utrno { get; set; }
public abstract class utrno : PX.Data.BQL.BqlString.Field<utrno> { }
#endregion
#region VerificationNo
[PXString(256, IsUnicode = true, InputMask = "")]
[PXUIField(DisplayName = "Verification No")]
[PXUnboundDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)]
public virtual string VerificationNo { get; set; }
public abstract class verificationNo : PX.Data.BQL.BqlString.Field<verificationNo> { }
#endregion
#region VerifiedDate
[PXDate()]
[PXUIField(DisplayName = "Verified Date")]
[PXUnboundDefault(typeof(AccessInfo.businessDate))]
public virtual DateTime? VerifiedDate { get; set; }
public abstract class verifiedDate : PX.Data.BQL.BqlDateTime.Field<verifiedDate> { }
#endregion
#region VerifiedTypeID
[PXString(1, IsFixed = true)]
[PXUnboundDefault(RegisterTypes.System, PersistingCheck = PXPersistingCheck.NullOrBlank)]
#endregion
}
//Graph
public class HMRCVendorBulkRegisterNewMaint : PXGraph<HMRCVendorBulkRegisterNewMaint>
{
public PXSave<HMRCVendorRegisterDetailDummy> Save;
public PXCancel<HMRCVendorRegisterDetailDummy> Cancel;
public SelectFrom<HMRCVendorRegisterDetailDummy>.View VendorRegisterDetail;
}
Thanks
Best answer by jinin
View original