Multi-table AOT query with Query::update_recordset

(0) Share

Report

Posted on by CU29041349-0

273

Hello,

Not sure if it's possible - I haven't seen examples of this. I have an AOT query joining ProjTable, ProjForecastCost, and a custom table (MyProjTable) linked by ProjId. I'm trying to update a boolean flag on MyProjTable if it is returned in the query. I provide the field mapping to MyCustTable for this boolean flag field. When Query::update_recordset() is called, I get an error (something to the affect of "field 'projects' is not found on table 'projtable'"). Doesn't appear Query::update_recordset is widely used -- maybe for a reason?

Categories:

Development / Customization / SDK

All responses (2)

Answers (0)

Layan Jwei 6,985 Super User 2024 Season 2 on at

Like (0)

Report

Multi-table AOT query with Query::update_recordset

Please show us your full code and maybe take screenshot of your query and if u have any ranges
Bharani Preetham Pe... 3,556 Moderator on at

Like (0)

Report

Multi-table AOT query with Query::update_recordset

Please share your code for better understanding.