SYNOPSIS

int MGOselsponsor (Validation **lst, Validation *val)

DESCRIPTION

The MGOselsponsor() function selects sponsor records. Information is passed through val and returned through the linked list lst. The selection criteria fields are:

• val.validid
• val.sponsid
• val.source_code

val.validid is the validation id. val.sponsid is the sponsor's validation id. val.source_code is the sponsor validation source reference code. You can specify either a validation id, or a sponsor id and source code or both. The following fields are set for each selected sponsor:

• lst.next
• lst.validid
• lst.sponsid
• lst.source_name
• lst.source_code
• lst.status_name
• lst.status_code

RETURN VALUE

Returns the number of records inserted upon success or -1 if an error occurred (in which case MGOerrno and MGOerrmsg are set appropriately).

ERRORS

• MGO_E_MAR - One or more of the required arguments were missing
• MGO_E_IAR - Invalid or ambiguous argument
• MGO_E_PMD - Permission denied. See access control
• MGO_E_MAT - No matches found
• MGO_E_VAL - No such validation source reference code
• MGO_E_SQL - An SQL error occurred. See MGOerrmsg for details

AUTHENTICATION LEVEL

rmango

SEE ALSO

MGOdelsponsor(), MGOfreevalidation(), MGOinssponsor(), MGOselrvalsource(), MGOupdsponsor(), MGOzero()