| Home | Previous Lesson: Format 4 Next Lesson: External Functions |
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.
| Home | Previous Lesson: Format 4 Next Lesson: External Functions |