Microsoft KB Archive/64594

Works: Multiple Queries in a Single Database Field

PSS ID Number: Q64594 Article last modified on 10-16-1998

2.00 3.00

MS-DOS

=
========================================================= 2.00 3.00 MS-DOS kbother

= SUMMARY =

In Works version 2.0 for MS-DOS, you can enter multiple queries in a single field in the Database. However, only the first query that you enter can be retrieved for re-use. In Works version 3.0 for MS-DOS, you cannot enter multiple queries.

= MORE INFORMATION =

While in the Query view of Works version 2.0, enter a query (query 1) and press ENTER. If you press CTRL+END, the query counter in the lower- left corner of the screen will increase by 1, and you can now enter a new query. This process can be intentionally, or unintentionally, repeated many times.

Pressing CTRL+HOME will toggle you back to your first query (query 1). Pressing CTRL+END will toggle you to just past the end of the list of queries that have already been entered in the field (to the position where you can enter a new query).

NOTE: There is no key combination that will allow you to toggle directly to, or scroll through, existing queries. Therefore, with the exception of query 1, existing queries cannot be re-used.

If multiple queries have been unintentionally entered in a Database field, excess queries can be deleted using one of the following methods:

  From the Edit menu, choose Delete Query, once for each excess query.   Use a looping macro to automatically repeat the Delete Query command until all of the extra queries have been deleted. For more information about using a looping macro, query on the following words in the Microsoft Knowledge Base: works and macro and query 

When all excess queries have been erased, the query counter at the lower- left corner of the screen will always display a 2 if you press CTRL+END. This is because Works always saves the first query and now assumes that you are going to enter an additional query, which would be number 2. Press CTRL+HOME to return to 1 before reentering the query.

Microsoft is researching this problem and will post new information here as it becomes available.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 2.00 3.00 =

Version : 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.