You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Great powershell script for tightening HTTPS security on IIS and disabling insecure protocols and ciphers. Very useful on core installations.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Utility code for working with OpenInsight RDK's. Currently useful for saving an RDK as a file or copying an RDK view (list of things to make and RDK of) to another copy of OpenInsight.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Function accepts and OpenInsight table handle and resolve the handle back to a table name.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Simple OpenInsight logging utility for recording log files from your code.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
This scratch OpenInsight routine is a wrapper around RLIST that has conditional error trapping and optional progress indicator. I often found myself writing a bunch of boiler plate code to manage the protection of the active select list, progress display, and breaking (or ignoring) errors. This wraps it up to one method and returns a list of key…
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
The authoritative list of OpenList LIST and SELECT statement keywords for OpenInsight is found in the Programmer's Reference Manual under the section 'Appendix A: OpenList Keyword Reference > With'. It's difficult to find when using the help file index or search feature. Below are a few of my favorite examples.
Selecting Data
Executing a select statement will return the number of rows found and set the in memory active list of keys which can be accessed using a list statement.
Select records in table based on key name
@ID contains the name of the record key, use this field in you comparison criteria.
SELECT INVENTORY WITH @ID GT 100 AND @ID LT 200
Select records in table based on a search term in the beginning or ending of a field
@ID contains the name of the record key, use this field in you comparison criteria. For example find all window source code belonging to the EXAMPLES app. The right bracket operator means 'beginning with'.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters