Grid

Records and tables of data

Properties

 

Methods

 

Examples

Getting an array

Set KBMenu = New Grid
With KBMenu
    .Table = "aurora_folders"
    .Columns = "aurora_folders.title,aurora_folders.display_order,aurora_folders.id"
    .Live = 1
    .RelatedTable = "knowledge_base"
    .RelatedID = ""
    .ReverseRelated = 1
    .Distinct = 1
    .Where = "aurora_folders.parent_id = 0"
    .Order = "aurora_folders.display_order"
End With

KBMenuList = KBMenu.Data()

Getting a record

Set KBItem = New Grid
With KBItem
    .Table = "knowledge_base"
    .Columns = "knowledge_base.title,content,aurora_data.updated"
    .Live = 1
    .Where = "knowledge_base.id="&a
    .Record = 1
End With

set Knowledge  = KBItem.Data()