Tasks

Properties

•   query

  Executed query

  property
•   columnNameToIndexMap

  NSMutableDictionary mapping column names to numeric index

  property
•   statement

  FMStatement used by result set.

  property

Creating and closing database

• + resultSetWithStatement:usingParentDatabase:

  Create result set from FMStatement

• – close

  Close result set

Iterating through the result set

• – next

  Retrieve next row for result set.

• – hasAnotherRow

  Did the last call to next succeed in retrieving another row?

Retrieving information from result set

• – columnCount

  How many columns in result set

• – columnIndexForName:

  Column index for column name

• – columnNameForIndex:

  Column name for column index

• – intForColumn:

  Result set integer value for column.

• – intForColumnIndex:

  Result set integer value for column.

• – longForColumn:

  Result set long value for column.

• – longForColumnIndex:

  Result set long value for column.

• – longLongIntForColumn:

  Result set long long int value for column.

• – longLongIntForColumnIndex:

  Result set long long int value for column.

• – unsignedLongLongIntForColumn:

  Result set unsigned long long int value for column.

• – unsignedLongLongIntForColumnIndex:

  Result set unsigned long long int value for column.

• – boolForColumn:

  Result set BOOL value for column.

• – boolForColumnIndex:

  Result set BOOL value for column.

• – doubleForColumn:

  Result set double value for column.

• – doubleForColumnIndex:

  Result set double value for column.

• – stringForColumn:

  Result set NSString value for column.

• – stringForColumnIndex:

  Result set NSString value for column.

• – dateForColumn:

  Result set NSDate value for column.

• – dateForColumnIndex:

  Result set NSDate value for column.

• – dataForColumn:

  Result set NSData value for column.

• – dataForColumnIndex:

  Result set NSData value for column.

• – UTF8StringForColumnName:

  Result set (const unsigned char *) value for column.

• – UTF8StringForColumnIndex:

  Result set (const unsigned char *) value for column.

• – objectForColumnName:

  Result set object for column.

• – objectForColumnIndex:

  Result set object for column.

• – objectForKeyedSubscript:

  Result set object for column.

• – objectAtIndexedSubscript:

  Result set object for column.

• – dataNoCopyForColumn:

  Result set NSData value for column.

• – dataNoCopyForColumnIndex:

  Result set NSData value for column.

• – columnIndexIsNull:

  Is the column NULL?

• – columnIsNull:

  Is the column NULL?

• – resultDictionary

  Returns a dictionary of the row results mapped to case sensitive keys of the column names.

• – resultDict

  Returns a dictionary of the row results

Key value coding magic

• – kvcMagic:

  Performs setValue to yield support for key value observing.