Wednesday, November 11, 2009

Keyword Options for X++ select Statements Keyword

Description

firstfast
Fetches the first selected record faster than the remaining selected records.

firstonly
Returns only the first selected record.

forupdate
Selects records for updating.

nofetch
Specifies that the Dynamics AX runtime should not execute the statement immediately because the records are required only by some other operation.

forceplaceholders
Forces the Dynamics AX runtime to generate a query with placeholder field constraints. For example, the query generated for the preceding code example looks like this: select * from myTable where myField1=?. Database query plans are reused when this option is specified. This is the default option for select statements that do not join table records. This keyword cannot be used with the forceliterals keyword.

forceliterals
Forces the Dynamics AX runtime to generate a query with the specified field constraints. For example, the query generated for the preceding code example looks like this: select * from myTable where myField1='value'. Database query plans are not reused when this option is specified. This keyword cannot be used with the forceplaceholders keyword.

forceselectorder
Forces the Microsoft SQL Server query processor to access tables in the order in which they are specified in the query. (No effect on Oracle.)

forcenestedloop
Forces the SQL Server query processor to use a nested-loop algorithm for table join operations. Other join algorithms, such as hash-join and merge-join algorithms, are therefore not considered by the query processor.

reverse
Returns records in reverse of the select order.

6 comments:

Anonymous said...

Hey, possibly this post is not on topic but in any event, I have been browsing about your site and it looks really neat. It is easy to see I am creating a new blog and I am struggling to make it look great, and supply excellent subject matter. I have learned a lot here and I look forward to additional updates and will be returning.

Anonymous said...

Great beat ! I would like to apprentice while you amend your website, how
could i subscribe for a blog website? The account
aided me a acceptable deal. I had been tiny bit acquainted of this your broadcast provided bright clear idea

My website :: http://www.jiexiu.gov.cn/

Anonymous said...

Phentemine's growing reputation for being risk free, natural and safe for permanent weight loss treatment has helped it to become a best supplement today. You can have far more power, far less passion of thirst, and very best of the total number of - you will find out a noticeable fat loss much more rapid. This is important query that you will want to answer,as many weight management capsules are designed to suppress your appetite.

Look into my blog post diet pills that work fast for women

Cindy Dy said...

You are an awesome blogger. This is one of the best blog I had visited so far. Hope to read more post from you in the future. Keep it up. God bless.

Bubble
www.gofastek.com

Silvia Jacinto said...


I really love your blog there's a lot to share. Keep it up.Visit my site too.

n8fan.net

www.n8fan.net

sarah lee said...

I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.


edupdf.org