get all values of field in table for writing in the variable of array

Answers

• ShaiHulud Member Posts: 228

  2020-01-17 edited 2020-01-17

  If I understand correctly, then you have a table with a field (let's call it "Value"), and you have 10 records in that table, right? In that case, this code should do it:

  NoOfValues := 0;
  if MyTable.FindSet then begin
    repeat
      NoOfValues += 1;
      MyArray[NoOfValues] := MyTable.Value;
    until MyTable.Next = 0 or NoOfValues = 10;
  end;

  
  Here:
  NoOfValues : Integer;
  MyArray : Integer[10];
  MyTable : Record "My Table";

  1
• MarharytaMykytenko Member Posts: 53

  2020-01-17

  ShaiHulud wrote: »

  If I understand correctly, then you have a table with a field (let's call it "Value"), and you have 10 records in that table, right? In that case, this code should do it:

  NoOfValues := 0;
  if MyTable.FindSet then begin
    repeat
      NoOfValues += 1;
      MyArray[NoOfValues] := MyTable.Value;
    until MyTable.Next = 0 or NoOfValues = 10;
  end;

  
  Here:
  NoOfValues : Integer;
  MyArray : Integer[10];
  MyTable : Record "My Table";

  
  Thanks a lot for your answer
  But whether the variable MyTable in relations with field in table?

  0
• MarharytaMykytenko Member Posts: 53

  2020-01-17

  Oh, thank you
  Code works in right way
  Thank you a lot))))))))))))

  0
• borowskiy Member Posts: 1

  2024-06-12

  Thanks for the information!

  0