0

Automatic field record

Hello, I have two table which contains same field ID 'Name '. From the first table a get value1 after long calculation and get value2 from table2 after long calculation also.

In another table I need the value3=value1+value 2.

But my problem is I have to select the 'Name' one by one after having table reference by I have 1000 records.

How to record automaticly the name in the table3 with the record on table1 or  table2.

Thanks.

2 replies

null
    • Sean
    • 5 yrs ago
    • Reported - view

    It would be similar to this example in the language reference...

     

    for p in (select Person)
    p.Haircolor := "red"

     

    You could attach something like this to a button...

     

    for r in (select Table3)

    r.Name := value1 + value2

    • Sean
    • 5 yrs ago
    • Reported - view

    Hi, I apologize, the solution is a bit more complicated. This works in the console, but only if the Record Id's in all 3 tables match. Do you know if that is the case with your tables?

     

    for r in (select Table3) do
    r.Name := text((select Table1)[number(Id) = number(r.Id)].Name) + text((select Table2)[number(Id) = number(r.Id)].Name);
    r.Name
    end

Login to reply

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 1535Views