Microsoft Ax技术培训.ppt

Menu Menu由部分菜单项组成 Demo 谢谢大家！MSN：zhaobinzhang99@E-mail:zhangcb@ 结束 * * 具体功能介绍 Query模型: 直接查询 select 查询方式 select [reverse] [firstfast] [firstonly] [forupdate] [nofetch] [nolock] [forceliterals | forceplaceholders] [forcenestedloop] [forceselectorder] [ * | fieldlist from] tablebuffer [ index [hint] indexname ] [ group by {field} ] [ order by {field [desc]} ] [ where expression ] [ [ outer | exists | notexists ] join [reverse] [ * | fieldlist from] tablebuffer [ index indexname ] [ group by {field} ] [ order by {field [desc]} ] [ where expression ] ] fieldlist ::= field | fieldlist , field field ::= fieldname | function(field) function ::= sum | avg | minof | maxof | count 注意 ：从效率上考虑，少用嵌套，多用连接（join） 关键字说明 firstfast Speeds up the fetch. This is a priority hint that means that the first row will appear quicker but the total return time for this option may be slower. A typical use of the option is for dialog updates. firstonly Speeds up the fetch. This gets MorphX to only fetch the first record. forupdate Selects records exclusively for update. The operation to be performed on the records that are fetched is an update. Depending on the underlying database, the records may be locked for other users. sum Returns the sum of the fields from the rows given by the group by clause. Can be used to sum all accounts, order lines etc. avg Returns the average of the fields from the rows given by the group by clause. minof Returns the minimum of the fields from the rows given by the group by clause. maxof Returns the maximum of the fields from the rows given by the group by clause. count Returns the number of fields from the rows given by the group by clause. order by Instructs the database to sort the selected records by fields in the order by list group by Instructs the database to group selected records by fields in the order by list asc An option on the order by or group by clause. The sorting is ascending. desc A