Modifying PrimaryKey

clembo

I have a table with only two fields (Field1 and Field2). Both fields are part of primary Key. When i try to modify one of these fields system shows an error because cannot find the record to modify.
This is the code:

recRelation.SETFILTER("Field1",'%1',lrecDoc."Nr.");
IF recRelation.FIND('-') THEN
REPEAT
recRelation."Field1" := lrecoDocRec."Nr.";
recRelation.MODIFY; // Here it's breaks code execution and shows an error
UNTIL recRelation.NEXT = 0;

How I solve this problem?

kapamarou

When you want to modify the primary key you can either use the RENAME command OR
delete the record and insert the new one (here you'll have to change manually the table relations). You cannot use MODIFY.

Alex_Chow

Also, you may get in trouble with a repeat loop since after you rename the primary key, it'll resort and throw your sequence off.

garak

use for this

Record.RENAME(Value1, [Value2],...)

where "Value" are the PK field values.
But don't use rename in a loop on the same Record variable. Use here a second record variable and rename there.

like:

RecVar.find('-');
repeat
  RecVar2.get(RecVar.PKValues);
  RecVar.rename(NewValueofPKFields);
until RecVar.next = 0;

Regards

Alex_Chow

I would sort it using another key then do a rename. This way, the record does not get sorted based on the changing of the primary key.