How can I get the selected value before I write it in the strigedit?

(0) Share

Report

Posted on by ismaelivan

578

Before writing to the stringedit, I want to validate the selected value, because I need to insert that value in another table.

public boolean validate()
{
GCuttingDieTable gCuttingTable;
boolean ret;

ret = super();

...

gCuttingTable.CuttingDieId = SELECTED VALUE;
gCuttingTable.CuttingDieCategory = 2;
gCuttingTable.CustAccount = GCalcTable.CustAccount;
gCuttingTable.insert();

...

return ret;

}

Thanks in advance!.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!
Hi,

You can override validateField method on the table GCuttingDieTable to include validations and insertlogic on stringedit.

Typically your code looks like below

public boolean validateField(FieldId _fieldIdToCheck) { GCuttingDieTable gCuttingDieTableLocal; boolean ret; ret = super(_fieldIdToCheck); if (ret) { switch (_fieldIdToCheck) { case fieldNum(GCuttingDieTable, Field): select gCuttingDieTableLocal where gCuttingDieTableLocal.Id == this.Field; // to include validations // Include your insert code break; default: break; } } return ret; }

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!
Thanks Chaitanya, but this form does not contain the gcuttingdietable table, I try to validate inside the GraCalcPrintBind form.

The field is CuttingDieId (GCalcSheetLine)

And i have the next code in Lookup Method...

public void lookup() { Query query = new Query(); QueryBuildDataSource queryBuildDataSource; QueryBuildRange queryBuildRange; SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(InventDim), this); sysTableLookup.addLookupField(fieldNum(InventDim, InventBatchId)); sysTableLookup.addLookupField(fieldNum(InventDim, wMSLocationId)); sysTableLookup.addLookupField(fieldNum(InventDim, InventLocationId)); queryBuildDataSource = query.addDataSource(tableNum(InventDim)); queryBuildRange = queryBuildDataSource.addRange(fieldNum(InventDim, InventBatchId)); sysTableLookup.parmQuery(query); sysTableLookup.performFormLookup(); //super(); }

Was this reply helpful? Yes No
Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Yeah, I mean you can write your code on validateField method of gcuttingdietable and include logic to insert data in other table.

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

This is my stringedit

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Use this statement in your validate method:

gCuttingTable.CuttingDieId = this.valueStr();

and your code looks like

public boolean validate() { GCuttingDieTable gCuttingTable; boolean ret; ret = super(); ... if (ret == true) { gCuttingTable.CuttingDieId = this.valueStr(); gCuttingTable.CuttingDieCategory = 2; gCuttingTable.CustAccount = GCalcTable.CustAccount; gCuttingTable.insert(); } ... return ret; }

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

I had already tried whit "gCuttingTable.CuttingDieId = this.valueStr ();" but the stringedit has no value.

Because before validates if that value exists in the GCuttingDieTable table.

Was this reply helpful? Yes No
Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Can you provide your screenshot with error in english and I think there is some problem with your lookup, can you provide that code too.

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

The mistake is "The value '319177-P130074-CAJA' in field 'CuttingDieId' is not found in the related table 'gCuttingTable.'"

The values in the combo come originally from the InventDIm table, but when you select one in the list, I create a new record in GCuttingDieTable with those 3 columns. For that reason I need to obtain the values or only the recid of the selected row.

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!
The solution was to create a new lookup form, and from there get the recid to send it to a method in the caller form.

public void closeSelect(str _selectString) { super(_selectString); if(this.args().caller().name() == "GraCalcPrintBind") { this.args().caller().MyMethod_GetRecId(InventDim.RecId); } }

Thank very much!

Was this reply helpful? Yes No