4D v13.4Find in field |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D v13.4
Find in field
Find in field
The Find in field command returns the number of the first record whose targetField field is equal to value. After calling this command, value contains the value found. This feature allows you to execute searches using the wildcard character (“@”) on Alpha fields and then retrieve the value found. This command doesn’t modify the current selection or the current record. Historical note: In earlier versions of 4D, the Find in field command was named Find index key and only worked with indexed fields. Beginning with 4D v11 SQL, this limitation was removed and the command was renamed. In an audio CD database, during data entry let’s assume that you want to verify the singer’s name to see if it already exists in the database. Because homonyms can exist, you don’t want the [Singer]Name field to be unique. Therefore, in the input form, you can write the following code in the [Singer]Name field’s object method: If(Form event=On Data Change) |
PROPERTIES
Product: 4D
INDEX HISTORY
Modified: 4D v11 SQL TAGS Trouver clef index*** |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||