Using QMF

USER -- Present rows with a value equal to a user identification

When you run a query with USER in the NAME column (or in any column containing user identification (user ID) numbers), your own user ID is substituted for the word USER as a condition in the query. You can then share the query with other users, who can run it without change. QMF automatically substitutes their user IDs for the USER keyword. (USER is not preceded by &.)

Suppose, for example, that you usually run a query once a month (using the Q.STAFF table) to find out what your commission is to the current day. You discover that your friends also want to check the same information. You can write the following query and share it with them.



Q.STAFF | NAME | COMM |
--------+------+------|
        | USER | P.   |


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]