#1 An attempted INSERT of a duplicate key will return VE. For further information refer to VAL_ERROR in the BROWSE command parameters.
#2 A SELECT command using a WHERE parameter will select each record and test for the condition. When the last record is selected the processing will leave the SELECT loop with the data from the last record selected. This record may not have met the WHERE condition.