Compartir a través de


Query and View Designers

Use the Query designer and the View designer to create and modify queries and views. When the Query or View designer is active, Microsoft® Visual FoxPro® displays the Query menu and the Query toolbar or View designer toolbar.

The top pane of the designer displays the tables in the query or view. Each table is represented by a resizeable window that lists the table's fields and indexes. The designer shows join conditions by displaying lines that connect fields between tables. You can drag indexed fields between tables to create join conditions. Double-click a line to display the Join Condition Dialog Box for editing the condition.

In This Section

  • Designers
    Designers make it possible for you to design the windows, dialog boxes, and components in your application visually.
  • Class Designer
    Use the Class designer to create and modify classes visually.
  • Connection Designer
    Use the Connection designer to create and modify named connections. Because connections are stored as part of a database, you only can use the Connection designer if you have a database open.
  • Data Environment Designer
    Use the Data Environment designer to create and modify the data environment of forms, form sets, and reports visually.
  • Database Designer
    The Database designer displays all the tables, views, and relationships contained in a database.
  • Form Designer
    Use the Form designer to create and modify forms and form sets visually. A form set consists of one or more forms that can be manipulated as a unit.
  • Label Designer
    Use the Label designer to create and modify labels. When the Label designer window is active, Microsoft® Visual FoxPro® displays the Report menu and the Report Controls toolbar.
  • Menu and Shortcut Designers
    Use the Menu designer and the Shortcut designer to create menus, menu items, submenus of menu items, lines that separate groups of related menu items, and so on.
  • Report Designer
    Use the Report designer to create and modify reports. When the Report designer window is active, Microsoft® Visual FoxPro® displays the Report menu and the Report Controls toolbar.
  • Table Designer
    Use the Table designer to create and modify database tables, free tables, fields, and indexes.