Monday, November 08, 2010 at 12:01 AM.


<<Examples of syntax for the "get()" verb
	<<be sure the State Capitals database is open before running this
		<<If you do not alread have this database you can create a simple database
		<<with two fields, the first being "Name" the second "Capitol"
	<<Step through this script and use lookup to watch the value of scratchVar
	<<on get (obj, as = nil) <<Get the data for an object
with objectModel, Filemaker {
	local {
	bundle { <<getting data
		scratchVar=get(record[1]); <<gets the record as a list
		scratchVar=get(record[1].cell[1]); <<"name" cell
		scratchVar=get(record[1].cell["name"]); <<same as last line, but with name index
		scratchVar=get(field["name"])}; <<Gets this field from all records
	bundle { <<getting properties
		scratchVar=get(record[1].cell[2].name); <<capital
		scratchVar=get(record[1].uniqueID); <<The Unique ID of the record
		scratchVar=get(record[1].cell[2].uniqueID)}; <<The Unique ID of the cell (this might be FM3 specific
	bundle { <<matches, ranges, etc
		scratchVar=get(record[cell[1]=="California"]); <<matching records
		scratchVar=get(record[cell[1] contains "Cali"]); <<matching records
		scratchVar=get(record[1 to 5]); <<range of records
		scratchVar=get(record[1 to 5].cell[1]); <<cells from range of records
		scratchVar=get(record[1 to 5].uniqueID)}; <<IDs from range of records
	bundle { <<getting data as a certain type
		<<Other types might be:
			<<longType (number)
			<<binaryType (images etc
	scratchVar=0} <<a step so that the last change to scratchVar can be seen in the lookup

This listing is for code that runs in the OPML Editor environment. I created these listings because I wanted the search engines to index it, so that when I want to look up something in my codebase I don't have to use the much slower search functionality in my object database. Dave Winer.