Read URL Records

UFNDBEG and UFNDNXT routines are used to read URL records.

The UFNDBEG API is used to define search parameters for a set of URL records associated with the current base file record, open the result set and retrieve the first record of the set.

The D<Prefix>@U@URLORD field controls both the order in which URLs are returned and the keys used to search for the URLs.

URLORD = 0 is the default and orders the URLs by NAME and sequence number (SET5). If the NAME field is not blank, only URLs with matching NAME values will be returned.

URLORD = 1 orders the URLs by CREATE-DATE, CREATE-TIME and sequence number (SET6). If the Ath->CrtDate and Ath->CrtTime fields (internal C fields that 4GL programs do not directly control) are not blank, only URLs that match both will be returned. If Ath->CrtDate is not blank and Ath->CrtTime is blank, then only URLs that match that date are returned.

URLORD = 2 orders the URLs by MODIFY-DATE, MODIFY-TIME and sequence number (SET7). If the Ath->ModDate and Ath->ModTime fields (internal C fields that 4GL programs do not directly control) are not blank, only URLs that match both will be returned. If Ath->ModDate is not blank and Ath->ModTime is blank, then only URLs that match that date are returned.

URLORD = 3 orders the URLs by sequence number (SET3).

The D<Prefix>@U@TYPE field can be used to search for specific types of URLs. If D<Prefix>@U@TYPE = ' ' (space), then all URLs are retrieved. If the field is set to a different value, then only URLs of that type are returned.

The UFNDNXT API is used to retrieve subsequent records from the result set. The value of the D<Prefix>@U@TYPE field must be set to the appropriate value before each call to UFNDNXT.

The name stored with the URL is that of the user who created the URL attachment.