Inventory Items Records

This page describes the inventory items records and documents usage.

Inventory Items Records Layout

Field 1	Field 2	Field 3
Item Number	Item Description	Item Stock Amount

Using the Inventory Items Records

• The records are made available to your programs with this function:

openInventoryItemsRecords();

• The function returns the records so you need to store them in a variable:

let itemRecords;
itemRecords = openInventoryItemsRecords();

* After the openInventoryItemsRecords() function has been run you have access to the first record's data. You will retrieve each part of one record with a different function. Here are the functions:

itemRecords.getItemNumber();
itemRecords.getItemDescription();
itemRecords.getItemStockAmount();

• Notice that you need to have "itemRecords." in front of each of the functions.

• When you want to read the next record you use the following function. It will make the next record available and you then use the above functions to retrieve the data. This function returns true if there was a next record and false if the end of the record set has been reached.

itemRecords.readNextRecord();

---

Example Usage

Here's an example of how the Inventory Items Records are used.

/*
  This is the JavaScript code for "Inventory Items Records"
  File: /unit04/inventoryItemsRecords.html
*/
function inventoryItemsRecords() {
    "use strict";

    let currentNumber;
    let currentDescription;
    let currentStockAmount;
    let itemRecords;

    // Open the Inventory Items Records and make them
    // available to the script
    itemRecords = openInventoryItemsRecords();

    // Read the next record, test to see if there
    // is a next record and then output it
    while (itemRecords.readNextRecord()) {
        currentNumber = itemRecords.getItemNumber();
        currentDescription = itemRecords.getItemDescription();
        currentStockAmount = itemRecords.getItemStockAmount();

        document.write(currentNumber + "\t" + currentDescription
                + "\t" + currentStockAmount + "<br />");
    }
}

---

Inventory Items Records Data