The Table_VerifyRecord() function verifies the contents of the fields in a record for the specified table.
Table_VerifyRecord(product_ID, table table_name, field_name)
• product_ID – An integer specifying the product ID of the dictionary containing the table for which records are being verified.
• table table_name – The table containing records being verified.
• field_name – A returned string indicating the name of the first field for which an error was encountered.
An integer specifying the error code for the verify operation. If the value returned is zero, no error occurred. Any other number indicates that an error was encountered. The following table lists each error code and its corresponding description.
Value |
Description |
---|---|
600 |
Negative value for a list field |
601 |
Invalid value for check box field |
602 |
Invalid value for boolean field |
603 |
Invalid digits for currency field |
604 |
Invalid length string for combo box field |
605 |
Invalid length for string field |
606 |
Invalid date field |
607 |
Invalid time field |
608 |
Negative length for a text field |
609 |
Negative length for a picture field |
610 |
Invalid digits for a variable currency field |
This function is used to rebuild tables. It will check for the following conditions: