12 2010 档案

摘要: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... 阅读全文
posted @ 2010-12-31 16:08 AOT 阅读(282) 评论(0) 推荐(0)
摘要: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... 阅读全文
posted @ 2010-12-10 15:55 AOT 阅读(371) 评论(0) 推荐(0)
摘要: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... 阅读全文
posted @ 2010-12-08 13:30 AOT 阅读(357) 评论(1) 推荐(0)
摘要:第一步,先在form的声明的地方声明变量: 第二步,数据源(datasource)对应的表的ini方法:       public void init()       {       super();       criteriaPosted=this.query().dataSourceName('YouTable').addRange(fieldNum(YouTable,FieldName))... 阅读全文
posted @ 2010-12-08 10:18 AOT 阅读(281) 评论(0) 推荐(0)
摘要: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... 阅读全文
posted @ 2010-12-07 11:34 AOT 阅读(275) 评论(0) 推荐(0)