Building a DataWindow object

You use a wizard to build a new DataWindow object. To create a DataWindow object or use the DataWindow painter, you must be connected to the database whose data you will be accessing. When you open the DataWindow painter or select a data source in the wizard, DataWindow Designer connects you to the DBMS and database you used last. If you need to connect to a different database, do so before working with a DataWindow object.

NoteColumn limit There is a limit of 1000 on the number of columns in a DataWindow object.

For information about changing your database connection, see Connecting to Your Database.

StepsTo create a new DataWindow object:

  1. In the Solution Explorer, right-click the library where you want to save the DataWindow object and select Add New Entry.

  2. In the Add New Entry dialog box, select DataWindow Object from the categories list.

  3. Select a DataWindow style from the Templates list.

    The presentation style determines how the data is displayed. See “Choosing a presentation style”.

  4. Provide a name for the DataWindow object, and click Add.

    The DataWindow object name can be any valid DataWindow Designer identifier up to 40 contiguous characters. A common convention is to prefix the name of the DataWindow object with d_. For information about DataWindow Designer identifiers, see Appendix A, “Identifiers.”

    The appropriate DataWindow object wizard for the style you selected starts.

  5. If you want data to be retrieved in the Preview view when the DataWindow object opens, select the Retrieve on Preview check box.

  6. Define the data source.

    See “Selecting a data source”.

  7. Choose options for the DataWindow object and click Next.

    See “Choosing DataWindow object-wide options”.

  8. Review your specifications and click Finish.

    The DataWindow object displays in the Design view.

  9. Save the DataWindow object.