Note: 
1) rename file to .inc
2) alter two lines at top and bottom of AO-JD files, see AO-JD code for instructions.

Database names can be alphanumeric and include underscores.

var DB = new Database('DB')
var myDB = new Database('myDB')
var menus = new Database('menus')

Database and recordset names can be alphanumeric and include underscores.

var DB = new Database('DB')
DB.CreateRecordset('MENU_PRICES')
DB.CreateRecordset('MENUS')
DB.CreateRecordset('ORDERS')

with (DB) {
CreateRecordset('MENU_PRICES')
CreateRecordset('MENUS')
CreateRecordset('ORDERS')
}

DB.ResetRecordset('MENUS')
DB.ResetRecordset(1)

Both these methods do exactly the same thing. A([]) was introduced to reduce the size of record files.

DB.MENUS.A(['Apples',3])
DB.MENUS.AddRec(['Apples',3])
DB.Recordsets('MENUS').A(['Apples',3]) //using Recordsets collection function

with (DB.MENUS) {
A(['Apples',3])
A(['Oranges and lemons',2.4])
}

DB.MENUS.Count() //counts all records in recordset

query = "PRICE != 2" //see query definition
DB.MENUS.Count(query) //counts all records that satisfy query

Database, recordset and field names can be alphanumeric and include underscores.

DB.MENUS.CreateField('MENU_TITLE')
DB.MENUS.CreateField('PRICE')

with (DB.MENUS) {
CreateField('MENU_TITLE')
CreateField('PRICE')
}

If you intend to use the Seek method then you need to specify the field as a primary key field:

DB.MENUS.CreateField('MENU_ID',dbPrimaryKey) //dbPrimaryKey is a database global variable

Note: See dbPrimaryKey Definitions

The property RecordsArray of the property container RsetProperties is an array that holds record array indexes of every record that satisfies the query. Also, if pagesize is specified, PagesArray is created that holds every pagesize record array index that satisfies the query, relative to the first record found. You can use the Get method in conjunction with PagesArray and RecordsArray to set current records - see 4.10

Note: PagesArray can be useful for creating record navigations systems as shown in the Vietnam example.

DB.MENUS.MoveFirst() //moves to first record and sets as current record
DB.MENUS.DeleteRec() //deletes the current record in MENUS recordset

Note: after deleting the current record no record is current so you must set another record as current

var s = DB.MENUS.DumpRecordset(['MENU_TITLE','PRICE'],fieldDelimiter,recordDelimiter)
//DumpRecordset returns a string of the dumped recordset

var query = 'MENU_TITLE == ' + sTitleName

DB.MENUS.FindFirst(query) //if record found NoMatch=false else NoMatch=true
while (!DB.MENUS.RsetProperties.NoMatch) {
   //do whatever
  alert(DB.MENUS.MENU_TITLE) //same as:   alert(DB.MENUS.MENU_TITLE.FieldProperties.Value)
   DB.MENUS.FindNext(query) //starts from next record after the current record
}

Note: with the Find Methods use the NoMatch property to test whether record has been found

var query = 'MENU_TITLE == ' + sTitleName

DB.MENUS.FindLast(query) //if record found NoMatch=false else NoMatch=true
while (!DB.MENUS.RsetProperties.NoMatch) {
   //do whatever
   alert(DB.MENUS.MENU_TITLE) //same as:   alert(DB.MENUS.MENU_TITLE.FieldProperties.Value)
   DB.MENUS.FindPrevious(query) //starts from previous record before the current record
}

Note: with the Find Methods use the NoMatch property to test whether record has been found

Note: generally used with FindFirst(query), see 4.6 for example

Note: generally used with FindLast(query), see 4.7 for example

var query = 'MENU_TITLE == ' + sTitleName
var pageSize = 10 //optional

database.recordset.CreateQueryArrays(query,pageSize) //sets both RecordsArray & PagesArray
for (var i=0;i<database.recordset.RsetProperties.RecordsArray.length;i++.) {
   database.recordset.Get(database.recordset.RsetProperties.RecordsArray[i]) //set current record
   //do whatever
}

var pRset = database.recordset  //pointer
var pPA = pRP.RsetProperties.PagesArray //pointer
var iPageArrayLength = pPA.length

for (var i=0;i<iPageArrayLength;i++) {
   pRset.Get(pPA[i]) //set current record
   //do whatever
}

The two ways to find array indexes of records:
1) database.recordset.RsetProperties.CurrentRecord holds the array index value of the current record.
2) database.recordset.CreateQueryArrays(query{,pageSize}), see 4.11

Note: Vietnam example has a good example of using Seek method and Get method in getHTML_Display_Records() function.

database.recordset.MoveFirst()
while (!database.recordset.RsetProperties.Eof) {
   //do whatever
   alert(database.recordset.field) //same as:   alert(database.recordset.field.FieldProperties.Value)
   database.recordset.MoveNext()
}

database.recordset.MoveLast()
while (!database.recordset.RsetProperties.Bof) {
   //do whatever
   alert(database.recordset.field) //same: alert(database.recordset.field.FieldProperties.Value)
   database.recordset.MovePrevious()
}

To use this method you must have one or more fields in the recordset created as dbPrimaryKey, see CreateField method.

DB.ITEMS.Seek(menu_id) //ITEMS has one primary key

Or,

DB.ORDERS.Seek(user_id,item_id) //ORDERS has two primary keys

If recordset2 has a foreign key in recordset1: 

DB.rset1.MoveFirst()
while (!DB.rset1.RsetProperties.Eof) {
   prKeyRset2 = DB.rset1.FK_RSET2_ID
   DB.rset2.Seek(prKeyRset2) //sets current record for rset2
   //do whatever
  DB.rset1.MoveNext()
}

Note:
See dbPrimaryKey Definitions

See Control Panel example for more information: view 'properties display' and select 'IndexedField' value from RsetProperties. Also Vietnam example has a good example of using Seek method and Get method in getHTML_Display_Records() function.

DB.recordset.Sort('fieldname1','ascend')
DB.recordset.Sort('fieldname1','descend')
DB.recordset.Sort('fieldname3,fieldname6,fieldname1','ascend,descend,ascend')

DB.recordset.UpdateField('MENUS','Food is good')
DB.BASKET.UpdateField('QUANTITY',newQuantity)

Note: if you wished you could add your own properties to these objects in AO-JD code, very simple, just follow what is already there.

//both these return the MENUS recordset.
DB.Recordsets('MENUS')  //by recordsetname
DB.Recordsets(2)  //by ordinal - MENUS was the third recordset created in the database

//the following are the same
name = DB.Recordsets('MENUS').RsetProperties.Name
name = DB.Recordsets(2).RsetProperties.Name
name = DB.MENUS.RsetProperties.Name

var pMRP = DB.MENUS.RsetProperties
name = pMRP.Name //in a loop this is fastest

DB.recordset.Fields('MENU_ID')  //by fieldname
DB.recordset.Fields(0)  //by ordinal - MENUS was the first field created in the database

//the following are the same
name = DB.Recordsets('MENUS').MENU_ID.FieldProperties.Name
name = DB.Recordsets(2).Fields(0).FieldProperties.Name
name = DB.MENUS.MENU_ID.FieldProperties.Name

alert(database.Recordsets.Count)

alert(database.recordset.Fields.Count)

• Addition of recordset CreateQueryArrays(query{,pagesize}) method for generating RecordsArray and PagesArray - used by Get method
  
• Addition of recordset Get(id) method for setting a record as current
  
• Separation of cookie code and main database into two separate files, giving you the option of including cookie code if required.
  
• General code changes  to improve performance, notable being AddRec/A method to improve record load speed