Synopsis:

       adoFldGetValue(handle,ix/name,&pValue)

Arguments:

       handle        - The recordset handle.

         ix/name        - The field index number or field name

       pValue        - Pointer to the variable that will hold the returned field value

Description:   This function returns the value of the field specified by the field index number (ix) or the field name for the current record in the recordset specifed by handle.      The function will detect automatically whether a field index number or field name has been specified.        The value of the uinderlying field will be returned to the variable pointed to by the pValue argument.

Below is an example showing this function in use.   This example assumes that the underlying recordset has fields called 'date','time','telno','duration','rate' and 'cost':

    rec_count=adoRsetRecCount(SetHandle);

   

    for(i=0;i<rec_count;i++)

        x=adoRSetMove(SetHandle,-i,adBookmarkLast);

        if(adoRSetIsBOF(SetHandle))

            break;

        endif

        adoFldGetValue(SetHandle,"date",&date);

        adoFldGetValue(SetHandle,"time",&time);

        adoFldGetValue(SetHandle,"telno",&telno);

        adoFldGetValue(SetHandle,"duration",&duration);

        adoFldGetValue(SetHandle,"rate",&rate);

        adoFldGetValue(SetHandle,"cost",&cost);

        applog("Rec ",rec_count-i,": date=",date," time=",time," telno=",strrtrim(telno)," dur=",duration," rate=",rate," cost=",cost);

    endfor

Returns:   Returns 0 upon success or a negative error code.   If ADOERR_COMERR is returned, then the underlying ADO error can be obtained by calling adoLastError()