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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (