摘要： Loading XML Data into SQL Server (SQL Spackle)"SQL Spackle" is a collection of short articles written based on multiple requests for similar code. These short articles are NOT meant to be complete solutions. Rather, they are meant to "fill in the cracks".--Phil McCrackenIntroductionWith XML becoming 阅读全文

摘要： Also, we should add one index for this query, otherwise, it will be reduce the performance   Here is a partial result set:   ItemId Sales Order Production Purchase Order 1000 -27 NULL 99 1001 -5453 NU... 阅读全文

摘要： 03 August 2009 by Pinal Dave Change Data Capture records INSERTs, UPDATEs, and DELETEs applied to SQL Server tables, and makes a record available of what changed, where, and when, in simple relation... 阅读全文

摘要： How it works:1. There is one special table in AOT\System Documentation\Tables\UtilElements, firstly, create a similar table UtilElements_Job with those fields: utilLevel(Enum: UtilEntryLevel), recordT... 阅读全文

摘要： 第一步,先在form的声明的地方声明变量： 第二步,数据源(datasource)对应的表的ini方法：       public void init()       {       super();       criteriaPosted=this.query().dataSourceName('YouTable').addRange(fieldNum(YouTable,FieldName))... 阅读全文

摘要： recCount = ABCShipTrans_ds.numberOfRowsLoaded();   Tips: How to set text to one control, for example, display the count of record in a IntEdit control: PackageCount 1. Set AutoDeclaration property... 阅读全文

摘要： 主要借用临时表 TmpFrmVirtual 阅读全文

摘要： 主Form 点击按钮弹出子Form 用于选择Employee. 阅读全文

摘要： 新手上路:X++中的subStr: Retrieves part of a string和平常我们用的SubString 不一样的是，_number 参数允许负数, 当_number < 0 时，表示从_position位置开始倒推几位.Example:Parameter Description _text The original string. _position The positio... 阅读全文

摘要： 新开博客，专注AX, 不过我还是个新手，个人倾向于业务方向。多多学习 阅读全文