Both dynamic DataWindows and dynamic SQLs will be sent to PowerServer at runtime.
-
For DataWindows that are dynamically created using SyntaxFromSQL, when the SQL SELECT statement is sent from the client to the PowerServer, PowerServer will get the schema of tables and columns from the database and then PowerBuilder Runtime will generate the DataWindow source code using the schema information.
-
Similarly, SQL statements that are dynamically generated from SetSQLSelect, QueryMode, QuerySort, SetFullState, SetChanges, or PSR will be sent from the client to PowerServer and handled by PowerServer dynamically based on the specific conditions and operations set by the client.
