|
Advanced PowerBuilder SummaryIn this session, you have learned about executing SQL statements, by embedding them in the PowerScript. In real-world projects, you can use DataWindows 99% of the time. We don't think you will ever need format 3 or 4. If needed, use the statement given by the user to create a dynamic DataWindow, which is more flexible and efficient. For example, in Format 4, or in any, you were able to find out the number of columns and their data types in the result set. This is just half of the work. How you are going to display the result set and print it is still a big nightmare. If you use dynamic DataWindows, it is easy to program and in fact everything else is easy. For a quick summary of this session, browse embedded-and-dynamic-sql.ppt (a PowerPoint presentation).
|
