Update a Table in a Form whith another table

(0) Share

Report

Posted on by Ulyses Rico

630

Hello, I have two tables in a form, Customer and Transaction, when I add a transaction the sum of amount should appear in a field called "Sum" in the table customer. It updates correctly the amount but when I touch the table costumer, how can the first table be updated automatically when I add a transaction?

Thanks, by the way, all the the answers that you have sent to me before have been very helpful!

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Pradeep Itnal 3,248 on at

Like (0)

Report

try to put your code in linkActive() method.

Was this reply helpful? Yes No
dolee 11,279 on at

Like (0)

Report

Hi,

I assume the Transaction record has to be "saved" before the amount in Customer table should be updated.

In that case, you can modify the write() method of Transaction_ds, add code there to recalculate related Customer's sum field. At the end, add:

customer_ds.reread();

customer_ds.refresh();

to refresh the customer record.

Regards

Was this reply helpful? Yes No
Ali Zaidi 4,657 on at

Like (0)

Report

You have to implement some code in LinkActive() method, something like following

public void linkActive()

{

;

switch(element.args().dataset())

{

case tablenum(SalesTable) :

salesTable = element.args().record();

break;

case tablenum(SalesQuotationTable) :

salesQuotationTable = element.args().record();

break;

}

super();

}

Was this reply helpful? Yes No
Ulyses Rico 630 on at

Like (0)

Report

Ammm, I have applied your suggests but I haven't succed, I'm doing something wrog.

This is the code I have in the modifyfield method from the transaction table:

public void modifiedField(FieldId _fieldId)

{

GRW_Cliente cliente;

GRW_TRAN transaccion;

super(_fieldId);

if(FieldNum(GRW_TRAN,MontoOriginal) | FieldNum(GRW_TRAN,Moneda)|fieldNum(GRW_TRAN,MontoCalculado))

{

if(this.Moneda!="")

{

if(this.Moneda==CompanyInfo::standardCurrency())

{

this.MontoCalculado=transaccion.GRW_calculateTransactionToAccounting(this.Moneda,this.MontoOriginal);

}

else

{

this.MontoCalculado=this.MontoOriginal*12.00;

}

cliente.Saldo =cliente.displayCalculatedBalance();

}

}

}

I've written it in the linkmethod but nothing happened. The sum of the balance is right when I move some data from the transaction table, because in the modifiedfield method I said that when the transaction amount is changed a method that calcules the balanced is fired.

Any help fellows? Thanks!

Was this reply helpful? Yes No
Ulyses Rico 630 on at

Like (0)

Report

I also wrote on the datasource methods and no success

Was this reply helpful? Yes No
dolee 11,279 on at

Like (0)

Report

In the code you posted, you have:

cliente.Saldo =cliente.displayCalculatedBalance();

1) You didn't have any select statement for the Cliente buffer.

2) You didn't save the cliente buffer after you assign a new value to the Saldo field. You'll need a cliente.update() there.

Please see if the above help.

Regards

Was this reply helpful? Yes No
Ulyses Rico 630 on at

Like (0)

Report

I addes the cliente.updated() at the end but it showed me an error, that the record already exists, I also used a cliente.write but it appeared the same error. When I use the linkactive from datasource methods it doesn't work for me because what I want is not to click the table customer to be updated.

Was this reply helpful? Yes No
dolee 11,279 on at

Like (0)

Report

Have you add record selection for Cliente before your assignment? Since you are calling the "update" method, normally it shouldn't throw error saying the record already exists. (Because we are suppose to be *updating* an existing record right?)

For example, if I want to update VendTable (vendor) record, I would do the following.

----------------------------------

ttsbegin;

// First, select the record I want to update

select firstonly vendTable

where vendTable.accountNum == "V001";

// Then, do the value assignment

vendTable.name = "new name";

// Finally, call the update method.

vendTable.update();

ttscommit;

----------------------------------

Regards

Was this reply helpful? Yes No