Clear sql buffer and cache

Numbers Table

Reference parent datacontext binding.

Rebuild indexes

Wrong threads crash

Put the following in the viewmodelBase

Example call

Adding a foreign key

Adds foreign key in tblDisplay for lnkclientID which exists in tblClient as IDClient


Adding weak Link

Adds a weak link (lnkAddressID) between tbl_SUB_SubscriptionContract and tbl_SUB_Address. Conditions accepted:

- ID has to exist in tblAddress

- 0 values accepted



The DateAdd() Functions adds/subtracts a specific interval to a specified date



Using the DateAdd function in a loop to add 1 month to each date

Data Execution Prevention workaround

If you ever get those applications that wont allow you to run more than one instance, try the following:

- Right click on “Computer” or “My Computer”
- Select “Advanced” or “Advanced System settings”
- Under Performance heading; select “Settings”
- Select “Data Execution Prevention”
- Select “Turn on DEP for all programs and services except those I select.
- Select “Add” and add the required programs to the list.
- Hit Ok

Hope that helps!! :)