Filter
Top Products
Manipulating data
86 DataWindow .NET
Manipulating data
As you work on the database, you often want to look at existing data or create
some data for testing purposes. You might also want to test display formats,
validation rules, and edit styles on real data.
DataWindow Designer provides data manipulation for such purposes. With
data manipulation, you can:
• Retrieve and manipulate database information
• Save the contents of the database in a variety of formats (such as Excel,
PDF, or XML)
Retrieving data
❖ To retrieve data:
1 In the Database painter, select the table or database view whose data you
want to manipulate.
2 Do one of the following:
• Click one of the three Data Manipulation buttons (Grid, Tabular, or
Freeform) in the PainterBar.
• Select Data or Edit Data from the Object or pop-up menu and choose
one of the edit options from the cascading menu that displays.
All rows are retrieved and display in the Results view. As the rows are
being retrieved, the Retrieve button changes to a Cancel button. You can
click the Cancel button to stop the retrieval.
Exactly what you see in the Results view depends on the formatting style you
picked. What you see is actually a DataWindow object. The formatting style
you picked corresponds to a type of DataWindow object (grid, tabular, or
freeform). In a grid display, you can drag the mouse on a column's border to
resize the column.