How can I get all keys from the table referred by the record

EddieEddie Member Posts: 26
edited 2004-05-02 in Navision Attain
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

Comments

  • RobertMoRobertMo Member Posts: 484
    This is bug in 3.60 and 3.70.
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
Sign In or Register to comment.