ARRAY UPDATE()

From Recital Documentation Wiki
Revision as of 12:09, 30 March 2009 by Barrymavin (Talk | contribs)

Jump to: navigation, search

PURPOSE

Update the value in a Recital array


SYNONYM

api_array_update()


SYNOPSIS

#include "dbapi.h"
 
int	ARRAY_UPDATE(arrayname, element, type, width, decimal, string, number, logical, date, datetime, currency)
 
<input parameters>
char			*arrayname;	/* Address of a buffer containing the name of a Recital array	*/
int                           element;		/* Element number							*/
char			type;		/* Type of field								*/
int			        width;		/* Display width								*/
int			        decimal;		/* Display # decimals							*/
char			string;		/* Address of a buffer containing a character string		*/
double			*number;	/* Number									*/
char			logical;		/* Logical									*/
unsigned long	date;		/* Recital date								*/
DATETIME		datetime;	/* Recital datetime							*/
CURRENCY		currency;	/* Recital currency								*/
 
<output parameters>
none

DESCRIPTION

The ARRAY_UPDATE() function will update the specified element in the Recital array. The name and element number are used to specify the array element to update

Recital will only recognize the first ten characters on a array name as being unique. The array names are not case sensitive and must have been previously defined before updating, or the ARRAY_UPDATE() function will return a value of -1.

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

Array elements can be updated with data of a different type to their current value. The variable type parameter specifies both the data type and which input parameter value will be used to update the memory variable.

The width parameter is used to specify length of the array element. A decimal place can be specified for a number, but should 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 will define a six element array and update each array element with the specified values.

#include "dbapi.h"
 
dbapi_array_update()
{
    int			rc;
    double		numeric;
    char			string[8];
    char			logical;
    unsigned long	date;
    DATETIME		datetime;
    CURRENCY		currency;
 
    strcpy (string, "Recital");
    date = DATE_CTOD(DATE_DATE());
    logical = 'T';
    numeric = 23.5;
    memcpy(&datetime, DATE_STOT(DATE_DATETIME()), sizeof(DATETIME));
    memcpy(&currency, CURR_STOY("364.984"), sizeof(CURRENCY));
 
    COMMAND("release all");
    ARRAY_DEFINE("memvar", API_PUBLIC, 6,1);
 
    rc = ARRAY_UPDATE("memvar",1, 'C',7,0,
       string, numeric,
       logical, date, 
       datetime, currency);
    rc = ARRAY_UPDATE("memvar",2, 'N',10,2,
       string, numeric,
       logical, date, 
       datetime, currency);
    rc = ARRAY_UPDATE("memvar",3, 'L',1,0,
       string, numeric,
       logical, date, 
       datetime, currency);
    rc = ARRAY_UPDATE("memvar",4, 'D',8,0,
       string, numeric,
       logical, date, 
       datetime, currency);
    rc = ARRAY_UPDATE("memvar",5,'T',sizeof(DATETIME),0,
       string, numeric,
       logical, date, 
       datetime, currency);
    rc = ARRAY_UPDATE("memvar",6, 'Y',sizeof(CURRENCY),4,
       string, numeric,
       logical, date, 
       datetime, currency);
 
    _retl( (rc ==0) ? 1 : 0 );
}


SEE ALSO

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