Finding string value within a database

I had a need to track down which columns in the system had a particular string value. I used the below stored procedure to identify the tables and columns that contained a particular string value.

This script is designed to only find string values within the system, only looking at string fields that are large enough store the entire string.

Continue reading

Advertisements

Using getSelectedData

The method getSelectedData is a form grid control used to get all the currently selected (marked) records in the grid. This can be a usual command, but how can you use this information. Below is an example piece of code, based on the mouse double click control on a form that shows how you can extract the information from this method:

Continue reading