Hello!
Could anybody help me?
How can I get all keys from the table referred by the recordref.
For example:
In the table are 20 keys. 10 are active and 10 are disabled. First 5 keys and last 5 keys are active. Between them are 10 disabled keys. RecordRef.KEYCOUNT is return the number of active keys (in this case 10). I’m going to create a key reference by RecordRef.KEYINDEX(Index). I can get first 5 active keys and first 5 disabled keys and no more. How can I get the rest of the keys, because RecordRef.KEYINDEX(11) .. RecordRef.KEYINDEX(20) generate unhandled errors.
My code:
Table.OPEN(TableNo); // Create a record reference to a table.
FOR KeyNo := 1 TO Table.KEYCOUNT DO BEGIN
Key := Table.KEYINDEX(KeyNo);
IF NOT Key.ACTIVE THEN EXIT;
FOR i := 1 TO Key.FIELDCOUNT DO BEGIN
Field := Key.FIELDINDEX(i);
KeyString := STRSUBSTNO('%1%2%3',KeyString, Separator, Field.NAME);
Separator := ',';
END;
END;
THX
0
Comments
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯