Class

iOSSQLiteDatabaseField


Warning

This item was deprecated in version 2020r2. Please use RowSet.Column as a replacement.

Description

Used to access the values of fields in a row of an iOSSQLiteDatabase table.

Property descriptions


iOSSQLiteDatabaseField.BooleanValue

BooleanValue As Boolean

Gets the boolean value for a column.

This property is read-only.

Check the Boolean value of a column:

' rs is an iOSSQLiteRecordSet with a Boolean column called "AllowEmails"
If rs.Field("AllowEmails").BooleanValue Then
  MessageLabel.Text = "Emails are allowed."
End If

iOSSQLiteDatabaseField.CurrencyValue

CurrencyValue As Currency

Gets the currency value for a column.

This property is read-only.

Get the Currency value of a column:

' rs is an iOSSQLiteRecordSet with a currency column called "Amount"
Var amount As Currency
amount = rs.Field("Amount").CurrencyValue

iOSSQLiteDatabaseField.DateValue

DateValue As Date

Gets the date value for a column.

This property is read-only.

Get the Date value of a column:

' rs is an iOSSQLiteRecordSet with a date column called "InvoiceDate"
Var invoiceDate As Date
invoiceDate = rs.Field("InvoiceDate").DateValue

iOSSQLiteDatabaseField.DoubleValue

DoubleValue As Double

Gets the double value for a column.

This property is read-only.

Get the Double value of a column:

' rs is an iOSSQLiteRecordSet with a double column called "InterestRate"
Var interestRate As Double
interestRate = rs.Field("InterestRate").DoubleValue

iOSSQLiteDatabaseField.Int64Value

Int64Value As Int64

Gets the Int64 value for a column.

This property is read-only.

Get the Int64 value of a column:

' rs is an iOSSQLiteRecordSet with an Int64 column called "ID"
Var id As Int64
id = rs.Field("ID").Int64Value

iOSSQLiteDatabaseField.IntegerValue

IntegerValue As Integer

Gets the Integer value for a column.

This property is read-only.

Get the Integer value of a column:

' rs is an iOSSQLiteRecordSet with an Integer column called "Quantity"
Var quantity As Integer
quantity = rs.Field("Quantity").IntegerValue

iOSSQLiteDatabaseField.Name

Name As Text

Gets the name of the column.

This property is read-only.


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:

' rs is an iOSSQLiteRecordSet with a BLOB column called "FileData"
Var data As Xojo.Core.MemoryBlock
data = rs.Field("FileData").NativeValue

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:

' rs is an iOSSQLiteRecordSet with a Text column called "ProductName"
Var productName As Text
productName = rs.Field("ProductName").TextValue

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:

' 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