- Browse Layouts - Find by Key - Scroll Found Record to Top
/pages/Guides/Desktop/Design/View/Browse/Browse Layouts Find by Key Scroll Found Record to Top.xml
In V9 and earlier, when using the Find by Key dialog in a Browse, the record that was found was scrolled to the top of the browse. In V10, the record pointer was moved to the found record, but the record remained in its current scroll position.
- Find by Key
/pages/Guides/Desktop/Design/View/Form/Find by Key.xml
The Find by Key dialog is available in both forms and browses, and lets you find the first record whose key value most closely matches a key value you specify. The Find by Key dialog does not require that you have at least one predefined index. If there are no indexes, it will allow you to search by record number or within a specified field.
- Find by Key Dialog (Standard)
/pages/Guides/Desktop/Design/Platform/Xbasic Action Scripting/Find by Key Dialog, Standard.xml
The Find by Key Dialog (Standard) action displays the Find by Key dialog.
- Find by Key - Action Scripting
/pages/Guides/Desktop/Design/Platform/Xbasic Action Scripting/Find by Key.xml
The Find by Key action searches for records matching a specified key value using the Find by Key dialog. This action gives you the option to specify the key to search for in advance, or prompt the user at run-time.
- Find by Key Dialog (Custom)
/pages/Guides/Desktop/Design/Platform/Xbasic Action Scripting/Find by Key Dialog, Custom.xml
The Find by Key Dialog (Custom) action displays the Find by Key dialog. It allows you to customize the settings of the dialog or leave them up to the user.
- Go to Record Key
/pages/Guides/Desktop/Design/Platform/Xbasic Action Scripting/Records/Go to Record Key.xml
The Go to Record Key action displays the records matching a key value. The key value can be defined ahead of time, or by prompting the user at run-time.
- Using an Index to Find a Record
/pages/Guides/Desktop/Design/View/Database/Using an Index to Find a Record.xml
The following script is provides a simple example of how to use an index to determine whether a record exists, and to act accordingly. To start, we create an index based on lastname and firstname named "LF". The Order Expression for the index is alltrim(lastname) + "," + alltrim(firstname).
- Using a Query to Find a Record
/pages/Guides/Desktop/Design/View/Database/Using a Query to Find a Record.xml
The following script shows how a query works. First, we open a table and set the query dot variable parameters. In this case the default record order is fine. We only filter for records where the field Bill_State_Region equals "MA". Finally, we create the query list.
- Find by Form
/pages/Guides/Desktop/Design/View/Form/Find by Form.xml
The Find by Form dialog box is available on forms only, and lets you type search criteria directly into the same form you are viewing. Find by Form does not filter out records that do not meet your search criteria, or put records in order. It simply displays the next or previous matching record.Find by Form opens a blank record for you to enter search criteria. For example, if you are looking for a record for a person with the last name " Jenkins ," type " Jenkins " in the LASTNAME field.To use Find by Form :
- Add primary key to all ORDER BY clauses
/pages/Guides/Mobile and Web Components/Grid/Grid Properties/Advanced/addprimarykeytoallorderbyclauses.xml
Used to guarantee ORDER BY clause criteria is unique in Grid Components based on a SQL database.