Introduction to PowerBuilder

Data Manipulation

To view the data that is stored in a table or to even alter/manipulate it, invoke popup menu on the table title and select Edit Data > Appropriate Format option or click on one of the preview icons from the Painterbar.

Once you are in the Data Manipulation sheet, you can insert new data or change/delete existing data from the table.

Any data that is added/changed are held at the client site, i.e., in your computer's memory. To save the changes in the back-end database, select Rows > Update menu option.

Go to "Output (product) � Units" of the units table, click on the InsertRow icon or select Rows > Insert menu option and type the following data and save it to the database.

Pressing the TAB key when the cursor is in the description column will append a new row automatically.

U	Unit
lb	pound
in	inch
gl	gallon

Note that PowerBuilder allows you to manipulation data in the "Output (product) � Units" only when the table has a unique index. When no unique index is present, you can manipulate the data using SQL statements in the ISQL sheet.

Home	Previous Lesson: Creating Indexes Next Lesson: Importing Data