|
Advanced PowerBuilder
Summary
In 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.
We've covered this topic here, to give you
an understanding of these topics and also prepare you for the CPD exam. Don't worry if you
get doubts and questions.
|
