ARRAY LOOKUP()

From Recital Documentation Wiki
Revision as of 11:53, 30 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

PURPOSE

Look up value in a Recital array


SYNONYM

api_array_lookup()


SYNOPSIS

#include "dbapi.h"
 
struct API_MEMVAR	ARRAY_LOOKUP(arrayname, element)
 
<input parameters>
char	*arrayname;	/* Address of a buffer containing the name of a Recital array	*/
int	element		/* Number of element							*/
 
<output parameters>
none


DESCRIPTION

The ARRAY_DEFINE() function returns the data type, value, display width and number of decimal places of the specified element number in the Recital array.

NOTE: Recital array elements start at 1 and not 0 as in 'C'.

A NULL value is returned if the array has not been previously been defined or the specified array element is out of range, otherwise the results are stored in the following API_MEMVAR data structure.

union	API_UNION {
    char			*info_character;		/* char memory variable			*/
    char			info_logical;		/* logical memory variable		*/
    double		info_number;		/* numeric memory variable		*/
    unsigned long	info_date;			/* date memory variable			*/
    DATETIME		info_datetime;	 	/* datetime memory variable		*/
    CURRENCY	info_currency;		/* currency memory variable		*/
};
 
struct	API_MEMVAR {
    char			type;				/* data type of memory variable	*/
    union		API_UNION value;	/* value of the memory variable	*/
    int			width;			/* display width				*/
    int			decimal;			/* display # of decimal places		*/
};

The API_MEMVAR type specifies both the data type and which API_UNION value will be used to return the value of the array element.

The API_MEMVAR width returns the length of the array element. A decimal place may be returned for a number, but will be 0 for other data types.

An array element can be defined as any one of the following.


TYPE OUTPUT WIDTH DESCRIPTION
C info_character 1 - 8192 address of a buffer containing a character string
D info_date 8 unsigned long representing a Recital Date
L info_logical 1 character of either 'T' for true or 'F' for false
N info_number 1 - 16 a value stored in a double
T info_datetime sizeof(DATETIME) RCT_DATETIME_DEF structure
Y info_currency sizeof(CURRENCY) RCT_CURRENCY_DEF structure


EXAMPLE

The following example looks up the array element and returns the result.


#include <stdio.h>
#include "dbapi.h"
 
dbapi_array_lookup()
{
    struct API_MEMVAR	result
 
    if (_parinfo(1) != API_CTYPE || _parinfo(2) !=API_NTYPE) {
       _retc("")
    }
 
    result = ARRAY_LOOKUP(_parc(1), _parni(2));
 
    switch (result->type)
    {
       case 'C':
       ''retc( result->value.info''character );
       case 'D':
       _retc(DATE_DTOS(result->value.info_date));
       case 'N':
       CHAR_STR(buffer,
       result->value.info_number,
       result->width,
       result->decimal);
       _retc(buffer);
       case 'L':
       _retc((result->value.info_logical=='T') ? "True" : "False");
       case 'T':
       _retc(DATE_TTOS(result->value.info_datetime));
       case 'Y':
       _retc(CURR_YTOS(result->value.info_currency));
    }
 
}


SEE ALSO

_parinfa(), ALENGTH(), ISARRAY(), ARRAY_ALEN(), ARRAY_DEFINE(), ARRAY_UPDATE()