Search Form Data
|
|
---|
Key
| Value
|
---|
ColSelected.columnname
| "on" or "off"
|
ColOperator.columnname
| search operator
(=, <, >, <=, >=, is null, is not null)
|
ColValue.columnname
| search value for text, integer, real, or boolean fields
|
ColValue.columnname.NULL
| "t" or "f" (true or false), indicates whether to search for the specified date, time, or timestamp field
|
ColValue.columnname.month
| month portion of search value for date and timestamp fields
|
ColValue.columnname.day
| day portion of search value for date and timestamp fields
|
ColValue.columnname.year
| year portion of search value for date and timestamp fields
|
ColValue.columnname.time
| time portion of search value for time and timestamp fields
|
ColValue.columnname.ampm
| "AM" or "PM" designation of search value for time and timestamp fields
|
OrderBy.n
| name of column to order the results by (where n is 0 for the first order by column, 1 for the second order by column, and so on)
|
Queryinfo.Distinct
| "on" or "off", indicates whether query should eliminate duplicate records
|
Pref.MaxToReturn
| integer, maximum number of records to return
|
Entry Form Data
|
|
---|
Key
| Value
|
---|
ColValue.columnname
| value for text, integer, real, or boolean fields
|
ColValue.columnname.NULL
| "t" or "f" (true or false), indicates whether a date, time, or timestamp field is null or the value specified in the date/time portions
|
ColValue.columnname.month
| month portion of value for date and timestamp fields
|
ColValue.columnname.day
| day portion of value for date and timestamp fields
|
ColValue.columnname.year
| year portion of value for date and timestamp fields
|
ColValue.columnname.time
| time portion of value for time and timestamp fields
|
ColValue.columnname.ampm
| "AM" or "PM" designation of value for time and timestamp fields
|
Update/Delete Form Data
|
|
---|
Key
| Value
|
---|
ColValue.columnname
| value for text, integer, real, or boolean fields
|
ColValue.columnname.NULL
| "t" or "f" (true or false), indicates whether a date, time, or timestamp field is null or the value specified in the date/time portions
|
ColValue.columnname.month
| month portion of value for date and timestamp fields
|
ColValue.columnname.day
| day portion of value for date and timestamp fields
|
ColValue.columnname.year
| year portion of value for date and timestamp fields
|
ColValue.columnname.time
| time portion of value for time and timestamp fields
|
ColValue.columnname.ampm
| "AM" or "PM" designation of value for time and timestamp fields
|
RowID.columnname
| all the RowID values that specify the row to update or delete
|