338
Can I calculate a "new column" with a value from another column that has been feched with a query object?
I have a Currency factor that I have to calculate as 1/Currency Factor and show this value instead of Currency Factor, is there any way to achive this in a Query Object?
TIA!
Hi
Yes you can create a query object with a field. .
and then go to page where you want to show the query object value.
in trigger onaftergetrecord of the page right the below logic
trigger OnAfterGetRecord
var
Query_Customer: Query BLL_QUERY_CUSTOMER;
begin
Clear(Query_Customer);
if Query_Customer.Open() then
if Query_Customer.Read() then
CustomerCount := Query_Customer.CountUnique; // assign your field value Calculatedfieldvalue :=1/ Query_Customer.Amount;
Query_Customer.Close();
end;
If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
