Value added in Table

dheebans

Dear All,

i have one doubt ,

One table have multiple records

Like
Table : X

a := 45;
b := 25;
C := 12;
a := 34;
b := 25

I have to insert another table
like
Table :Y

a := 79;
b := 50;
c := 12

Now i am using
RecCount := Integer Variable,
RecCount := X.Count ;
For i := 1 To RecCount Do
IF a = a then
NewValue += Qty;

i have doubt have to add the same Values.

I hope your Valuable Answer.



Thanks & Regards
DheebanS

kriki

[Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]

Belias

your problem is not to add the quantity but to know how to read a table!
please study some manual before programming, because it would be too difficult for any of us to explain how to do your work from the beginning!

Troubles_In_Paradise

x.RESET;
y.RESET;
IF x.FINDSET THEN BEGIN
  REPEAT
    IF y.GET(x.letter) THEN BEGIN
      y.val += x.val;
      y.MODIFY;
    END ELSE BEGIN
      y.INIT;
      y.letter := x.letter;
      y.val := x.val;
      y.INSERT;
    END;
  UNTIL x.NEXT = 0;
END;

if the PK of your Y table is not the field letter you have to replace the "Get".

dheebans

Dear mirko,


I solved the value added problem, using flowfield and sumindex field.

Thanks for your advice, if you have development material . pls upload the link.



Regards
DheebanS

Belias

there should be a senior developer with you who can indicate you the correct studying materials.

https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID={8D87C506-6200-4FFB-89AA-4D5C8F7F807D}&NRORIGINALURL=/partnersource/communities/training/Certifications/exampreparation/MBS_Nav_prep.htm&NRCACHEHINT=Guest&wa=wsignin1.0

Cside introduction and cside development training materials are fine to begin with (but also check the online help)