Works: 100-Character Limit In Filter/Query Comparisons (145820)

SUMMARY

When you apply a filter in a Works 4.0, 4.5, or 4.5a database, the Compare To box will not accept more than 100 characters. Similarly, when applying a query in Works 3.0, the Value to Compare Field To box will not accept more than 100 characters.

If you attempt to type more than 100 characters into these comparison boxes you will receive a warning sound indicating that you have reached the maximum number of characters for the comparison box.

MORE INFORMATION

To create a filter with more than 100 characters, use the Filter Using Formula, in Works 4.0, 4.5, or 4.5a. The Filter Using Formula dialog box has a 255 character limit.

In Works 3.0, you can perform a query with more than 100 characters by using the Query View option. You can enter a maximum of 255 characters on a field line. Additional parameters may be placed next to a different field name in Query view. In that case, only records matching all criteria in all fields in Query view will be displayed.

For example, if you have a database that contains the fields, First Name, Age, Sex, and State.

Enter the following into Query View:

   Field1:=(Sex="M"#AND#State="WA")#OR#First name="John"

   Field2:=(Age>=27)

For a record to display after the query is run, the record must meet the criteria for Field1 and the criteria for Field2. The query will find records where Sex equals M, and State equals WA, or First name equals John and Age is equal to or greater than 27.