Edit Row

Synopsis

EDITPL/{kv1,kv2,kv3|obj id}[,num list,string list][,QTY[{,INT|,STR}],quantity][,IFERR,label:]

Description

Allows you to edit a row in the parts list. You can specify which row you want to edit by specifying three key field values which uniquely define the row or by specifying the desired object.

To modify a key or normal field, specify the column number of the field to be changed in the num list and the new field value in the corresponding position in the string list.

The minor word QTY allows you to modify the quantity type and value. The minor words INT and STR specify that the quantity value is to be either an integer or string, respectively. If neither is specified, the quantity value defaults to a real number.

Parameters

Parameter

Description

kv1,kv2,kv3

Three key field values used to define a row of the parts list. These three values must be unique to the desired row. Key field values must be listed in order as they appear in the parts list. If you enter the key field values directly as strings, each must be enclosed in single quotes (''). You must include all three key field values. If the parts list format contains only two key fields, the third key field value must be specified as a blank For example, if only the key field values PART NO. and NAME exist, you would specify the following: 'PART NO','NAME',' ',

num list

A list or array of field (column) numbers which correspond to a list of field values in the string list. The list may contain a maximum of 14 column numbers.

string list

A list or array containing the field values for the field numbers specified in the corresponding num list. Field values may be a maximum of 80 characters in length. If each value is entered directly as a string, it must be must enclosed by single quotes ('').

QTY

Minor word which allows you to modify the quantity type and value of the parts list.

INT

Minor word which indicates that the quantity value must be an integer.

STR

Minor word indicating that the quantity value must be a string.

quantity

Quantity value whose type corresponds to the preceding minor word (INT or STR). If no minor word is specified, the value must be a real number.

obj

An object variable which represents the existing object whose parts list fields are to be edited. Only one object may be specified at a time.

IFERR,label:

A label that program execution jumps to if an error occurs.

Parameter	Description
kv1,kv2,kv3	Three key field values used to define a row of the parts list. These three values must be unique to the desired row. Key field values must be listed in order as they appear in the parts list. If you enter the key field values directly as strings, each must be enclosed in single quotes (''). You must include all three key field values. If the parts list format contains only two key fields, the third key field value must be specified as a blank For example, if only the key field values PART NO. and NAME exist, you would specify the following: 'PART NO','NAME',' ',
num list	A list or array of field (column) numbers which correspond to a list of field values in the string list. The list may contain a maximum of 14 column numbers.
string list	A list or array containing the field values for the field numbers specified in the corresponding num list. Field values may be a maximum of 80 characters in length. If each value is entered directly as a string, it must be must enclosed by single quotes ('').
QTY	Minor word which allows you to modify the quantity type and value of the parts list.
INT	Minor word which indicates that the quantity value must be an integer.
STR	Minor word indicating that the quantity value must be a string.
quantity	Quantity value whose type corresponds to the preceding minor word (INT or STR). If no minor word is specified, the value must be a real number.
obj	An object variable which represents the existing object whose parts list fields are to be edited. Only one object may be specified at a time.
IFERR,label:	A label that program execution jumps to if an error occurs.