SQL Scalar Variables
SQL scalar variables (otherwise known as local scalar variables) must be defined with type and set to a value before the variable can be used. This can be done in two steps or as a single step. Additional Links
Category Archives: Software
Using the Select Automation with Python Code Snippets
Select allows you to supplement the “canned” conditions and activities for Automation with Python code. The object passed to the code (context) depends on how the automation task is coded. The context can come from at least five sources. Python Hooks in Automation Automation can host Python snippets in both the condition and activity areas. The way automation… Read More »
Read/Write C# Properties and Indexers with IronPython
This topic is designed to provide examples of how to use C# libraries in IronPython executing in SoftPro Select. While the examples are valid for all C# uses, the objects used may be unfamiliar to many. TLDR In C#, properties typically hide class variables and allow the developer to validate user inputs. It also allows developers to allow… Read More »
Loading Additional .NET Assemblies
There are times you want to add an additional .NET library to your code. It might be an actual Microsoft assembly or from another vendor. First you import CLR then add the desired assembly. (Note that the DLL must be either in the GAC or the executable folder.) Finally import the type/class namespace(s). If you want to minimize… Read More »
Using the Select Order Document Visibility Condition with Python
Select allows you to write expressions that can show or hide documents and reports from a potentially large list of order reports. This is very handy since it allows you to filter out reports that are not relevant to the order (hides HUD-1 reports if the order is a CDF) or to the user that has the order… Read More »
Properties and Methods with IronPython
This page is designed to provide examples of using .NET features in IronPython when creating Softpro Select content. The comprehensive example is here but I’ll provide examples in a form you are more familiar with. In all the code below, “order” is always the top level order object. For instance, in a custom order rule (COR), it is… Read More »
Storing Program Data in the Application Settings
What do you do if your application has default settings but you want the user to be able to change them (for instance, background colors or font settings) and reload them the next time your app starts? You can store them in several places but this topic is about putting them in your application config file. When you… Read More »