Introduction to PowerBuilder

Interactive SQL from the DB Painter

Remember you sorted and filtered data in the "Output (product) � Units". Both sorting and filtering was done by PowerBuilder and not by the connected database. You can restrict and sort the results from the connected database by using WHERE and ORDER BY clauses in the SELECT statement. In "Output (product) � Units" and database painter custom-built SELECT statements cannot be executed. It is possible only in the ISQL sheet. The sheet name depends on the connected database. For Sybase, it is ISQL.

Home	Previous Lesson: PowerBuilder Attributes and System Tables Next Lesson: Executing SQL Statement