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.
Properties
Name |
Type |
Read-Only |
Shared |
|---|---|---|---|
✓ |
|||
✓ |
|||
✓ |
|||
✓ |
|||
✓ |
|||
✓ |
|||
✓ |
|||
✓ |
|||
✓ |
|||
✓ |
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