Table object properties are defined in the button script assigned to the table objects behavior property of the Database object. You define a property for a Table object by creating a function with the following naming convention:

tableobj.get.[TABLE_NAME].[PROPERTY_NAME_WITHOUT_SPACES]

The function will be passed a SQL Record object array as the 1st parameter.

For example, to create add a name property to a people table you would add the following function to the behavior script:

function tableobj.get.people.name pRecordA
  return pRecordA["firstname"] && pRecordA["lastname"]
end tableobj.get.people.name 

You can access a Table object property when you are working with SQL Record objects by calling the sqlrecord_get function.

The following example retrieves a person from the database and then accesses the name property of the resulting SQL Record object. When accessing the property the tableobj.get.people.name function is called.

sqlrecord_find "people", 12, thePersonA
put sqlrecord_get(thePersonA, "name") into theFullName

You can define properties that have spaces. Before calling the tableobj.get function all spaces are removed from the property name.

For example, if you tried to access the property short bio property like this:

put sqlrecord_get(thePersonA, "short bio") into theBio

then the following function would need to be defined in the behavior script:

function tableobj.get.people.shortbio pRecordA
  ...
end tableobj.get.people.shortbio