Refetches the current record or records associated with the query.

Return type: LOGICAL

Applies to: Query object handle

Syntax

GET-CURRENT ( NO-LOCK | SHARE-LOCK [ , NO-WAIT ]
| EXCLUSIVE-LOCK [ , NO-WAIT ]  )
NO-LOCK
Specifies that no lock is applied to the record. This applies to all buffers in a join.
SHARE-LOCK
Specifies that the record is share locked. This applies to all buffers in a join.
EXCLUSIVE-LOCK
Specifies that the record is exclusively locked. This applies to all buffers in a join.
NO-WAIT
Specifies that the method 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 method 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.
Note: When you execute an OPEN QUERY or REPOSITION statement for a query associated with a browse widget, the browse is automatically adjusted to remain in sync with the query. However, when you execute a GET statement or method, the browse is not adjusted. You can use the GET statement, or one of the GET methods (GET-CURRENT/FIRST/LAST/NEXT/PREV) to perform background processing without affecting the browse, but you must execute a REPOSITION statement or one of the REPOSITION methods (REPOSITION-BACKWARD/FORWARD/TO-ROW/TO-ROWID) to put the query and browse back in sync.