Skip to content
SEARCH THE COMMUNITYFind an existing answer
63 results for “X++”
CommunityHow do I refresh a form datasource after updating a record in X++?I’m updating a record in X++ outside of the form datasource. The update is saved to the database, but the form continues to show the old value until I manually refresh it.
What is the correct way to refresh the datasource after the update? I’ve seen refresh(), reread(), researCommunityHow do I see the SQL generated by an X++ select statement?I have an X++ select statement and want to see the actual SQL that D365FO generates behind it.
Is there a way to get the generated SQL without actually running the query?CommunityHow do I use `select firstOnly` in X++?How do I use select firstOnly in X++?CommunityHow do I join two tables in an X++ select statement?How do I join two tables in an X++ select statement?CommunityHow do I use multiple joins in an X++ select statement?How do I use multiple joins in an X++ select statement?CommunityWhat is the difference between `join`, `outer join`, `exists join`, and `notexists join` in X++?What is the difference between join, outer join, exists join, and notexists join in X++?CommunityHow do I use `exists join` in X++?How do I use exists join in X++?CommunityHow do I use `notexists join` in X++?How do I use notexists join in X++?CommunityHow do I use `outer join` in X++?How do I use outer join in X++?CommunityHow do I add an OR condition to an X++ select statement?How do I add an OR condition to an X++ select statement?CommunityHow do I use multiple where conditions in X++?How do I use multiple where conditions in X++?CommunityHow do I use `order by` in an X++ select statement?How do I use order by in an X++ select statement?CommunityHow do I use `group by` in X++?How do I use group by in X++?CommunityHow do I use `sum`, `count`, `avg`, `min`, and `max` in X++?How do I use sum, count, avg, min, and max in X++?CommunityHow do I select records between two dates in X++?How do I select records between two dates in X++?CommunityHow do I check if a record exists in X++?How do I check if a record exists in X++?CommunityHow do I get the first matching record in X++?How do I get the first matching record in X++?CommunityHow do I update multiple records using `update_recordset` in X++?How do I update multiple records using update_recordset in X++?CommunityHow do I delete multiple records using `delete_from` in X++?How do I delete multiple records using delete_from in X++?CommunityWhat is the difference between `while select` and `QueryRun` in X++?What is the difference between while select and QueryRun in X++?CommunityHow do I convert an X++ select statement into a Query object?How do I convert an X++ select statement into a Query object?CommunityHow do I get the SQL statement generated by an X++ query?How do I get the SQL statement generated by an X++ query?CommunityHow do I create a query dynamically in X++?How do I create a query dynamically in X++?CommunityHow do I add a range to a QueryBuildDataSource in X++?How do I add a range to a QueryBuildDataSource in X++?CommunityHow do I add multiple ranges to a query in X++?How do I add multiple ranges to a query in X++?CommunityHow do I add an OR range to a query in X++?How do I add an OR range to a query in X++?CommunityHow do I use `SysQuery::value()` in X++?How do I use SysQuery::value() in X++?CommunityHow do I clear a query range in X++?How do I clear a query range in X++?CommunityHow do I get records from a QueryRun in X++?How do I get records from a QueryRun in X++?CommunityHow do I refresh a form datasource after updating a record in X++?How do I refresh a form datasource after updating a record in X++?CommunityHow do I get the current record from a form datasource in X++?How do I get the current record from a form datasource in X++?CommunityHow do I refresh a form control in X++?How do I refresh a form control in X++?CommunityHow do I enable or disable a form control in X++?How do I enable or disable a form control in X++?CommunityHow do I hide a form control in X++?How do I hide a form control in X++?CommunityHow do I filter a form datasource in X++?How do I filter a form datasource in X++?CommunityHow do I create a lookup in X++?How do I create a lookup in X++?CommunityHow do I hide enum values from a combo box in X++?How do I hide enum values from a combo box in X++?CommunityWhat is the difference between `insert()`, `doInsert()`, and `insert_recordset` in X++?What is the difference between insert(), doInsert(), and insert_recordset in X++?CommunityWhat is the difference between `update()` and `doUpdate()` in X++?What is the difference between update() and doUpdate() in X++?CommunityWhat is the difference between `delete()` and `doDelete()` in X++?What is the difference between delete() and doDelete() in X++?ArticleCollections (List, Map, Set)Learn how List, Map, and Set collections work in X++ and when to use each one.ArticleMacros in X++Learn what macros are in X++, when they're useful, and why they should be used carefully.ArticleCreate D365FO X++ Objects in Seconds with XppForgeThe XppForge Visual Studio extension helps D365 Finance & Operations developers generate X++ artifacts directly inside Visual Studio. Learn how to generate classes, SysOperation frameworks, Chain of Command extensions, forms, security objects, and more.ArticleHow to Debug Standard D365FO Code and Find Which X++ Method Is RunningLearn how to find and debug the standard X++ code running behind D365FO processes using breakpoints, Find References, the Call Stack, table methods, and Trace Parser.ToolX++ FormatterSyntax-aware X++ formatting that preserves comments, strings, directives, and executable meaning.ToolX++ Syntax CheckerValidate balanced X++ tokens and surface actionable structural errors.ToolX++ Best-Practice AnalyzerDeterministic best-practice findings with severity and correction guidance.ToolX++ Complexity AnalyzerMeasure methods, branches, lines, and a cyclomatic-complexity estimate.ToolX++ Naming Convention ValidatorReview identifiers against practical X++ naming conventions.ToolX++ Code ComparisonCompare two X++ versions with a structured line-level summary.ToolX++ Code ExplainerExplain recognized transactions, queries, extensions, and database patterns locally.ToolX++ Performance Pattern AnalyzerFlag unbounded selects, wide reads, and common N+1 access patterns.ToolX++ Security Pattern AnalyzerFlag direct SQL, asserted permissions, and constructed-query risks.ToolX++ Transaction Scope CheckerReview ttsBegin, ttsCommit, ttsAbort, and transaction-sensitive writes.ToolSQL to X++Convert a documented SQL SELECT subset into classic X++ and QueryBuildDataSource code.ToolX++ Select to SQLTranslate a documented basic X++ select subset into reviewable SQL.ToolX++ Query BuilderBuild ranges, joins, fields, sorting, and QueryBuildDataSource scaffolding.ToolCSV to X++ Test DataConvert explicit CSV rows into X++ test-buffer assignment scaffolding.ToolJSON to X++ ClassGenerate a DataContract class from a JSON object.ToolXML to X++ ClassGenerate a DataContract class from simple XML elements.ToolX++ Map to JSONGenerate deterministic Map-to-JSON serialization scaffolding.ToolX++ Parm Method GeneratorGenerate a typed backing field and conventional parm method.ToolX++ Unit Test GeneratorCreate SysTestCase scaffolding with Arrange, Act, and Assert sections.
XppForge