Q+E COMMANDS
Q+E COMMAND MENUS

This index lists the Q+E command menus available on the menu bar.  Choose a menu to view a list of the specific commands within each group.

Edit Commands Menu

File Commands Menu

Help Commands Menu

Layout Commands Menu

Search Commands Menu

Select Commands Menu

Sort Commands Menu

Window Commands Menu


Edit Menu

Add After

inserts a blank row for a new field definition in a Define window

Add Before

inserts a blank row for a new field definition in a Define window

Add Record

inserts a new record in a database file

Allow Editing

enables you to make changes to records

Copy

places a copy of the current selection on the Clipboard

Copy Special

specifies additional copying options when you copy data to the Clipboard

Cut

deletes the current selection and places it on the Clipboard

Delete Fields

deletes selected field definitions in a Define window

Delete Records

removes selected records from a file

Form

displays a database form that you can use to edit, add, or delete records

Form Setup

customizes the Edit Form dialog box

Paste

inserts the current contents of the Clipboard into the current selection

Paste Append

inserts records at the end of a file

Undelete Records

restores records marked for deletion in a dBASE file

Undo

reverses certain commands or removes what you have typed

Update All

places the same value in all selected fields

Zoom Field

displays the contents of a field in a separate window


Edit Add After

Inserts a blank row for a new field in a database file definition displayed in a Define window.  Creates space for a new column in the database file.

Inserts the field below the field that is currently selected.

If no field is selected, adds a new field below the last field.

To add a new field to a database file:

1	Choose File Define and open the database file.

2	Select any field in the row above where you want to insert the new definition.

3	Choose Edit Add After.

4	Enter or select values to define the new field.

Related Topic

Edit Add Before


Edit Add Before

Inserts a blank row for a new field in a database file definition displayed in a Define window.  Creates space for a new column in the database file.

Inserts the field above the field that is currently selected.

If no field is selected, adds the new field above the first field.

To add a new field to a database file:

1	Choose File Define and open the database file.

2	Select any field in the row below where you want to insert the new definition.

3	Choose Edit Add Before.

4	Enter or select values to define the new field.

Related Topic

Edit Add After


Edit Add Record

Displays a form for adding new records to an existing database file.

To add a new record to a database file:

1	Enable editing by choosing  Edit Allow Editing.

2	Choose Edit Add Record.

3	Type the information for each field in the new record.  Use the Tab key to move to the next field, and Shift+Tab to go to the previous field.

4	Choose the Exit button and press Enter.

The new record is added to the end of the file.

Related Topic

Edit Form


Edit Allow Editing

Allows you to make changes to the current file by updating, adding, or deleting records.

Choose this command each time you open a file in which you want to make changes.

A check mark appears next to this command when it is active; if you choose the command again, the check mark is removed and editing is no longer allowed.

This command does not appear on the menu if your version of Q+E is read-only; it is dimmed if editing is not allowed for the current file or query.


Edit Copy

Copies the current selection and places it on the Clipboard.

You can copy a portion of a field, entire fields, multiple fields, an entire record, or multiple records.

You can paste the copied data into the same database file, a different database file, or another application that supports DDE.

To copy information:

1	Select the information you want to copy.

2	Choose Edit Copy.

If copying the entire record or records, choose Edit Paste Append to paste at the end of the file.

3	Select the location where you want to place the information.

4	Choose Edit Paste.

If pasting into another application, choose that application's Edit Paste Link command or equivalent to create a dynamic link between the other application and Q+E.

Related Topics

Edit Copy Special

Edit Paste

Edit Paste Append


Edit Copy Special

Specifies additional copying options when you copy Q+E data to the Clipboard.

Include Column Headings

Turn on this check box if you want to include the column headings when copying values to the Clipboard.

Include Record Numbers

Turn on this check box if you want to include the record numbers to the left of each record when copying values to the Clipboard.

Link Formula

If you want to paste link the information in a Microsoft Excel worksheet, select the style for the formula that you want to appear in the Excel formula bar:

Query Name

When selected, the name of the Query window or query file is included in the formula.

SQL Text

When selected, the SQL SELECT statement is included in the formula.

Link Data

Specifies what data you want copied to the Clipboard:

Entire Window

Copies every record in the Query window.

Selected Area

Copies only the data currently selected in the Query window.

SQL Text

Copies the current SQL SELECT statement to the Clipboard, instead of the records that would be selected by the statement.


Edit Cut

Deletes the current selection and places it on the Clipboard.

Before using this command, you must enable editing by choosing Edit Allow Editing .

You can cut a portion of a field, an entire field, multiple fields, an entire record, or multiple records.

You can paste the cut data into the same database file, another database file, or another application that supports DDE.

To cut information:

1	Select the information you want to cut.

2	Choose Edit Cut.


Edit Delete Fields

Deletes selected field definitions in a database definition displayed in a Define window.

When you remove a field in the Define window and save your changes, you delete all the values stored in that column in the database file.

If you delete a field definition by mistake, you can restore it by choosing the Edit Undo command immediately after you choose Edit Delete Fields.

To remove a field definition:

1	Select any value in the row containing the field definition.

2	Choose Edit Delete Fields.


Edit Delete Records

Deletes selected records from the file.

Before using this command, you must enable editing by choosing Edit Allow Editing.

The records are removed from the file, and the remaining records are renumbered.

If you delete records by mistake, you can restore them by choosing the Edit Undo command immediately after you choose Edit Delete Records.

In dBASE files, records are not actually deleted, but are marked for deletion and are no longer displayed in the Query window.  To completely remove the records, you must open the file in a Define window, choose File Save As, and turn on the Pack File option.

To delete records:

1	Select at least one field in each record you want to delete.

2	Choose Edit Delete Records.

To see deleted records (dBASE files only):

Choose Select Deleted Records.

To restore records marked for deletion (dBASE files only):

1	Choose Select Deleted Records to display them.

2	Select a field in each record you want to restore.

3	Choose Edit Undelete Records.


Edit Form

Displays a database form which you can use to view, change, add, duplicate, and delete records.

You must choose Edit Allow Editing before attempting to change database records.

Provides an alternative to the Query window for viewing database records.

Displays the record currently selected when you choose the command.  If no record is selected, displays the first record.

Query window column headings are listed in the dialog box.  The contents of each field in one record is displayed next to the column heading.

Computed or protected fields cannot be edited.

The scroll bar shows your position in the database.

The position indicator in the upper-right corner of the dialog box shows the number of the record currently displayed in the box.  If you are creating a new record, the record number changes to "New Record" .

New

Displays a blank form where you can enter values for a new record.  New records are added to the end of the file.

Dup

Creates a duplicate of the record currently displayed, and places the duplicate at the end of the file.

Delete

Deletes the data in the currently displayed record, and renumbers the records that follow it.  Records deleted using this command cannot be restored using the Edit Undo command.

Restore

Restores the edited fields in the displayed record to their original values.  You cannot restore changes after pressing Enter or scrolling to another record.

Exit

Closes the data form.

Related Topic

Edit Form Setup


Edit Form Setup

Customizes the appearance of the dialog box displayed when you choose the Edit Form command.

If there are more fields than can fit in the dialog box, the last record fields are not displayed.

Number of Columns

Specifies the maximum number of columns that can be displayed across the width of the dialog box.

4
úU
@
You cannot close a file when a field is zoomed.  First close the Zoom window by choosing  the Close command from the zoom window's Control menu or by pressing Alt+F4.


File Close Index

Closes an index file (.NDX or .MDX extension) associated with a dBASE file displayed in the Query window.

Choose File Close Index, and select the index you want to close from the dialog box.

Q+E closes all index files automatically when you close the associated database file.


File Define

Creates, modifies, or deletes database file definitions.

Opens a Define window where you can modify an existing database definition or create a new one.

After you define a new database file, it contains no records.  To add records, open the file in a Query window.

Each row in the Define window corresponds to a field in the resulting database file; the order of the rows determines the order of the columns when you open the database file in a Query window.

When you choose File Define, Q+E displays a dialog box with the following options:

File Name

Displays the name of the file or table you want to modify or delete.  (Depending on the source, this box may have a different name.)

Source

Lists the database systems for which drivers have been installed, and any servers that you are currently logged on to.

File List

Lists available files for the source in the current directory.  (Depending on the source, this box may have a different name.)

Directory List

Changes current drive or directory.  (Depending on the source, this box may have a different name.)

OK

Opens a Define window which you can use to modify an existing file definition.  The information needed to define a field depends on the type of database system you are using.  For more information, see the appendix in the Q+E for Microsoft Excel User's Guide that corresponds to the type of database file you are defining.

New

Displays a blank Define window which you can use to create a new database definition.

Options

The options available depend on the type of file selected under Source.  See the appendix in the Q+E for Microsoft Excel User's Guide that corresponds to the type of database file you are defining.

Delete

Deletes the selected database definition and all the data associated with it.

For more information, see Chapter 3, "Creating and Using a Worksheet," in the Microsoft Excel User's Guide.


File Define Index

Creates, deletes, or rebuilds a dBASE index file.  Index files are used to sort records or improve performance when selecting records or joining files.

This command is available on the File menu when a Define window is active and contains a dBASE file definition.  Choose File Define before defining an index.

Select the column or columns whose values you want to use to build the index, and then choose File Define Index.

dBASE II and III index files have the extension .NDX, and each file contains one index.  dBASE IV index files have the extension .MDX, and each file may contain multiple indexes, called "tags."  You must always specify the name of the .MDX file index tag that you want to create, rebuild, or delete.

Use this command to rebuild index files after you add records to or delete records from the associated database file or change the values in the fields.

File Name

Name of the file you want to create, rebuild, or delete.

Tag Name

If File Name contains the name of a dBASE IV index file, this is the name of the index tag you want to create, rebuild, or delete.  See the Tag List box for the list of tags.

Expression

The index expression whose values are used to build the index.  The expression is usually a single field name but can consist of a series of field names joined by plus signs (+).

By default, the expression will be the name of the column in which you selected a field before choosing File Define Index.

Unique Index

Turn on this check box to create a unique index that does not include duplicate values.  Unique indexes are not supported for dBASE II database files.

Descending

Creates an index file that will sort in descending order (available for dBASE IV files only).

File List

Lists dBASE index files in the current directory.  (This box may have a different name depending on the source to which you are connected.)

Directory List

Lists current drives and directories.  (This box may have a different name depending on the source to which you are connected.)

Tag List

Lists current tags available for the dBASE IV index file shown under File Name.  Select the specific tag that you want to modify or rebuild.

Delete

Deletes the selected index file.

For more information, see Appendix A, "Using Q+E with dBASE," in the Q+E for Microsoft Excel User's Guide.

Related Topics

File Open Index

File Use Index


File Exit

Closes all open windows and ends your Q+E session.


File Logoff

Terminates your SQL Server, OS/2 Extended Edition, or Oracle session.

You are logged off automatically when you exit Q+E.


File Logon

Initiates access to SQL Server, OS/2 Extended Edition, or Oracle.

The dialog boxes displayed and the specific log-on procedures required depend on the source you are logging on to.

For more information, see the appendix in the Q+E for Microsoft Excel User's Guide that corresponds to your database system.


File Open

Displays the records in a database file, or the results of a query, in a Query window.

You can open more than one database file or query file; each file is displayed in a separate Query window.

To switch between open Query windows, click in a window or press Ctrl+F6.

The dialog boxes and available options for this command depend on the type of file you are opening and the source you are logged on to.

For more information, see the appendix in the Q+E for Microsoft Excel User's Guide that corresponds to your database system.


File Open Index

Opens a dBASE index file (.NDX or .MDX extension) associated with a dBASE file. You open an index to sort records or improve performance during selections and joins.

This command is available on the File menu when a Query window containing a dBASE file is active.

File Name

Specifies the name of the index file to open.  By default, displays *.?dx to search for files with the .NDX or .MDX extension.

File List

Lists the index files in the current directory.  (This box may have a different name depending on which source you are connected to.)

Use Index

When turned on, causes Q+E to sort the dBASE file according to the index file as soon as you open it.

Directory List

Lists the available drives and directories on your system.  (This box may have a different name depending on the source to which you are connected.)


File Page Setup

This command is only available on the File menu when a Query window is active.

Controls how the current Query window appears when printed.

Records are printed in formatted columns as they appear in the Query window.

If there are more columns than your printer can accommodate on one page, Q+E prints the extra columns on following pages.

Also affects how files will appear when you save them using the Print To File option of the File Save As command.

Title

Determines the title that will appear centered on the first line of each page of the printout.  Defaults to the name of the Query window, for example, Query1(EMP.DBF).

Margins

Determines the amount of space in inches between the edge of the paper and the printed columns.  You can accept or edit the margin settings.

Include Options

Additional options you can choose to modify the appearance of the file when printed.

Column Names

Places the column name at the top of each column when the file is printed.

Record Numbers

Places the record numbers in the first column when the file is printed.

Number Pages

When this check box is turned on, page numbers are placed in the upper-right corner of the page when the file is printed.

Date

When this check box is turned on, the current date is printed in the upper-left corner of the page.

Time

When this check box is turned on, the current time is printed in the upper-left corner of the page.


File Print

Prints a Query or Define window.  When you print a Query window, you can control printing options with the settings in the File Page Setup dialog box.

If you want to print the results of a query to a text file, use File Save As.

Copies

Determines the number of printed copies.

Draft Quality

Prints a document faster.  Usually produces a somewhat lower quality version of the document.


File Printer Setup

Identifies the installed printer you specify, and allows you to set options for that printer.

Printer

Lists all currently installed printers.

Setup

Displays a dialog box with the options available for the printer you selected.  For information on printer settings, see the owner's manual for your printer.


File Save

Saves the current query definition in the open Query file, or saves the file definition in a Define window.


File Save As

When you are working in a Query window, this command saves the current query as one of the following:

A query definition you can re-execute after the data in your database file has changed

An ASCII text file formatted as mailing labels

An ASCII text file formatted as if printed

A file for another database system.

When you are working in a Define window, this command can be used to:

Save a database file definition as a new database file.

Pack dBASE files.  When you choose this command when working with a dBASE file in a Define window, the Pack File check box appears under Options in the dialog box.  Turn on this check box if you want to permanently delete dBASE records marked for deletion.

Save As

Proposes a name if you have not saved the query or database definition before.  Either accept the name or change it.

Saves in the current directory unless you type a full path name or choose a different directory from the directory listing.

Destination (Query windows only)

Lists the different database formats in which you can save the Query.  Contents of list may vary depending on which database options you set when installing Q+E.

Use Headings for Field Names (Query windows only)

Check this option if you want to use the current column headings as the field names in the record you create by saving the query.

Options

The options displayed in the dialog box depend on the destination file type selected.  For the options that apply, see the appendix that corresponds to your database system in the Q+E for Microsoft Excel User's Guide.


File Use Index

Specifies a dBASE index to use for sorting.  Changes the index currently being used for sorting if one is already in use.

Before using this command, you must open at least one dBASE index file using the File Open Index command.

Select the index you want to use in the list of indexes in the File Use Index dialog box.

If you do not want to use any index file, select [None] in the index list.

If you have an index file open because you want to improve record selection or join performance, select [None] in the index list to make sure that no other index file is currently being used for sorting.


Help Menu

About Q+E

displays information about Q+E

Index

displays an index of command menus


Help About Q+E

Displays a dialog box that tells you which version of Q+E you are using.


Help Index

Displays the Q+E Help Index of Q+E commands.

Press Tab to move to the topic you want, and then press Enter or click the topic with the mouse.


Layout Menu

Column Width

sets the width of columns in Query window

Define Column

modifies columns or creates new columns in a Query window

Define Field

specifies the data type for values in text files or Microsoft Excel worksheet files

Font

changes the font, size, and style of text in a Query window

Move Column

changes the arrangement of columns in a Query window

Only Show Totals

displays the calculated totals only for columns in a Query window

Options

sets global options for Q+E

Parse Line

specifies where each value in a fixed-format text file begins and ends

Remove Column

hides a column in a Query window

Totals

controls the display of column totals in the Query window


Layout Column Width

Changes the width of selected columns in a Query window.

Select a column or a field within a column before choosing this command.

You can select several columns and change their widths simultaneously.

For character fields, the actual number of characters displayed may vary since characters in proportional fonts vary in width.

You can change column widths with the mouse by pointing to the vertical bar to the right of the column heading and dragging to the desired column width.

Column Width

Controls the number of characters or numeric digits that can fit in the column.

Default Width

Turn this check box on if you want to set the column to the default width.  The default width is either the width defined for the field in the database file or the maximum default column width (set with the Layout Options command), whichever is smaller.


Layout Define Column

Restores removed columns, creates computed columns, and changes column headings in a Query window.

Heading

Sets the name that appears at the top of each column.  By default, the heading matches the database field name.  Type a new name if you want to change the column heading.

Expression

The text or arithmetic formula that determines the contents of the column.  By default, contains the database field name.  To create a calculated column, combine database field names with operators to create a new expression.

Fields

Lists the current fields in the database file.

Add

Inserts a new column based on an existing query field or a copy of the current column.

For more information on defining columns and creating calculated columns, see Chapter 3, "Formatting and Analyzing Your Data," in the Q+E for Microsoft Excel User's Guide.

To insert a new column

1	Choose Layout Define Column.

2	Type the name of the new column in the Heading box.

3	Type an expression in the Expression box; include operators between field names to combine them as needed.

4	Choose Add.

5	Press Tab to select a column, and press the Left Arrow or Right Arrow key to insert the column to the left or right of the selected column.

With the mouse, click on the column where you want to insert the new column.

To restore a removed column

1	Choose Layout Define Column.

2	Type the name for the column in the Heading box.

3	Choose Add.

4	Select the field you want the column to contain from the Fields box.

5	Press Tab to select a column, and press the Left Arrow or Right Arrow key to insert the column to the left or right of the selected column.

With the mouse, click on the column where you want to insert the new column.

For more information on defining columns and creating calculated columns, see Chapter 3, "Formatting and Analyzing Your Data," in the Q+E for Microsoft Excel User's Guide.


Layout Define Field

Specifies the data type for values in the columns in a text file or a Microsoft Excel worksheet file.

This command is only available when you have a text file or worksheet file open in a Query window.

To assign a data type (Character, Number, or Date), first select any field in a column, then choose Layout Define Field.

When opening a character-delimited text file, first turn on the First Line Contains Column Headings option.  Then Q+E can scan the file and assign column widths and data types automatically.

When you open a fixed-format text file, Q+E displays the data in one column and assigns it the Character data type.  First use the Layout Parse Line command to parse the data so that it will be displayed in separate columns, then choose the Layout Define Field command to define the data type for each column.

Data Type

Select the proper data type for the column:  Character, Number, or Date.

Date Mask (text files only)

When specifying the Date data type, select one of the options in the Date Mask box to specify the acceptable format for entering new dates and the correct appearance for existing dates.  Masks that contain slashes indicate that a character must separate each part of a date.  The character separator can be a dash, a slash, a period, or another character.

Width

Specifies the maximum number of characters or digits to be displayed in Character or Number fields.

Decimal Digits (text files only)

Specifies the number of digits to the right of the decimal point for Number fields.


Layout Font

Changes the font, size, and style of the text in a Query window.

Fonts

Lists available screen or printer fonts.  The text box below the list of fonts can be used to type the name of the font you want.

Size

Lists available sizes for the font selected in the Font list box.  The text box below the list of sizes can be used to type the size you want.

Style

Contains check boxes that control the available font styles:  Bold, Italic, Underline, and Strikeout.  You can apply one or more of these to the text in the Query window.

Set Default

Turn on this check box if you want the current font and style selection to apply to all new windows you open.


Layout Move Column

Moves a column within a Query window.

To move a column:

1	Select a field in the column you want to move.

2	Choose Layout Move Column.

3	Using the keyboard, press Tab to select a column, and press the Left Arrow or Right Arrow key to insert the column to the left or right of the selected column.

With the mouse, click on the column located where you want to insert the column you are moving.


Layout Only Show Totals

Causes a Query window to display only the calculated totals of each column, hiding the records used to calculate the totals.

You must first use the Layout Totals command to have Q+E calculate column totals.

When this command is active, a check mark appears next to it on the menu.  When you choose the command again, the check mark is removed and the records that make up the totals are visible again.


Layout Options

Sets options that control column widths, pattern matching, and the display of the thousands separator in numeric fields.

Maximum Default Width

Controls the maximum column width in the Query window.  Fields that exceed the maximum default width will appear truncated.

Like

Specifies whether to use standard MS-DOS or standard SQL pattern-matching (wildcard) characters.

Use Thousands Separator

Specifies whether the thousands separator should be included in numeric fields of four or more characters--for example, the comma in 10,000.


Layout Parse Line

Specifies where each value in a fixed-format text file record begins and ends.

This command is only available when you open a fixed-format text file.

To parse a fixed-format text file:

1	Choose File Open and the Options button.

2	Select the Fixed-Length Values option under File Format, and choose OK.

3	Select TextFile in the Source box, type *.txt in the File Name box, and choose OK.

4	From the File List box, select the name of the text file you want to open.

5	Choose Layout Parse Line.

6	Enclose each value in the Parse Line box in a pair of square brackets ([ ]) to tell Q+E where each field in the record begins and ends.

7	Choose OK.

Guess

Choose this option if you want Q+E to attempt to parse the line.  It places square brackets in likely locations in the line.

Clear

Removes all square brackets placed in the line, so you can start over.


Layout Remove Column

Hides a column in a Query window.

This command is only available after you select the column you want to remove.

The data in the column is not deleted; it is just not displayed.

Use Layout Define Column to restore a hidden column.


Layout Totals

Controls the display of column totals or calculation results based on the fields in the Query window.

Can show minimum, maximum, count, average, and sum for numeric fields.

Can show minimum, maximum, and count values for character or date fields.

Column

Displays the name of the column currently selected in the Query window.

Minimum

Shows the lowest value in the column.

Maximum

Shows the highest value in the column.

Count

Shows a count of the total number of values in a column.

Average

Calculates the average for the column by adding the values and dividing by the total number of values (numeric fields only).

Sum

Adds the values in the column (numeric fields only).


Search Menu

Find

locates and selects a specified text string

Find Next

searches for the next occurrence of a text string

Find Previous

searches for the previous appearance of a text string

Goto

moves to a specified record number


Search Find

Locates and selects the field that contains the text string you type in the dialog box.

You must select the columns to be searched before choosing this command.

The search is not case sensitive.

Text

Specifies the letters or numbers for which you want to search.


Search Find Next

Searches for the next occurrence of the text string you entered the last time you used the Search Find command.

You must select the columns to be searched before choosing this command.

Shortcut:	F7


Search Find Previous

Searches for the previous occurrence of the text string you entered the last time you used the Search Find command.

You must select the columns to be searched before choosing this command.


Search Goto

Searches for the Record number you type in the dialog box.

Selects the first field in the record if a match is found.

Go To Record Number

Type the number of the record you want to find.

Shortcut:	F5


Select Menu

Add Condition

specifies a condition that records must satisfy to be displayed

Distinct

hides or unhides duplicate records in the Query window

Join

merges two Query windows based on a common column

Outer Join

merges Query windows based on a common column.  Records with no matches are included

Query Now

re-executes the current query statement and displays the results

Reset Conditions

redisplays all records in a database file

Show Deleted Records

shows records marked for deletion in a dBASE file, or redisplays records not marked for deletion

SQL Query

displays a window where you can edit the SQL Select statement for the current query


Select Add Condition

Use to select and display records that meet one or more conditions.

Records that do not meet the specified conditions are hidden until you choose the Select Reset Conditions command.

You must select a field in the column you want to base the selection condition on before choosing this command.

You can specify multiple selection conditions by repeatedly choosing a value in a column and choosing Select Add Condition; you link the conditions with the AND or OR option shown in the dialog box.

If you add a condition and then change your mind, you can immediately choose the Edit Undo command to remove that condition but preserve any previous conditions.

For more information about selecting records and specifying conditions, see Chapter 2, "Sorting and Selecting Records," in the Q+E for Microsoft Excel User's Guide.

Column

Displays the heading of the column on which to base the selection (the heading of the column in which you had a value selected when you chose the command).

Connection

This option appears only when you are setting more than one condition.  Choose AND or OR to show the logical relationship between conditions.

AND	Only records that meet both conditions will be displayed.

OR	All records that meet either of the previous condition(s) or the new condition, or both, will be displayed.

Operator

Specifies the type of comparison you want to make against the value in the Value box.  For example, if the Value box contains $5000, you could select records that contain fields Equal to $5000, Less Than $5000, and so on.

Two operators, Like and Not Like, can be used to make matching searches based on wildcard characters included in the value entered in the Value box.  You can use the standard MS-DOS wildcards (* and ?) or the standard SQL wildcards (% and _).  Use the Layout Options command to specify which set of wildcard characters you want to use.

Value

Specifies the value against which you want records to be compared.  By default, the value is the contents of the field you selected when you chose this command.

Case Sensitive

When turned on, this check box causes Q+E to distinguish between upper- and lowercase letters when making comparisons.

For more information about selecting records and specifying conditions, see Chapter 2, "Sorting and Selecting Records," in the Q+E for Microsoft Excel User's Guide.


Select Show Deleted Records

Displays only those records in the Query window that have been marked for deletion in a dBASE file.

A check mark appears next to the command name on the menu when this command is active.

To see the remaining records again, choose the command again to remove the check mark.

When you delete records from a dBASE file using the Edit Delete Records command, Q+E removes the records from the display and marks them for deletion.   You can use Edit Undelete Records later if you change your mind.

To permanently remove dBASE file records marked for deletion:

1	Choose File Define.

2	Choose File Save As.

3	Choose the Options button.

4	Turn on the Pack File check box.


Select Distinct

Hides duplicate records in the Query window.  If two or more rows of data are identical, Q+E will display only one of the rows.

This command is available only when using SQL Server, OS/2 Extended Edition, or Oracle.  It is dimmed if it is not supported by your database system.

A check mark appears next to the command name on the menu when this command is active; to redisplay duplicate records, choose the command again.


Select Join

Creates a new database file from two existing files.

The files to be joined must each have a column that contains the same category of data.  When matching values are found in the common column, the records that contain the matching values are extracted from each file and are combined in a new Query window.

Records that have no match are not shown.

When you use this command, you open two database files and select a value in each file in the column that the two files have in common.  The file that you first make the selection in is the source file.  The file that you make the second selection in, or the file that is active when you choose Select Join, is the destination file.

To join two database files:

1	Use File Open to open the database files you want to join.

2	In the source window, select a value in the column that contains values in common with the destination window.

3	In the destination window, select the column to match.

4	Choose Select Join.

For more information on joins, see Chapter 2, "Sorting and Selecting Records," in the Q+E for Microsoft Excel User's Guide.

Related Topic

Select Outer Join


Select Outer Join

Creates a new database file from two existing files.

The files to be joined must each have a column that contains the same category of data.  When matching values are found in the common column, the records that contain the matching values are extracted from each file and are combined in a new Query window.

All records from the destination window are included, whether they have a match in the source window or not.  Use Select Join if you want to exclude records that have no match.

For more information on joins, see Chapter 2, "Sorting and Selecting Records," in the Q+E for Microsoft Excel User's Guide.

Related Topics

Select Join


Select Query Now

Re-executes the current query and displays the results.

Use this command after making edits in the Query window so that the window contents will be resorted, reselected, or recomputed to reflect changes that have been made.

Use this command when you are accessing a shared database on a network so that you can see any recent changes that may have been made by other users.


Select Reset Conditions

Resets selection conditions, and redisplays all the records in a database file.

This command is only available after the Select Add Conditions command has been used.

Use this command to remove existing conditions before starting a new selection.


Select SQL Query

Displays the SQL SELECT statement for the current query.

The SQL Query contains at least a SELECT and a FROM clause.

Clauses are added to the query based on the menu commands you choose.

You can edit the SQL Select statement, deleting clauses or adding additional clauses or functions supported by your database system.  When you choose OK, the Select statement is re-executed and the results are displayed in the Query window.


Sort Menu

Ascending

rearranges records in ascending order based on a selected column

Descending

rearranges records in descending order based on a selected column

Reset Sort

removes column sorting and restores records to their original order


Sort Ascending

Rearranges records in ascending order by sorting on the fields in one or more columns.

If the database has previously been sorted, first select Sort Reset Sort to remove any previous sort conditions.

Choose any field in the column you want to sort the records by, and then choose this command.

You can sort on additional columns by selecting fields in different columns and choosing the command again.


Sort Descending

Rearranges records in descending order by sorting on the fields in one or more columns.

If the database has previously been sorted, first select Sort Reset Sort to remove any previous sort conditions.

Choose any field in the column you want to sort the records by, and then choose this command.

You can sort on additional columns by selecting fields in different columns and choosing the command again.


Sort Reset Sort

Resets column sorting done with the Sort Ascending or Sort Descending commands, and restores records to the order in which they are stored in the database file.

Choose this command before beginning to specify a new sort order for previously sorted records.


Window Menu

Arrange All

displays all open windows simultaneously

Show Info

displays summary information about the current Query or Define window


Window Arrange All

Arranges all the currently open Query, Define, or Info windows so that you can view them simultaneously.

To move from window to window, press Ctrl+F6 or click the mouse in the window you want to activate.  You can also choose a window from the Window menu.

To close a window, activate it and then choose File Close, or choose Close from the Window's Control menu.


Window Show Info

Displays summary information about the current query in a separate window.

Shows the current database system, joins, selection conditions, and sort order, and the current SQL SELECT statement.

The commands on the Info window's Info menu allow you to turn off and on the information display options.  By default, they are all on, and a check mark appears next to the command to indicate that it is active.  To turn off one of the options, choose the command again.

Source

Shows which the database system the current query is from, such as dBASE, SQL Server, etc.

Joins

Shows any active joins made with the Select Join or Select Outer Join commands.

Conditions

Shows any selection conditions set up with the Select Add Condition command.

SortingOrder

Shows which column heading the records are sorted by if a sort is active.

SQL

Displays the current SQL SELECT statement for the query.