Define Range Table dialog box

Use this dialog box to create, rename, or delete range tables.

A range table specifies a range of actions to take depending on the actual value of object data or properties associated with drawing objects.

• For property alteration, specify different alterations for a property depending on the value of the property. For example, you could specify that all buildings under two stories be colored blue, all buildings two stories to ten stories be colored green, and all buildings above ten stories be colored red.
• For an output report, specify different actions to take depending on the value of the data. For example, you could specify that if a lot is valued at less than $10,000, report the value in the Land Value A column of your database; if the lot is valued at over $10,000, report the value in the Land Value B column.

Create range tables and save them with the current drawing to use again.

Range Table area

Select an existing table, rename a table, create a new table, or delete a table.

Range Table list

View all tables in the current drawing.

To view tables, click the down arrow. Select a table.

Rename

Display the Rename Range Table dialog box, where you can specify a new name for the current range table.

New

Display the New Range Table dialog box, where you can save the current table definitions to a new range table.

Remove

Remove the current range table.

Do not delete a range table used by your queries.

Current Range Table Definition area

Use this area to view, edit, or delete rows in the range table.

Current Range Table Definition list

View all rows in the current range table.

To edit or delete a row, select the row and click Edit or Delete.

Edit

Copy the selected row to the Condition section of the dialog box, where you can modify it.

When you finish modifying the condition, click Add To List to update the row in the Current Range Table Definition list.

Delete

Delete the selected row.

Clear List

Delete all rows from the current range table.

Expressions in the Current Range Table Definition list are evaluated from top to bottom, that is, in the order you enter them. As soon as one condition is evaluated as TRUE, AutoCAD Map 3D stops evaluating, ignores the remaining expressions, and returns the value associated with the TRUE condition in the range table.

For example, assume you enter the following expressions:

If < 0 Return: Low

If < 15 Return: Medium

If < 30 Return: High

If < 45 Return: Very High

With a value of 20, the first condition evaluates to FALSE because 20 is not less than 0. The second condition also evaluates to FALSE since 20 is not less than 15. However, the third condition evaluates to TRUE since 20 is less than 30, and the value returned by the range table is High. The last condition, although TRUE, is ignored.

Condition area

Edit an existing row, or create a new one.

• To edit an existing row, select the row in the Current Range Table Definition list and click Edit. When you finish, click Update.
• To create a new condition, select an operator, specify an expression and a return value, and click Add.

Operator list

Select an operator from the list.

Operator	Description
=	The value of the selected property or data is equal to the value you enter the Value box.
>	The value of the selected property or data is greater than the value you enter the Value box.
>=	The value of the selected property or data is greater than or equal to the value you enter the Value box.
<	The value of the selected property or data is less than the value you enter the Value box.
<=	The value of the selected property or data is less than or equal to the value you enter the Value box.
/=	The value of the selected property or data is not equal to the value you enter the Value box.
OTHERWISE	Specify the action to take none of the preceding conditions are met.If you include an OTHERWISE condition, it must be at the end of the list.

Expression Value box

Enter a simple expression.

If an object matches the value of this expression, the object is affected by the return value.

Return Value box

Specify a return value for this condition.

The return value specifies what happens if the object matches the expression.

Enter a value or a simple expression. Do not enter a compound expression.

Add

Add the current condition to the Current Range Table Definition list.

Update

Update the selected condition in the Current Range Table Definition list with the current condition.

Parent topic: Query Dialog Boxes

Related Tasks

• To Create a Range Table