My understanding of the DynamicModel structure is that it is a way to generate a dynamic datastore from SQL, similar to executing these statements:
new_syntax = SQLCA.SyntaxFromSQL(new_sql, 'Style(Type=Form)', error_syntaxfromSQL)
dw_new.Create(new_syntax, error_create)
We have an implementation use for this structure. However, the 30-column restriction will prevent us taking advantage of it as most of our SQL SELECTs have far more columns.
- Why is there a restriction?
- Are there plans to expand the maximum number of columns in a future release?
Regards,
Don Olliver
Remarks at the bottom of this page state that DynamicModel supports up to 30 columns.
https://docs.appeon.com/appeon_online_help/powerbuilder/api_reference/SnapObjects.Data/DynamicModel/DynamicModel.html?q=DynamicModel\
Don
REF > PowerBuilder Help > Users Guide > Working with DataWindows > Defining DataWindow Objects > Building a DataWindow object.
There is a callout on top of that help page for number of columns.
Ahhhh .... Snap vs PB. I was thinking native PB.
Yes, Snap (aka C#) has that limitation whereas PB's limitation is like 1,024.
Regards ... Chris