Progress
Language Reference
GET Statement
Returns one record for a previously opened query.
SYNTAX
FIRST query
Finds the first record associated with the query. The query must have been previously opened in an OPEN QUERY statement. The order of the records is determined by the options specified in the Record phrase the OPEN QUERY statement.
NEXT query
Returns the first or next record associated with the query. The query must have been previously opened in an OPEN QUERY statement. The order of the records is determined by the options specified in the OPEN QUERY statement of the Record phrase.
PREV query
Returns the preceding or last record associated with the query. The query must have been previously opened in an OPEN QUERY statement. The order of the records is determined by the options specified in the OPEN QUERY statement of the Record phrase.
LAST query
Returns the last record associated with the query. The query must have been previously opened in an OPEN QUERY statement. The order of the records is determined by the options specified in the OPEN QUERY of the Record phrase.
CURRENT query
Refetches the current record or records associated with the query. The query must have been previously opened in an OPEN QUERY statement. If the query is a join, Progress returns the current record for all tables in the join.
SHARE-LOCK
Specifies that the record is share locked. Overrides the default locking of the OPEN QUERY statement. This applies to all buffers in a join.
EXCLUSIVE-LOCK
Specifies that the record is exclusively locked. Overrides the default locking of the OPEN QUERY statement. This applies to all buffers in a join.
NO-LOCK
Specifies that no lock is applied to the record. Overrides the default locking of the OPEN QUERY statement. This applies to all buffers in a join.
NO-WAIT
Specifies that the GET statement returns immediately if the record cannot be accessed because it is locked by another user. If you do not use the NO-WAIT option, the GET statement waits until the record can be accessed. This applies to all buffers in a join. If you specify NO-WAIT and the record is locked by another user, the record is returned to you with NO-LOCK and the LOCKED function returns TRUE for the record.
EXAMPLEThis procedure uses the GET statement to find customer orders.
In the example, the GET FIRST statement fetches the first customer record and the first order record for that customer. The GET NEXT statement fetches the next order record for the customer. If no more order records are found for the current customer, then the GET NEXT statement fetches the next customer and the first order record for that customer. If a customer has no orders, the GET statement skips that customer.
NOTES
- The query must be opened with the OPEN QUERY statement before any records are fetched.
- A query that references more than one buffer defines a join. Each GET statement returns one set of records.
- If you execute a GET NEXT statement after the last record of the query has been fetched or you execute a GET PREV statement after the first record of the query has been fetched, the ERROR condition it not raised. However, you can use the AVAILABLE function to test whether a record was returned for the query fetch.
- If the query is positioned before the first record, GET NEXT acts the same as a GET FIRST; similarly, if the query is positioned beyond the last record, GET PREV acts the same as GET LAST.
- The GET LAST statement can be slow unless Progress has performed a presort or already returned the last record that satisfies the query, or you specify USE-INDEX for the query (or the query happens to only use one index).
Also, GET LAST might be slow if the query involves an outer join.
- If you do not specify a lock type, Progress uses the lock type specified in the OPEN QUERY statement. If no lock type is specified in either the GET or OPEN QUERY statement, then the default Progress locking rules apply.
- If a GET CURRENT statement fails because of a lock conflict, Progress rereads the record with a NO-LOCK status.
- When a GET statement executes, any FIND triggers defined for the tables are executed.
- FIND triggers do not execute for a GET CURRENT statement.
- To upgrade the lock on only one table in a join, use the FIND CURRENT statement.
SEE ALSO
AVAILABLE Function, CLOSE QUERY Statement, CURRENT-CHANGED Function, CURRENT-RESULT-ROW Function, DEFINE QUERY Statement, FIND Statement, FOR Statement, LOCKED Function, NUM-RESULTS Function, OPEN QUERY Statement, REPOSITION Statement
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |