` | `Auto` | ✓ | | ## Property descriptions

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

forsearch

iOSSQLiteDatabaseField.BooleanValue **BooleanValue** As `Boolean` Gets the boolean value for a column. This property is read-only. Check the Boolean value of a column: ``` xojo ' rs is an iOSSQLiteRecordSet with a Boolean column called "AllowEmails" If rs.Field("AllowEmails").BooleanValue Then MessageLabel.Text = "Emails are allowed." End If ```

forsearch

iOSSQLiteDatabaseField.CurrencyValue **CurrencyValue** As `Currency` Gets the currency value for a column. This property is read-only. Get the Currency value of a column: ``` xojo ' rs is an iOSSQLiteRecordSet with a currency column called "Amount" Var amount As Currency amount = rs.Field("Amount").CurrencyValue ```

forsearch

iOSSQLiteDatabaseField.DateValue **DateValue** As `Date` Gets the date value for a column. This property is read-only. Get the Date value of a column: ``` xojo ' rs is an iOSSQLiteRecordSet with a date column called "InvoiceDate" Var invoiceDate As Date invoiceDate = rs.Field("InvoiceDate").DateValue ```

forsearch

iOSSQLiteDatabaseField.DoubleValue **DoubleValue** As `Double` Gets the double value for a column. This property is read-only. Get the Double value of a column: ``` xojo ' rs is an iOSSQLiteRecordSet with a double column called "InterestRate" Var interestRate As Double interestRate = rs.Field("InterestRate").DoubleValue ```

forsearch

iOSSQLiteDatabaseField.Int64Value **Int64Value** As `Int64` Gets the Int64 value for a column. This property is read-only. Get the Int64 value of a column: ``` xojo ' rs is an iOSSQLiteRecordSet with an Int64 column called "ID" Var id As Int64 id = rs.Field("ID").Int64Value ```

forsearch

iOSSQLiteDatabaseField.IntegerValue **IntegerValue** As `Integer` Gets the Integer value for a column. This property is read-only. Get the Integer value of a column: ``` xojo ' rs is an iOSSQLiteRecordSet with an Integer column called "Quantity" Var quantity As Integer quantity = rs.Field("Quantity").IntegerValue ```

forsearch

iOSSQLiteDatabaseField.Name **Name** As `Text` Gets the name of the column. This property is read-only.

forsearch

iOSSQLiteDatabaseField.NativeValue **NativeValue** As `MemoryBlock` Gets the native value for a column. Useful for reading BLOB columns. This property is read-only. Get BLOB data for a column: ``` xojo ' rs is an iOSSQLiteRecordSet with a BLOB column called "FileData" Var data As Xojo.Core.MemoryBlock data = rs.Field("FileData").NativeValue ```

forsearch

iOSSQLiteDatabaseField.TextValue **TextValue** As `Text` Gets the text value for a column. This property is read-only. Get the Text value for a a column: ``` xojo ' rs is an iOSSQLiteRecordSet with a Text column called "ProductName" Var productName As Text productName = rs.Field("ProductName").TextValue ```

forsearch

iOSSQLiteDatabaseField.Value **Value** As `Auto` Gets the value for a column. This property is read-only. You can use this instead of the more type-specific methods for more generic reading of column values. Get the Text value for a a column: ``` xojo ' rs is an iOSSQLiteRecordSet with a Text column called "ProductName" Var productName As Auto productName = rs.Field("ProductName").Value ``` ## Notes You cannot modify the data in iOSSQLiteDatabaseField. If you need to modify the data in your SQLite database you'll need to use SQL with `iOSSQLiteDatabase.SQLExecute`. ## Compatibility iOS projects on the iOS operating system. ## See also `Object` parent class; `SQLiteDatabase`, `DatabaseException`, `RowSet` classes