Monthly Archives: January 2006

ForceSelectOrder & ForceNestedLoop

ForceSelectOrderUsing ForceSelectOrder will enforce SQL server to access the tables in a join in the given order. It means that performs joins in the order in which the tables appear in the query. Otherwise, SQL Server chooses the order.   … Continue reading

Posted in Axapta Development | 1 Comment

ForceLiterals & ForcePlaceholders

When you use forceliterals keywords in Axapta, Axapta will issue SQL statements directly to the database as text string. SELECT forceLiterals * FROM purchTable     WHERE purchId == ‘EN00009’ ; In SQL server, it will be:SELECT A.VALUE, A.MODIFIEDTIME, A.CREATEDTIME, A.RECID … Continue reading

Posted in Axapta Development | 1 Comment