Find command¶

Include: Use Db\DBCommands.pkg

Purpose¶

Finds records through a DD field or explicit index while using the DD local buffer and relation/constraint state.

Syntax¶

Find EQ oDataDictionary.Field
Find GT oDataDictionary.Field
Find GE oDataDictionary.Field
Find LT oDataDictionary.Field
Find LE oDataDictionary.Field
Find FIRST_RECORD oDataDictionary.Field
Find LAST_RECORD oDataDictionary.Field

Find GT oDataDictionary by 3

How it works¶

• Field form Find mode oDD.Field sends FindByField to the owning DD and uses the current field value as the find seed.
• Index form Find mode oDD by index sends FindByIndex to the DD and uses the DD's current indexed field values as the find seed.
• Successful finds seed the DD and related DD buffers returned by the adapter and set Found=True.
• A normal find miss sets Found=False and leaves the current buffer values in place for FindByField / FindByIndex.

Examples¶

Clear oCustomerDD
Move "Access Miles" to oCustomerDD.Name
Find EQ oCustomerDD.Name

Clear oCustomerDD
Find GT oCustomerDD by 3

See also¶

• Clear
• cDataDictionary FindByField
• cDataDictionary FindByIndex