Is it possible to have a Graph and page utilize an completely unbound DAC?
When attempting this currently in 4.20 I'm receiving the following error message:
Incorrect syntax near the keyword 'FROM'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'FROM'.
If I create a table in the database and change my DAC fields from say PXInt to PXDBInt, then the page loads however for what I'm attempting to do I have no need to actually store the data.
DAC sample:
namespace Acumatica1
{
[PXPrimaryGraph(typeof(UnboundDataTest))]
[System.SerializableAttribute()]
public class UnboundDAC : PX.Data.IBqlTable
{
public abstract class unboundKey : PX.Data.IBqlField
{
}
protected int _UnboundKey;
[PXInt(IsKey = true)]
[PXUIField(Visible = false)]
public virtual int UnboundKey
{
get
{
return this._UnboundKey;
}
set
{
this._UnboundKey = value;
}
}
#region UnboundText
public abstract class unboundText : PX.Data.IBqlField
{
}
protected string _UnboundText;
[PXString]
[PXUIField(DisplayName = "Text")]
public virtual string UnboundText
{
get
{
return this._UnboundText;
}
set
{
this._UnboundText = value;
}
}
#endregion
}
}
Graph Sample:
public class UnboundDataTest: PXGraph<UnboundDataTest>
{
public PXSelect<UnboundDAC> UnboundInfo;
}