Create a new ProjectProject > Shared > New > Project and give it a name. Having all created/modified objects in a single project will help you to be more organised and will allow you to easily export your work to production environment.
Highlighting all the records in a grid (including NOT loaded ones)
Let’s say we have some Control in a Form of type CheckBox, Button or StringEdit and we want it them once modified/clicked to update the form grid by selecting all the records in a grid.
An example of While/Select statements to find InventSerials, when Works Order is known. Here I also will use a chance to note the ListEnumerator. No Joins are used in this example.
An example of achieving same result using Queries.
1) Trace flags 4136 ,1117 and 4199 enabled on SQL server.
DBCCTRACEON(4136,-1)DBCCTRACEON(1117,-1)/* If you've configured multiple data files and you want to allow auto grow, consider enabling trace flag 1117, which will force all data ...